Excel Data Writer Wrapper in Excel using NPOI

Nov 19, 2013 at 7:12 PM
Edited Nov 20, 2013 at 8:44 PM
Made a .dll Wrapper where you can quickly make a template in excel, run your SQL or input your data set, and get an output of your data in an excel format. The only work you would do is in Excel. Also I could build a UI for this, but not sure if its wanted. Right now you'll have to add this to a .NET project as a reference.

Two functions are:
FillXLS_SQL(inputfile (XLS or XLSX), outputfile (same), SQL String, ConnString)
&
FillXLS_DataSet(inputfile, outputfile, DataSet)

Right now the format for any excel field is >>TableNumber^FieldName. Will work on any sheet you have in the workbook.

So, if you have one dataset that pulls name and address you would put in your template file in cell A1: >>1^Name; A2: >>1^Address

Hope that makes sense. Feel free to try it out and let me know what you think. I wont keep it up too long because its still a work in progress. Hope it saves a few of you some time.

Zipped up DLL File
Coordinator
Dec 1, 2013 at 8:51 PM
You had better put this in github or somewhere. I don't think discussion will be viewed by a lot of people. Anyway, thank you for what you shared. It looks to be useful.