Export Chart to excel using C#

Hi,

First this code snippet is for a web application, not windows application.

Second, I believe I understood your requirement, so you would like to generate a new excel file, fill it with a data from your database and create a chart based on that data.

If I'm correct then try the following, it is a C# snippet for creating a Chart element in a new Excel file. The code uses this .NET library that operates with excel files.

DataTable table = new DataTable();
// Fill DataTable with database's data.
// ...

// Create new excel file.
ExcelFile file = new ExcelFile();

// Create new worksheet.
ExcelWorksheet sheet = file.Worksheets.Add("Sheet 1");

// Insert DataTable to worksheet.
sheet.InsertDataTable(table, new InsertDataTableOptions("A1"));

// Create chart and select data for it.
ExcelChart chart = sheet.Charts.Add(ChartType.Line, "D2", "M25");

chart.SelectData(
    sheet.Cells.GetSubrange("A1",
    CellRange.RowColumnToPosition(table.Rows.Count - 1, table.Columns.Count - 1)));

// Save file.
file.Save("Chart.xlsx", SaveOptions.XlsxDefault);