How create a csv file from a datatable

[radiohead]

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.

 

[Mohamoss]

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

 

[shriop]

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.

 

[rossum]

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