Exporting to Excel, rs with sp1 installed
-
hi guys,
Anyone of you guys have problem exporting to excel? I do, it only happens of there are a lot of records, let say, and array of 40 k rows and 10 columns, the export never completes, and it's taking forver, i rather export it via datagrid and use the mime header which is much much faster.
Can someone pls pls, guide me on how u do the exporting to excel for large records?
I tried exporting it to csv file which is fast, however i can't make excel open it properly. It will just open a "raw csv file" with all the delimiters. Talking abt delimiters, how to i specify a "tab" delimiter for csv?
Thanks
-
Do you have any formulas in your report?
I found that when you have formulas it creates named ranges for each cell referenced in a formula. This not only slows the export but also makes opening the resulting spreadsheet really slow.
The CSV file is exported in Unicode format which is what confuses Excel.
--------------------
Colt 45 - the original point and click interface
-
When importing into Excel (from any file) it is always more accurate and trouble free to use tab delimited files instead of csv. Inevitably, there are commas in fields that mess up the import. You can specify tab delimited output from QA in the Results tab of Tools, Options menu item.
Maybe you can help me. What is the 'mime header' you talk about in the datagrid export? My biggest gripe about the QA grid copy to Excel is that the column headers don't copy. This is one feature of Access that is super slick. (Tools, Office Links, Analyze with Excel). I wish QA had it.
Mike
-
Have you checked Excels help file? To verify that you are not exceeding Excels capabilities
Here is an extract from the help file for Excel 2003:
Excel specifications and limits
Worksheet and workbook specifications
Feature Maximum limit
Open workbooks Limited by memory and system resources
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Length of cell
contents (text) 32,767 characters.
Sheets in a workbook Limited by available memory (default is 3 sheets)
Feature Maximum limit
Number precision 15 digits
Largest number allowed to be typed into a cell 9.99999999999999E+307
Largest positive number 1.79769313486231E+308
Smallest negative number -2.2250738585072E-308
Smallest positive number 2.229E-308
Largest negative number -1E-307
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply