Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export Large Data
Hi,
We are using SSRS to generate the reports. We want to export the data from SSRS control to excel but we need to built different formula and graphs. We are getting timeout exceptions when exporting large amount of data to excel through our custom program. we are writing row by row data in the excel file which i guess is causing performance hit. But we need to write row by row because we are building some formulas in the cell. Does anybody knows the better way of exporting to excel rather than writing row by row? or anyother way by which the performance can be improved so that we dont get timeout? Thanks in advance... Regards, -Ashish |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to export large amounts of text data into single reports | Excel Discussion (Misc queries) | |||
Best way to easily export large amount of data from Excel | Excel Discussion (Misc queries) | |||
Import Data / Edit Data / Export Data in Excel | Excel Programming | |||
Data too large for Excel, need to query Access data for results | Excel Programming | |||
Fast export large 2-dim array to worksheet | Excel Programming |