Hi
I need to create an 'export' button. when the user clicks this button, some tables from the actual site (not all) should be exported to excel. The user should get a dialog which asks for saving or opening the created file.
I need to configure the excel file (colored cells, formatted font...)
at the moment I've got this basic frame:
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AppendHeader("content-disposition", "attachment;filename=FileName.xls")
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Dim stringWrite As System.IO.StringWriter = New System.IO.StringWriter
Response.Write(str ...
Go to the complete details ...