converting CSV to XLS for online download
 

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

--
kungstophe
-----------------------------------------------------------------------
kungstopher's Profile: http://www.excelforum.com/member.php...fo&userid=2749
View this thread: http://www.excelforum.com/showthread.php?threadid=47003

converting CSV to XLS for online download
 

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"
wrote in message
...

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

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

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

Thanks,
Chris


--
kungstopher
------------------------------------------------------------------------
kungstopher's Profile:
http://www.excelforum.com/member.php...o&userid=27491
View this thread: http://www.excelforum.com/showthread...hreadid=470039

converting CSV to XLS for online download
 

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 he

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


Jan
GemBox Software
www.gemboxsoftware.com



"kungstopher"
wrote in message
...

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

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

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

Thanks,
Chris


--
kungstopher
------------------------------------------------------------------------
kungstopher's Profile:
http://www.excelforum.com/member.php...o&userid=27491
View this thread: http://www.excelforum.com/showthread...hreadid=470039