0

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

Stone Cold
  • 206
  • 2
  • 6
  • 15

1 Answers1

0

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.

Will Wu
  • 553
  • 4
  • 15