export data into excel file

  • Thread starter Thread starter Grey
  • Start date Start date
G

Grey

How to export a dataset to excel file. I need the exported data should be
named with variable in excel as I need to do pivot table in the excel. So do
I need to created pivot table before and only export differenet to the excel
from time to time or created pivot table dynamically with code after adding
the data into the excel?? if the later one, where should I program the code,
in ASP.NET or excel?? and how to code that??


Million thanks
 
Hi Grey:

You might want to consider using Office Web Components. There is a
pivot table component which works pretty well, and using google you
can find some examples of how to do this from asp.net.
 
Back
Top