Last post Mar 23, 2008 04:03 PM by kamii47
Mar 20, 2008 07:02 AM|kamii47|LINK
I want's to create a Exel worksheet on the button click event.
when I click my GenerateExcelFile File save dialog should come with the name of my file "abc.xls"
[After downloading i want's to remain on my page]
Secondly Please suggest how can i generate the Excel file.Currrently I have a DataTable with the data which I needed to export.
But my excel file also have some other information like some string coming from the database as header
I don't have any access on the server so i can't install any thing there.
Although i haven't use Microsoft.Office.Interop.Excel but let me know should i needed to install it on the server incase i use that
I also have to do formating on the data to be displayed
Mar 20, 2008 12:44 PM|doyleits|LINK
This article provides an example for exporting a datagrid to excel:
If you need to create an export from a DataTable, I would declare an HtmlTable control, build it how you need, then use the RenderControl to get it's HTML output. Excel knows how to treat an HTML table as a spreadsheet, provided it is in a standard Rows
& Columns layout.
Mar 20, 2008 01:01 PM|kamii47|LINK
Look Like I have to do the HtmlTable control way.I will google about it.If somebody can point me to a sample then it will be very helpful.
Mar 20, 2008 01:23 PM|doyleits|LINK
This covers how to add rows and cells to an HtmlTable:
Mar 23, 2008 04:03 PM|kamii47|LINK
Thanks to all
I have used