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/