Insert a Chart in Excel Spreadsheet using EPPlus Library.


EPPlus is .NET Library that makes it very easy to manipulate Excel programmatically. It is based on Open XML.

https://epplus.codeplex.com/

Below is the sample code we can use to insert a chart in a excel spreadsheet.

</p>
<p>public void UpdateExcelUsingEPPlus(string fileName)<br />
{<br />
FileInfo fileInfo = new FileInfo(fileName);</p>
<p>ExcelPackage p = new ExcelPackage(fileInfo);</p>
<p>// access the first sheet named Sheet1<br />
ExcelWorksheet myWorksheet = p.Workbook.Worksheets["Sheet1"];</p>
<p>// specify cell values to be used for generating chart.<br />
myWorksheet.Cells["C2"].Value = 10;<br />
myWorksheet.Cells["C3"].Value = 40;<br />
myWorksheet.Cells["C4"].Value = 30;</p>
<p>myWorksheet.Cells["B2"].Value = "Yes";<br />
myWorksheet.Cells["B3"].Value = "No";<br />
myWorksheet.Cells["B4"].Value = "NA";</p>
<p>// add chart of type Pie.<br />
var myChart = myWorksheet.Drawings.AddChart("chart", eChartType.Pie);</p>
<p>// Define series for the chart<br />
var series = myChart.Series.Add("C2: C4", "B2: B4");<br />
myChart.Border.Fill.Color = System.Drawing.Color.Green;<br />
myChart.Title.Text = "My Chart";<br />
myChart.SetSize(400, 400);</p>
<p>// Add to 6th row and to the 6th column<br />
myChart.SetPosition(6, 0, 6, 0);</p>
<p>p.Save();</p>
<p>}</p>
<p>

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