How t0 – 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.

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

<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>

The output –

If we want to do it using Open XML SDK without using EPPlus Library we can refer to the below article.

Hope it helps..

%d bloggers like this: