I am working on a ASP.NET 2.0 application, which requires to export the data to an excel spreadsheet.
(1) Tabbed. So need to create multiple tabs. Each tab has its own name.
(2) Might require color coded contents
(3) Requires column name
(4) It will show some special line item, such as sub total (on spread sheet, just show the number) on some of the column. So it is not as easy as export a whole dataset or dataview.
How do I do this? I have seen some examples for winform, but NOT webform. The ideal solution would include the dialog box for user to save or open.
How do I achieve this?