User Guide Tutorials ASP tutorials Tutorial 24: How to create chart in a worksheet in Classic ASP How to create chart in a worksheet in Classic ASP EasyXLS Excel library can be used to export Excel files in Classic ASP. The library is a COM+ component that works without MS Excel installed.
Step 1: Download and install EasyXLS Excel Library for COM+ To download the trial version of EasyXLS Excel Library, press the below button:
If you already own a license key, you may login and download EasyXLS from your account.
Step 2: Verify if EasyXLS is registered Check if EasyXLS component is present in Component Services.
Step 3: License file setup Step required for EasyXLS v9.0 or later. 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 creates a chart in a worksheet Execute the following ASP code that exports a chart to Excel and the chart is placed inside a worksheet.
<% @ Language =VBScript %>
<%
response.write("Tutorial 24<br>" )
response.write("----------<br>" )
Set workbook = Server.CreateObject("EasyXLS.ExcelDocument" )
workbook.easy_addWorksheet_2("SourceData" )
Set xlsTable1 = workbook.easy_getSheet("SourceData" ).easy_getExcelTable()
xlsTable1.easy_getCell(0, 0).setValue("Show Date" )
xlsTable1.easy_getCell(0, 1).setValue("Available Places" )
xlsTable1.easy_getCell(0, 2).setValue("Available Tickets" )
xlsTable1.easy_getCell(0, 3).setValue("Sold Tickets" )
xlsTable1.easy_getCell(1, 0).setValue("03/13/2005 00:00:00" )
xlsTable1.easy_getCell(1, 0).setFormat(FORMAT_FORMAT_DATE)
xlsTable1.easy_getCell(2, 0).setValue("03/14/2005 00:00:00" )
xlsTable1.easy_getCell(2, 0).setFormat(FORMAT_FORMAT_DATE)
xlsTable1.easy_getCell(3, 0).setValue("03/15/2005 00:00:00" )
xlsTable1.easy_getCell(3, 0).setFormat(FORMAT_FORMAT_DATE)
xlsTable1.easy_getCell(4, 0).setValue("03/16/2005 00:00:00" )
xlsTable1.easy_getCell(4, 0).setFormat(FORMAT_FORMAT_DATE)
xlsTable1.easy_getCell(1, 1).setValue("10000" )
xlsTable1.easy_getCell(2, 1).setValue("5000" )
xlsTable1.easy_getCell(3, 1).setValue("8500" )
xlsTable1.easy_getCell(4, 1).setValue("1000" )
xlsTable1.easy_getCell(1, 2).setValue("8000" )
xlsTable1.easy_getCell(2, 2).setValue("4000" )
xlsTable1.easy_getCell(3, 2).setValue("6000" )
xlsTable1.easy_getCell(4, 2).setValue("1000" )
xlsTable1.easy_getCell(1, 3).setValue("920" )
xlsTable1.easy_getCell(2, 3).setValue("1005" )
xlsTable1.easy_getCell(3, 3).setValue("342" )
xlsTable1.easy_getCell(4, 3).setValue("967" )
xlsTable1.easy_getColumnAt(0).setWidth(100)
xlsTable1.easy_getColumnAt(1).setWidth(100)
xlsTable1.easy_getColumnAt(2).setWidth(100)
xlsTable1.easy_getColumnAt(3).setWidth(100)
Set xlsChart = Server.CreateObject("EasyXLS.Charts.ExcelChart" )
xlsChart.setLeftUpperCorner_2("A10" )
xlsChart.setSize 600, 300
xlsChart.easy_addSeries_2 "=SourceData!$B$1" , "=SourceData!$B$2:$B$5"
xlsChart.easy_addSeries_2 "=SourceData!$C$1" , "=SourceData!$C$2:$C$5"
xlsChart.easy_addSeries_2 "=SourceData!$D$1" , "=SourceData!$D$2:$D$5"
xlsChart.easy_setCategoryXAxisLabels("=SourceData!$A$2:$A$5" )
Set xlsWorksheet = workbook.easy_getSheet("SourceData" )
xlsWorksheet.easy_addChart(xlsChart)
response.write("Writing file: C:\Samples\Tutorial24 - chart inside worksheet.xlsx<br>" )
workbook.easy_WriteXLSXFile("C:\Samples\Tutorial24 - chart inside worksheet.xlsx" )
if workbook.easy_getError() = "" then
response.write("File successfully created." )
else
response.write("Error encountered: " + workbook.easy_getError())
end if
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.