Okay here is the important part, ExcelML won't help me. I'm dealing with legacy systems still running older versions of Office. I believe the newest ones are Office 2000. Now I know I can use the following code to write out a html table that will convert
to a spreadsheet:
Xorcist
Member
357 Points
183 Posts
.NET Dataset to Excel (XLS) w/ Multiple Worksheets
Aug 24, 2006 02:20 PM|LINK
Okay here is the important part, ExcelML won't help me. I'm dealing with legacy systems still running older versions of Office. I believe the newest ones are Office 2000. Now I know I can use the following code to write out a html table that will convert to a spreadsheet:
Response.Clear()
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Response.AddHeader("Content-Disposition", "attachment; filename=whatever.xls;")
Response.Write("<table border=0><tr><td>DATA<td></tr></table>")
Response.End()
but that's only good for a single worksheet. Is there anyway to specify multiple worksheets?