converting CSV to XLS for online download

  • Thread starter Thread starter kungstopher
  • Start date Start date
K

kungstopher

Hello, I have found a few conversion applications that I can download t
convert a CSV file to an XLS file.

Is there a specification on how to do this conversion? What did th
developers of these conversion apps use as a reference for developin
their tool?

I want to understand the requirements of building an XLS file from
CSV file and write a simple script/app to take my query results (in cs
format) and put it into an Excel file that can be viewed using an
version of Excel.

Thanks,
Chri
 
Excel will read an CSV file directly you do not need a separate conversion
package. Be aware of column and row limits and certain field type
conversions - dates, currencies etc.

--
Cheers
Nigel



"kungstopher" <[email protected]>
wrote in message
news:[email protected]...
 
Unfortunately, XLS file format is VERY complicated. See
http://sc.openoffice.org/excelfileformat.pdf and you will see what I mean.



However, you have free alternatives. For example, ExcelLite Free is a free
..NET component that can read / write both XLS and CSV files. You can use it
in a commercial applications; it is only limited to max 150 rows per sheet.
You can download it here:

http://www.gemboxsoftware.com/ExcelLiteFree.htm


Jan
GemBox Software
www.gemboxsoftware.com



"kungstopher" <[email protected]>
wrote in message
news:[email protected]...
 
Back
Top