1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
|
<%@ Language=VBScript %>
<%
response.write("Tutorial 04<br>")
response.write("----------<br>")
Set workbook = Server.CreateObject("EasyXLS.ExcelDocument")
workbook.easy_addWorksheet_2("First tab")
workbook.easy_addWorksheet_2("Second tab")
Set xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()
for column = 0 to 4
xlsFirstTable.easy_getCell(0,column).setValue("Column " & (column + 1))
xlsFirstTable.easy_getCell(0,column).setDataType(DATATYPE_STRING)
next
for row = 0 to 99
for column = 0 to 4
xlsFirstTable.easy_getCell(row+1,column).setValue("Data " & (row + 1) & ", " & (column + 1))
xlsFirstTable.easy_getCell(row+1,column).setDataType(DATATYPE_STRING)
next
next
xlsFirstTable.setColumnWidth_2 0, 70
xlsFirstTable.setColumnWidth_2 1, 100
xlsFirstTable.setColumnWidth_2 2, 70
xlsFirstTable.setColumnWidth_2 3, 100
xlsFirstTable.setColumnWidth_2 4, 70
response.write("Writing file: C:\Samples\Tutorial04 - export data to Excel.xlsx <br>")
workbook.easy_WriteXLSXFile "C:\\Samples\\Tutorial04 - export data to Excel.xlsx"
if workbook.easy_getError() = "" then
response.write("File successfully created.")
else
response.write("Error encountered: " + workbook.easy_getError())
end if
workbook.Dispose
%>
|