If I am not wrong the source code will require the user to click Open / Save / Cancel to continue either save or open the excel file. Is there any way to force the system automatically save the file? (without making any changes to the system setting). I
tried to use the HTML writer to render the DataGrid control to excel, it works fine but just has a funny header character in the first row.
I tried to use Excel.Application method to open the excel file and delete the row, but it requires Microsoft.Office.Interop class, :( is there any other method to force Save button click?
qqer
Member
4 Points
12 Posts
Re: Dynamically Generate An Excel spreadsheet in asp.net
Apr 30, 2008 01:25 AM|LINK
Hi,
If I am not wrong the source code will require the user to click Open / Save / Cancel to continue either save or open the excel file. Is there any way to force the system automatically save the file? (without making any changes to the system setting). I tried to use the HTML writer to render the DataGrid control to excel, it works fine but just has a funny header character in the first row.
I tried to use Excel.Application method to open the excel file and delete the row, but it requires Microsoft.Office.Interop class, :( is there any other method to force Save button click?