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,066
  • 2
  • 21
  • 34
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,669
  • 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
  • 29,710
  • 5
  • 64
  • 108