VB6 library for creating Excel spreadsheets

I am trying to get a legacy app working on terminal services with the minimum amount of changes to the existing code base. What library for creating Excel spreadsheets using VB6 without having 开发者_开发技巧Excel installed could I use to solve this?

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.

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

Create Excel (.XLS and .XLSX) file from C#

Or even ADO and OLEDB

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