Export Excel file with multiple worksheets
-
Hi all, I have a log table of my website in which we are maintains the log of the users. I want to export data of this table in excel format.for this I made an SP(store procedure)in which I pass the date range and according to date range I was able to generate the excel file. Now I want to export data with multiple sheets with different information. so please give me some hints/code by which I can export the data in the multiple sheets thanks........
-
Hi all, I have a log table of my website in which we are maintains the log of the users. I want to export data of this table in excel format.for this I made an SP(store procedure)in which I pass the date range and according to date range I was able to generate the excel file. Now I want to export data with multiple sheets with different information. so please give me some hints/code by which I can export the data in the multiple sheets thanks........
I found these in CP. Export DataSet to Multiple Excel Sheets[^] Exporting Data into Excel in Multiple Worksheets[^] Another one Export data to multiple sheets of Excel doc[^]
thatraja
**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
** -
I found these in CP. Export DataSet to Multiple Excel Sheets[^] Exporting Data into Excel in Multiple Worksheets[^] Another one Export data to multiple sheets of Excel doc[^]
thatraja
**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
**thanks for giving reply. actually I am generating excel file by sql (store Procedure)with out using dot net code. because I have to attached this file in the mail of web administrator.the mail will go each first day of the week/month. by sql job