Post reply

Exporting to Excel, rs with sp1 installed

  • July 1, 2004 at 5:27 am

    #108257

    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

  • July 2, 2004 at 2:00 am

    #513083

    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

  • July 2, 2004 at 6:44 am

    #513137

    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

  • July 2, 2004 at 7:54 pm

    #513229

    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

     

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply