Export to Excel

[edr]

Hi,

I have a excel file templete, where i need to populate the raw data in
the one of the sheet with the specific predefined format.
based on the that data, a VBA program will fetch the data from sheet 1
and draw graphs in various other sheets.

open the specific excel file from asp.net and then plot the data as per
the pre requisite and generate graphs etc from this. I have had a look
at some third party controls
but they are a bit pricy .


i would like to know, how to open and write into excel sheet in a
format required for the VBA program to fetch data from there and plot
various reports.

Regards,
Edr

 

[Mischa Kroon]

i would like to know, how to open and write into excel sheet in a
format required for the VBA program to fetch data from there and plot
various reports.

You can do this by this free excel writer component:
http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx

Also have a look at the generator for getting things in the format you need.

There are also some commercial components out there.

Alternative is using COM Automation.

 

[Arthur Dent]

Also, you'd probably get more answers if you posted in an Excel newsgroup,
not in the ASP.NET newsgroup.
Cheers!