EPPlus is .NET Library that makes it very easy to manipulate Excel programmatically. It is based on Open XML.
Below is the sample code we can use to insert a chart in a excel spreadsheet.
public void UpdateExcelUsingEPPlus(string fileName) { FileInfo fileInfo = new FileInfo(fileName); ExcelPackage p = new ExcelPackage(fileInfo); // access the first sheet named Sheet1 ExcelWorksheet myWorksheet = p.Workbook.Worksheets["Sheet1"]; // specify cell values to be used for generating chart. myWorksheet.Cells["C2"].Value = 10; myWorksheet.Cells["C3"].Value = 40; myWorksheet.Cells["C4"].Value = 30; myWorksheet.Cells["B2"].Value = "Yes"; myWorksheet.Cells["B3"].Value = "No"; myWorksheet.Cells["B4"].Value = "NA"; // add chart of type Pie. var myChart = myWorksheet.Drawings.AddChart("chart", eChartType.Pie); // Define series for the chart var series = myChart.Series.Add("C2: C4", "B2: B4"); myChart.Border.Fill.Color = System.Drawing.Color.Green; myChart.Title.Text = "My Chart"; myChart.SetSize(400, 400); // Add to 6th row and to the 6th column myChart.SetPosition(6, 0, 6, 0); p.Save(); }
The output –
If we want to do it using Open XML SDK without using EPPlus Library we can refer to the below article.
https://msdn.microsoft.com/en-us/library/office/cc820055.aspx
Hope it helps..
Advertisements