Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Classic ASP and generation of Excel files without Office

Status
Not open for further replies.

Niente Zero

Programmer
Feb 12, 2019
1
IT
Hi all,
I'd like to generate Excel files from my vbscript (ASP) code without using MSOffice (I know how to do with Automation, but I cannot use it for licensing problems).
So I downloaded EPPlus from [URL unfurl="true"]https://www.nuget.org/api/v2/package/EPPlus/4.5.3.1[/url], renamed package to zip and extracted dll from lib/net40 folder. Then I registered this dll by using this command (in Admin mode):

[pre]c:\windows\Microsoft.NET\Framework\v4.0.30319\regasm EPPlus.dll[/pre]

It was correctly registered (I got this info from Now I'd like to use this object in my code, but I found no instructions. I tried with:

[pre]Set ExcelBook = CreateObject("OfficeOpenXml")[/pre]

and also with

[pre]Set ExcelBook = CreateObject("ExcelPackage")[/pre]

but I cannot find the right name to use.

Anyone can help please? Thank you! [wink]
 
This isn't a COM automation library. It is a .NET assembly and does not, to the best of my knowledge, include any COM interop; you therefore cannot use it from VBScript

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top