creating chart in an excel spreadsheet using NPOI

Question

I know that my question will be very similar to other ones already asked on SO but as I can't find a satisfying answer, I try my luck !

Does so know whether it's possible or not to generate charts in an Excel spreadsheet using the NPOI library.

I have read that blog but it gives an example where there is already an existing template. Isn't it possible "from scratch" ?

Solution 1

After more investigation I got my answer here: http://npoi.codeplex.com/releases/view/19351

Unsupported Features: Excel Chart

so as explained by Leniel in his blog, we need to use a primary spreadsheet as a template.

Thanks a lot Leniel ! :)

Solution 2

Another solution to create chart without automation is to use third party components,for example this one SmartXLS for .Net,it can create chart/pivottable from scratch.

Solution 3

For NPOI Example with Chart see: http://www.zachhunter.com/2010/05/npoi-excel-template/