Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-02-11T20:31:42Z by DanielWagemann
paddi
paddi
10 Posts
ACCEPTED ANSWER

Pinned topic issue in excel 2000 single sheet

‏2013-02-11T19:16:56Z |
Hi,

we have a report in c8 and it has data of more than 65000 rows(nearly 1 lakh). the customer wants all the data to be shown in a single sheet. as we have a restriction to have only upto 65000 in excel 2007 and later versions, the next data is shown in the next sheet. for achieving this we suggested the customer to run it in excel 2000 single sheet, but they are saying that they are facing some issues in excel 2000 single sheet (there is a first page which has a table of contact like data and they are saying that it is merged and not shown properly) and also after 65000 rows the columm headers are repeated in the sheet.

they say they do not have any problem in excel 2007 except to have data in multiple sheets.

is there a work around to achieve this in 2007 (single sheet) or to avoid the repeated column headers in excel 2000 single sheet?

and they are also asking whether cognos supports excel 2010?

please suggest something as it is an urgent requirement.
Thanks in advance
Updated on 2013-02-11T20:31:42Z at 2013-02-11T20:31:42Z by DanielWagemann
  • DanielWagemann
    DanielWagemann
    411 Posts
    ACCEPTED ANSWER

    Re: issue in excel 2000 single sheet

    ‏2013-02-11T20:31:42Z  in response to paddi
    There was a hybrid data dump export switch put into the product a while back. It gives you some of the formatting and removes some of the data volume limitations.

    I am not sure how it is going to handle your column merging but it maybe worth a try.

    http://www-01.ibm.com/support/docview.wss?uid=swg1PM38167