Export dataset to excel file NOT ASP.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Franck - 14 Sep 2007 15:04 GMT

i'm looking or a NONE ASP.NET code. all over the web those i found
either don't work or are made for ASP.NET. Im just looking to output
dataset to excel with opening a file wich is the pseudo-template and
paste dataset info to it and save as new file.

Reply to this Message

Ignacio Machin ( .NET/ C# MVP ) - 14 Sep 2007 15:12 GMT

Hi,

> i'm looking or a NONE ASP.NET code. all over the web those i found
> either don't work or are made for ASP.NET. Im just looking to output
> dataset to excel with opening a file wich is the pseudo-template and
> paste dataset info to it and save as new file.

You can simply save it as a comma separated file (CSV) and excel will read
it ok.
Now if you want that each table be in a separated sheet you have to use
another route.
There are a lot of examples of how to do it in the web.
Also it does not matter if it's ASP.NET or not I think the code should be
the same.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...