NPOI with Excel Table and dynamic Chart

home
open source
view story

1 Kicks

NPOI with Excel Table and dynamic Chart(leniel.net)

submitted by leniel(489) 2 years, 4 months ago

NPOI is a great open source project that enables us to create Excel spreadsheets in code using Microsoft .Net Framework. A reader of my blog commented on the post titled Creating Excel spreadsheets .XLS and .XLSX in C# about a problem he was having to get NPOI working with an Excel table bound to a chart. The chart should get updated whenever new data is inserted into the table. NPOI doesn't achieve what the user desires at first but in this post I experiment a workaround to the problem so that you can use NPOI to insert new data on a template spreadsheet that has a table bound to chart. Read on...

add a comment |category: Open Source |Views: 347
Tweet