I am running this code in Excel Macro and it used to work with an old version of Aspose.Cells but it is no longer working. Please provide new way to do this:
Set oLic = CreateObject("Aspose.Cells.License") oLic.SetLicense ("c:\testing\aspose.total.lic")
Set oWorkbook = CreateObject("Aspose.Cells.Workbook")
Set oSheets = oWorkbook.Worksheets
Set oSheet = oSheets.Item(0)
Set oCells = oSheet.cells oCells.Item("A1").PutValue_5 ("Column1")
I have evaluated your scenario/case configuring Classic Asp on IIS. Please see the following sample code that works fine as I tested on my pc. Please refer to the code segment below that runs fine and the output file is generated fine on my end.
Sample code:
Test.asp page
<%@ LANGUAGE = VBScript %>
<% Option Explicit %>
Aspose.Cells classical ASP sample
<%
'Create a Workbook object
Dim xls
Set xls = CreateObject(“Aspose.Cells.Workbook”)
'Put data into the workbook
Dim sheet
'Get the first worksheet (default worksheet)
Set sheet = xls.worksheets.item(0)
Dim cells
Set cells = sheet.cells
Dim cell
Set cell = cells.item_3(“A1”)
cell.PutValue “Column1”
'Save the document/ Excel file
xls.Save_4 “e:\test2\outBook1.xlsx”
%>
PS. I registered the new version i.e. Aspose.Cells for .NET v7.6.0 on my machine by installing it by its MSI installer which does this automatically otherwise you need to use Regasm.exe utility.