npoi-examples icon indicating copy to clipboard operation
npoi-examples copied to clipboard

CreateWorkbookFromDataSet

Open jeffreypolk opened this issue 3 years ago • 2 comments

This example project takes a System.DataSet and dynamically generates a workbook from it. Each DataTable is created as a sheet in the workbook.

jeffreypolk avatar Feb 05 '22 15:02 jeffreypolk

Nice contribution. Happy Lunar New Year! I'm still in the holiday of Lunar New Year in China

What a coincidence that I'm also evaluating if NPOI should create a extension with DataSet support. We are on the same page. But your solution is DataSet -> NPOI Workbook. Mine is NPOI data -> Dataset.

Please give me some time to review.

tonyqus avatar Feb 05 '22 23:02 tonyqus

Same to you! I came across your library a few weeks ago and love it. Was using MS solutions that chained me to windows/netfx and that is no bueno. This is great for porting from data tables to excel and vice versa. Covers a ton of use cases.

jeffreypolk avatar Feb 06 '22 02:02 jeffreypolk