Create Excel file for download

[Mighty]

At the moment on our company site, it is possible for our customers to view what we have shipped to them on a certain date. They pick the date and a HTML table is displayed showing them all the shipment information.

One of our customers has requested that there is also a link to an Excel file containing the same information that can be downloaded. Can anyone advise me how I can do this?

Is it just a case of using an ASP program to output a page where the type is an excel application.

All help would be greatly appreciated.

Mighty

 

[vbkris]

the best way is to use the CSV format.

simply write a text file with valuse seperated by commas. ie:

Line1 Field1 Value,Field2 Value, Field3 Value
Line2 Field1 Value,Field2 Value, Field3 Value


save the file as .csv and allow download. he can now open it in excel.

Note: CSV will not give u any excel effects. just the grid.

Known is handfull, Unknown is worldfull

 

[sindhufire]

use the Office API to create an ExcelBook.
visit:
thread333-147841 will surely solve your problem.