I'm facing problems when tried exporting data from SQL Database to Excel Spread sheet using ASP.
The data stored in the database is retrieved and exported to excel format and while exporting, i'm specifying the file name along with the password to the excel file and also the location to be stored. But when i try to save more than one excel file at a time, popup window will appear asking for the confirmation of the save option.
Can any one tell me the cause for the above problem along with the solution if any.
Regards,
SheshAre you running Excel on the server? If that's so, you might run into other problems as well:
http://support.microsoft.com:80/support/kb/articles/Q257/7/57.ASP&NoWebContent=1&NoWebContent=1
I would recommend saving yourself some headaches and use something designed for an ASP/ASP.NET environment. SoftArtisan's "ExcelWriter" is what I use for both streaming spreadsheets to the browser or to the file system. It's no problem populating the spreadsheet from a SQL server datasource. They have evaluation versions online that come with sample code if you're interested in giving it a whirl.http://officewriter.softartisans.com/default.aspx?PageID=37
Good luck!
No comments:
Post a Comment