Insert Data into Excel File generated using Excel PIA's

144 views Asked by At

I have generated excel file using Excel 2007 PIA's and now I want to insert data from database into excel file.I am having SQL Server 2005 database.I also want to format the data in excel file.

Guide me.. Thanks

1

There are 1 answers

1
Will Wu On

I recommend you using NPOI to do the excel stuff. it's light-weight, and can do all the data inserting and formatting as you expected.