February 4. 2008 07:15

Dear Yogesh,

The topic of exporting to excel seems so common that you can find hundreds of links on google, but going deeper, all of them are either using excel automation or direct export from dataset/datagrid or some using xml which looks quite alien and also doens't work with older versions of excel and none caters for my requirements :-(.

I just saw your project and it looks quite promising. Though I'll be doing my analysis but can you help me in giving some guidance on how to go about for my requirement:

1. Users have uploaded few excel templates online (Having formatting, including charts).

2. Complex Reports will be generated (multiple queries) and showm in multiple datagrids on the asp.net page (VB.net)

3. Export button will open the selected excel template and export all the selected datagrids and paste at the specified cells and refresh the charts and then allow users to save this excel file.

Is this thing possile with your library, especially opening the existing excel template and paste data in specified cells.

Looking forward to your help.

Thanx & Regards,
Deep

Deep