NET technology, that may well be accepted as a valid answer. If you do not have the specific answer to this question, but can point me to a good OWC11 reference that uses.

To accomplish step 1, I believe that the spreadsheet needs to be saved as XML (read this somewhere). Optional) provide the means for the user to edit the data in the spreadsheet prior to saving it. ') + '\' + xlFileName)ġ) 'open' a base spreadsheet (has fomatting, borders, etc)Ģ) populate the spreadsheet with data from SQL (the easy part)Ĥ) provide a button so the user can save the data to a local file Response.ContentType = 'application/x-msexcel' ' set content header so browser knows you'r sending Excel workbook. Xlsheet.Export(Server.MapP ath('.') + '\' + xlFileName, OWC11.SheetExportActionEnu m.ssExport ActionNone, ExportHTML ) ' use this just to get a unique filename.ĭim xlFileName As String =.

I have found out how to dynamically create a spreadsheet: Maybe because MS didn't provide any documentation. I am having a tough time getting started using OWC.

Excel office web components