471,306 Members | 850 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

Export to Excel from Asp.net

Sen
Hi,
i want to export data from a datagrid to excel sheet. I'm able to do it
using RenderControl method of the datagrid. But i do not have any control
over the column width of excel sheet. Is there any way to format the columns?
i do not want to use server side object creation techniques, since it is
giving problems in destroying the excel objects,that are created. Any help
would be really appreciated.
Nov 19 '05 #1
1 1261
On Fri, 21 Oct 2005 02:51:02 -0700, Sen <Se*@discussions.microsoft.com> wrote:

¤ Hi,
¤ i want to export data from a datagrid to excel sheet. I'm able to do it
¤ using RenderControl method of the datagrid. But i do not have any control
¤ over the column width of excel sheet. Is there any way to format the columns?
¤ i do not want to use server side object creation techniques, since it is
¤ giving problems in destroying the excel objects,that are created. Any help
¤ would be really appreciated.

Unfortunately column formatting requires the Excel application so I'm afraid there is no workaround
for this feature. The only other option might be to use a document template where the columns have
already been formatted.
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Matt | last post: by
6 posts views Thread by Elena | last post: by
13 posts views Thread by Hemant Sipahimalani | last post: by
5 posts views Thread by Simon | last post: by
3 posts views Thread by =?Utf-8?B?YzY3NjIyOA==?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.