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
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
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.