If you are using a trial, generate a trial license file from EasyXLS trials page. The trial license is valid for 30-days.
If you own a license key, you may login to the account that purchased the license and generate the license file from: https://www.easyxls.com/my-orders
Setup the license file into your project using these guidelines.
Step 4: Run ASP code that imports Excel sheet data to List
Execute the following ASP code that that imports Excel sheet to List.
<%@ Language=VBScript%><%'======================================================================
' Tutorial 35
'
' This tutorial shows how to import Excel sheet to List in Classic ASP.
' The data is imported from a specific Excel sheet (For this example
' we use the Excel file generated in Tutorial 09).
'======================================================================
response.write("Tutorial 35<br>")
response.write("----------<br>")
' Create an instance of the class that imports Excel filesSet workbook = Server.CreateObject("EasyXLS.ExcelDocument")
' Import Excel sheet to List
response.write("Reading file: C:\Samples\Tutorial09.xlsx<br><br>")
Set rows = workbook.easy_ReadXLSXSheet_AsList_3("C:\Samples\Tutorial09.xlsx", "First Tab")
' Confirm import of Excel fileif workbook.easy_getError() = ""then' Display imported List valuesfor rowIndex = 0 to rows.size() - 1
Set row = rows.elementAt(rowIndex)
for cellIndex = 0 to row.size - 1
response.write("At row " & (rowIndex + 1) & ", column " & (cellIndex + 1) & _
" the value is '" & row.elementAt(cellIndex) & "'<br>")
nextnextelse
response.Write("Error reading file C:\Samples\Tutorial09.xls " & workbook.easy_getError())
end if' Dispose memory
workbook.Dispose
%>
Overloaded methods For methods with same name but different parameters, only the first method overload retains the original name. Subsequent overloads are uniquely renamed by appending to the method name '_2', '_3', etc (method, method_2, method_3), an integer that corresponds to the order of declaration that can be found in EasyXLS.h, a file that comes with EasyXLS installation.
