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> <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..
You can use ZetExcel for empowering you to build cross-platform applications having the ability to generate, modify, convert, render and print spreadsheets without using Microsoft Excel. Feel free to try it http://www.zetexcel.com
LikeLike