Is there a straightforward way of creating an excel/csv
file from a datatable. I don't know where to start with
this.

thank you.

Hi
what you can do with one line of code it to write your table to an XML
file . Using the wirteXML command of datasets ( you can wrap your datatable
in a dataset object if it is not already contained inside one ) .
if you what to write it to excel however , you can create and adaptor that
is connected to excel file and use that adataper's update command to fill
the excel file with your datatable ( you will pass the dataset of your
table as a parameter to the update command of the adaptor)
Mohamed M .Mahfouz
Developer Support Engineer
ITWorx on behalf of Microsoft EMEA GTSC

My CSV parser will do it for you, but it is not free unfortunately.
http://www.geocities.com/shriop/index.html
There's a WriteAll method on the CsvWriter class that takes a DataTable
and will dump the contents directly to a file or stream.

On Wed, 16 Mar 2005 02:21:07 -0800, "radiohead"
<(E-Mail Removed)> wrote:

>Is there a straightforward way of creating an excel/csv
>file from a datatable. I don't know where to start with
>this.
>
>thank you.

All you ever wanted to know about CSV files:
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm

It is pretty easy to write your own class to output data in CSV to a
stream.

rossum


The ultimate truth is that there is no ultimate truth