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 data from Excel to List
Execute the following ASP code that imports from Excel to List.
<%@ Language=VBScript%><%'==========================================================================
' Tutorial 34
'
' This tutorial shows how to import Excel to List in Classic ASP. The data
' is imported from the active sheet of the Excel file (the Excel file
' generated in Tutorial 09).
'==========================================================================
response.write("Tutorial 34<br>")
response.write("----------<br>")
' Create an instance of the class that imports Excel filesSet workbook = Server.CreateObject("EasyXLS.ExcelDocument")
' Import Excel file to List
response.write("Reading file: C:\Samples\Tutorial09.xlsx<br><br>")
Set rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\Samples\Tutorial09.xlsx")
' 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>")
nextnext
else
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.
