Vb6 library you found for creating excel spreadsheets

Question

Hi

Does any anyone know a good library for creating excel spreadsheets using VB6 without having excel installed. I am trying to get a legacy app working on terminal services with the minimum amount of changes to the existing code base.

Many thanks

Peter

Answer 1

If you are using COM Interop to create Excel spreadsheets you must have Excel installed on the machine.

You could create comma delimited .csv files instead.

Answer 2

CSV is easy as suggested in the other answer. Sometimes folk use HTML too.

http://stackoverflow.com/questions/151005/create-excel-xls-and-xlsx-file-from-c/151035#151035

Or even ADO and OLEDB

http://support.microsoft.com/kb/195951/