1

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?

Simson
  • 3,373
  • 2
  • 24
  • 38
Peter
  • 11
  • 1

2 Answers2

2

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.

dretzlaff17
  • 1,699
  • 3
  • 19
  • 24
  • 1
    +1 csv file creation is simple and works well and if excel is installed, it's the default program to open them – kjack Sep 17 '10 at 15:28
0

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/

Community
  • 1
  • 1
MarkJ
  • 30,070
  • 5
  • 68
  • 111