Do you know any free C# library for Excel/CSV import/export operations?
Which should work without having Excel installed on machine and works with 2003/2007 formats.
+1
A:
According to this specification: OLE-DB and this example. You can connect to an XLS file, run quiries form it and recieve the data. With the data you would be able to format the data how you would like. [in CSV or TSV etc]. Additionally using insert and modification queries you can add data to an XLS file.
monksy
2009-12-23 05:20:32
+3
A:
Hai Kurnal,
have a look at this http://stackoverflow.com/questions/444522/c-asp-net-import-and-export-excel-what-is-the-best-library
Pandiya Chendur
2009-12-23 05:23:13
I also suggest "Open XML SDK" in that article.
afsharm
2009-12-23 05:52:14
@afsharm Open XML SDK is only for 3.5 or above is it true?
Pandiya Chendur
2009-12-23 05:57:16
Just watch out for some weird bugs in the excel odbc driver. The type of each column is determined from the majority in the first 8 rows with default "Text". Cells not matching the type becomes null. e.g. If the first 8 rows in one column are empty, the column will be classified as text and you will no be able to read any numbers from that column.
adrianm
2009-12-23 07:23:35