How to use GemBox.Spreadsheet in Classic ASP

GemBox.Spreadsheet is a utility library for .NET applications (Windows Forms, WPF, ASP.NET, etc.), but it can also be used from within a Classic ASP web page. To do this, we need to register GemBox.Spreadsheet to COM with the following steps:

Download and install the latest version of GemBox.Spreadsheet from this page.

Open the Command Prompt (CMD) as Administrator (see here how to do this).

Register GemBox.Spreadsheet to COM by running the following command in CMD:

Now we can start using GemBox.Spreadsheet through VBScript code.NOTE: To create a COM object(s) from a GemBox.Spreadsheet assembly on x64 OS, you'll need to ensure that the Application Pool that your website is using has the "Enable 32-Bit Applications" option enabled: