Spangle
Spangle

Reputation: 73

How to create an Excel file in VB

I need to write a VB class that will create an Excel file and pass into this file a list of variables.

Afterwards I need to be able to convert the program to a .dll so that it can be called by a program.

Its been a while since I have written any code so thought that VB would be a good refresher but all the example I can find all start from within Excel. I need the call to create the file to be from outside of Excel.

Upvotes: 0

Views: 148

Answers (1)

Drew Chapin
Drew Chapin

Reputation: 8009

I would recommend you look at the OpenXML SDK For Microsoft Office. Unlike many of the examples you'll find that use Microsoft.Office.Interop, this approach does not require Microsoft Office to be installed.

There is a complete how-to on MSDN for generating Excel workbooks.

Upvotes: 1

Related Questions