Export to excel
-
Hi, I have a query which returns more than 5 Lakhs record which has to export to Excel(.xls). How to split the recors into 65000 each and export to a single excel file with multiple number of sheets. The database which i am using is oracle. Can any one help me with this either via query in oracle or through coding. Thanks, N Padmanabhan.
Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]
-
Hi, I have a query which returns more than 5 Lakhs record which has to export to Excel(.xls). How to split the recors into 65000 each and export to a single excel file with multiple number of sheets. The database which i am using is oracle. Can any one help me with this either via query in oracle or through coding. Thanks, N Padmanabhan.
Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]
check this Export DataSet to Multiple Excel Sheets[^]
Help people,so poeple can help you.
-
check this Export DataSet to Multiple Excel Sheets[^]
Help people,so poeple can help you.
Thanks for your help. That article is developed using 2008. But i need it in 2005.
Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]
-
Thanks for your help. That article is developed using 2008. But i need it in 2005.
Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]
ok, Sir; try the following: 1. Start a new web project/site. 2. copy the code and paste it and into new files. 3. build the project/site. 4. run the project/site. Good Luck
Help people,so poeple can help you.