Oracle Transactional Business Intelligence

Products Banner

Max Export into Excel 2007 from OBI

41
Views
4
Comments

Summary

Wondering what the max export is into Excel 2007

Content

Hello,

Does anyone know what the max number of rows you can export from OBI into Excel 2007?

I have heard a variety of rumors, one saying 60,000 others saying 80,000 rows.

Thank you,

Kelly

Comments

  • Kelly

    This is really limited by data, which is columns x rows. More the columns lesser the rows you can get, lesser the columns more rows you can get. To answer your questions it varies and there is no known number limit that is published as such.

    Kumar

  • Hi Kelly,

    We have observed whenever the data volume is such that the file size crosses 9 MB, it gives error.

    We had raised an SR and they admitted it to be bug. Still no confirmation when it will be fixed.

    Till then users will have to break down the prompts such that the data volume fits in smaller size.

    Regards,

    Kiran Shenvi

  • Hi Kelly,

    I believe the .xls Excel Format is limited to 65536 Rows, I Have made various changes to the number of columns and Data held within each column and I am still limited to the same number of rows,

    Hope this helps,

    Brad

  • Thanks All, I believe the .xls Excel refers to the 1997/2003 file type. I believe the 2007 version (.xlsx) expanded the total number of rows/columns, past the ~65,000 Brad mentioned above.  Does anyone know the max export for .xlsx?

     

    Thanks,

    Kelly