User Guide Tutorials C#.NET tutorials Tutorial 22: How to display chart datatable in C#.NET How to display chart datatable in C#.NET
EasyXLS Excel library can be used to export Excel files in C#. The library works with .NET Framework or .NET Core platform.
Step 1: Download EasyXLS Excel Library for .NET 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. Install the downloaded EasyXLS installer for v8.6 or earlier.
Step 2: Create a C# project If don't have a project, create one as ASP.NET web application, windows forms app, console application, class library or service.
Step 3: Include EasyXLS library into project EasyXLS.dll must be added as reference to your project. EasyXLS.dll can be found: - Inside the downloaded archive at Step 1 for EasyXLS v9.0 or later - Under installation path for EasyXLS v8.6 or earlier, in "Dot NET version" folder.
Step 4: Run C# code that shows and formats chart datatable for Excel file Execute the following C# code that formats the chart data table for an Excel file.
using System;
using System.Drawing;
using EasyXLS;
using EasyXLS.Constants;
using EasyXLS.Charts;
using EasyXLS.Drawings.Formatting;
public class Tutorial22
{
[STAThread]
static void Main()
{
Console.WriteLine("Tutorial 22\n-----------\n" );
ExcelDocument workbook = new ExcelDocument();
workbook.easy_addWorksheet("SourceData" );
ExcelTable xlsTable1 = ((ExcelWorksheet)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(EasyXLS.Constants.Format.FORMAT_DATE);
xlsTable1.easy_getCell(2, 0).setValue("03/14/2005 00:00:00" );
xlsTable1.easy_getCell(2, 0).setFormat(EasyXLS.Constants.Format.FORMAT_DATE);
xlsTable1.easy_getCell(3, 0).setValue("03/15/2005 00:00:00" );
xlsTable1.easy_getCell(3, 0).setFormat(EasyXLS.Constants.Format.FORMAT_DATE);
xlsTable1.easy_getCell(4, 0).setValue("03/16/2005 00:00:00" );
xlsTable1.easy_getCell(4, 0).setFormat(EasyXLS.Constants.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);
workbook.easy_addChart("Chart" , "=SourceData!$A$1:$D$5" , Chart.SERIES_IN_COLUMNS);
ExcelChart xlsChart = ((ExcelChartSheet)workbook.easy_getSheetAt(1)).easy_getExcelChart();
xlsChart.easy_getLegend().setVisible(false );
xlsChart.easy_getChartDataTable().setVisible(true );
xlsChart.easy_getChartDataTable().getFontFormat().setFont("Verdana" );
xlsChart.easy_getChartDataTable().getFontFormat().setFontSize(10);
xlsChart.easy_getChartDataTable().setHorizontalLines(false );
xlsChart.easy_getChartDataTable().setLegendKey(true );
xlsChart.easy_getChartDataTable().getLineColorFormat().setLineColor(Color.Blue);
xlsChart.easy_getChartDataTable().setVerticalLines(false );
Console.WriteLine("Writing file C:\\Samples\\Tutorial22 - Excel chart datatable.xlsx." );
workbook.easy_WriteXLSXFile("C:\\Samples\\Tutorial22 - Excel chart datatable.xlsx" );
String sError = workbook.easy_getError();
if (sError.Equals("" ))
Console.Write("\nFile successfully created. Press Enter to Exit..." );
else
Console.Write("\nError encountered: " + sError + "\nPress Enter to Exit..." );
workbook.Dispose();
Console.ReadLine();
}
}