Chart sheet

// Create an instance of the class that creates Excel files
ExcelDocument workbook = new ExcelDocument();

// Add one sheet
workbook.easy_addWorksheet("SourceData");

// Populate the sheet with data
...

// Add the chart sheet to workbook
workbook.easy_addChart("Chart", "=SourceData!$A$1:$D$5", Chart.SERIES_IN_COLUMNS);

// Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel chart.xlsx");

' Create an instance of the class that creates Excel files
Dim workbook As New ExcelDocument

' Add one sheet
workbook.easy_addWorksheet("SourceData")

' Populate the sheet with data
...

' Add the chart sheet to workbook
workbook.easy_addChart("Chart", "=SourceData!$A$1:$D$5", Chart.SERIES_IN_COLUMNS)

' Create Excel file
workbook.easy_WriteXLSXFile("C:\Samples\Excel chart.xlsx")

C++

// Create an instance of the class that creates Excel files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelDocument),
		      (void**) &workbook) ;

// Add one sheet
workbook->easy_addWorksheet_2("SourceData");

// Populate the sheet with data
...

// Add the chart sheet to workbook
workbook->easy_addChart_5("Chart", "=SourceData!$A$1:$D$5", CHART_SERIES_IN_COLUMNS);

// Create Excel file
workbook->easy_WriteXLSXFile("C:\\Samples\\Excel chart.xlsx");

Click here to see Continuous Code Listing


C++.NET

// Create an instance of the class that creates Excel files
ExcelDocument ^workbook = gcnew ExcelDocument();

// Add one sheet
workbook->easy_addWorksheet("SourceData");

// Populate the sheet with data
...

// Add the chart sheet to workbook
workbook->easy_addChart("Chart", "=SourceData!$A$1:$D$5", Chart::SERIES_IN_COLUMNS);

// Create Excel file
workbook->easy_WriteXLSXFile("C:\\Samples\\Excel chart.xlsx");

Click here to see Continuous Code Listing

// Create an instance of the class that creates Excel files
ExcelDocument workbook = new ExcelDocument();

// Add one sheet
workbook.easy_addWorksheet("SourceData");

// Populate the sheet with data
...

// Add the chart sheet to workbook
workbook.easy_addChart("Chart", "=SourceData!$A$1:$D$5", Chart.SERIES_IN_COLUMNS);

// Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel chart.xlsx");

.NET:

// Create an instance of the class that creates Excel files
$workbook = new COM("EasyXLS.ExcelDocument");

// Add one sheet
$workbook->easy_addWorksheet_2("SourceData");

// Populate the sheet with data
...

// Add the chart sheet to workbook
$workbook->easy_addChart_5("Chart", 
        "=SourceData!\$A$1:\$D$5", $CHART_SERIES_IN_COLUMNS);

// Create Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel chart.xlsx");

Click here to see Continuous Code Listing


Java:

// Create an instance of the class that exports Excel files
$workbook = new java("EasyXLS.ExcelDocument");
	
// Create an worksheet
$workbook->easy_addWorksheet("SourceData");

// Populate the sheet with data
...

// Add a chart sheet
$workbook->easy_addChart("Chart", "=SourceData!\$A$1:\$D$5", $CHART_SERIES_IN_COLUMNS);
		
// Export Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel chart.xlsx");

Click here to see Continuous Code Listing

' Create an instance of the class that creates Excel files
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Add one sheet
workbook.easy_addWorksheet_2("SourceData")

' Populate the sheet with data
...

' Add the chart sheet to workbook
workbook.easy_addChart_5 "Chart", "=SourceData!$A$1:$D$5", CHART_SERIES_IN_COLUMNS

' Create Excel file
workbook.easy_WriteXLSXFile("C:\Samples\Excel chart.xlsx")

' Create an instance of the class that creates Excel files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Add one sheet
workbook.easy_addWorksheet_2("SourceData")

' Populate the sheet with data
...

' Add the chart sheet to workbook
workbook.easy_addChart_5 "Chart", _
        "=SourceData!$A$1:$D$5", Chart.CHART_SERIES_IN_COLUMNS

' Create Excel file
workbook.easy_WriteXLSXFile("C:\Samples\Excel chart.xlsx")

' Create an instance of the class that creates Excel files
set workbook = CreateObject("EasyXLS.ExcelDocument")

' Add one sheet
workbook.easy_addWorksheet_2("SourceData")

' Populate the sheet with data
...

' Add the chart sheet to workbook
workbook.easy_addChart_5 "Chart", "=SourceData!$A$1:$D$5", CHART_SERIES_IN_COLUMNS

' Create Excel file
workbook.easy_WriteXLSXFile("C:\Samples\Excel chart.xlsx")

<!-- Create an instance of the class that creates Excel files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Add one sheet -->
<cfset ret = workbook.easy_addWorksheet("SourceData")>

<!-- Populate the sheet with data -->
...

<!-- Add the chart sheet to workbook -->
<cfset workbook.easy_addChart("Chart", 
                           "=SourceData!$A$1:$D$5", Chart.CHART_SERIES_IN_COLUMNS)>

<!-- Create Excel file -->
<cfset ret = workbook.easy_WriteXLSXFile("C:\Samples\Excel chart.xlsx")>

.NET:

# Create an instance of the class that exports Excel files
workbook = ExcelDocument()

# Create an worksheet
workbook.easy_addWorksheet("SourceData")

# Populate the sheet with data

...

# Add the chart sheet to workbook
workbook.easy_addChart("Chart", "=SourceData!$A$1:$D$5", Chart.SERIES_IN_COLUMNS)

# Export Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel chart.xlsx")

Click here to see Continuous Code Listing


Java:

# Create an instance of the class that exports Excel files
workbook = gateway.jvm.ExcelDocument()

# Create an worksheet
workbook.easy_addWorksheet("SourceData")

# Populate the sheet with data

...

# Add the chart sheet to workbook
workbook.easy_addChart("Chart", "=SourceData!$A$1:$D$5", gateway.jvm.Chart.SERIES_IN_COLUMNS)

# Export Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel chart.xlsx")

Click here to see Continuous Code Listing