On exporting to excel

[shiva]

Hi,
Export data to Excel Problem:
In ExportToExcel() method,i am facing the problem when huge amount of data is there, in excel it is showing "########",
When we double click on that cell it is showing the content.
        ............................
       binded datatable data to gridview
        .................................
       //int wid = 120;
        // //GridView1.Columns["Description"].ItemStyle.Width=wid;
        //GridView1.Columns[3].ItemStyle.Width = Unit.Percentage(40);
        // GridView1.Columns[3].ItemStyle.Width = Unit.Pixel(40);
      GridView1.RenderControl(hw);
        //style to format numbers to string
        string style = @"<style> .textmode { mso-number-format:\@; } </style>";
        Response.Write(style);
        Response.Output.Write(sw.ToString());
        Response.Flush();
        Response.Close();
        Response.End();
}

Help me in this problem,or let me know if there is any alternative..
Thanking you..

[Daniel]

Hello Shiva,

As far as I can see you do not use the built-in RadGrid export.
Basically, you can increase the column width to avoid this behavior.
Word/Excel export (HTML-based)

Best regards,
Daniel
the Telerik team

[shiva]

In ExportToExcel() method,i tried with this
 "GridView1.Rows[i].Cells[3].Width = 1000;".but in excel sheet it is increasing the column width, but not displaying the content.displaying ######.

        ............................
       binded datatable data to gridview
        .................................

for (int i = 0; i < GridView1.Rows.Count; i++)

{

 

//Apply text style to each Row

 

GridView1.Rows[i].Cells[3].Width = 1000;

GridView1.Rows[i].Attributes.Add("class", "textmode");

}

          GridView1.RenderControl(hw);
        //style to format numbers to string
        string style = @"<style> .textmode { mso-number-format:\@; } </style>";
        Response.Write(style);
        Response.Output.Write(sw.ToString());
        Response.Flush();
        Response.Close();
        Response.End();
}

Is there any way to this.to get the content.
Thanks

[Daniel]

Hello Shiva,

Please post your questions about the GridView control in the following forum:
ASP.NET Forums

For more information about Telerik RadControls for ASP.NET AJAX and RadGrid, please visit the links below:
Overview of Telerik RadGrid structure
Accessing cells and rows
Word/Excel export (HTML-based)

Regards,
Daniel
the Telerik team