Skip to main content
N
NANDAN2475-Regular Member
5-Regular Member
April 26, 2022
Question

Export list to XLSX

  • April 26, 2022
  • 8 replies
  • 3820 views

In windchill 12.0 when we try to export a large report to XLSX format, the page keeps loading and the excel sheet is not generated/downloaded. These report contains around 150000 item, but we were able to generate the report into excel format when we were using 11.0 within few minutes but now it keeps on loading endlessly.

8 replies

B
BenLoosli23-Emerald III
23-Emerald III
April 26, 2022

Is it the same version of Excel?

I would open a case with tech support as I doubt any user can solve this, unless they have also run into this issue.

    S
    SWeiler_994026116-Pearl
    16-Pearl
    April 26, 2022

    Are you using a reverse proxy? I've seen the following error when exporting to XLSX:

    Proxy Error. The proxy server received an invalid response from an upstream server.

     

    If you are using a reverse proxy, did you see any errors in the Apache logs?

     

    N
    NANDAN2475-Regular MemberAuthor
    5-Regular Member
    April 26, 2022

    Thank you for your reply.

     

    When the export list to file window opens it keeps on loading endlessly. When I run report with less items then the XLSX export is completed this issue is only for reports with large number of items.

     

    Yes I checked the logs there is no error information.

    S
    SWeiler_994026116-Pearl
    16-Pearl
    April 26, 2022
    I looked to see if you are exceeding the limits. I found this reference:
    • The property com.ptc.jca.exportRowLimit determines the maximum number of rows that can be exported for a table
    • The default value is the maximum number of rows that Microsoft Excel 2003 can handle (65535) and 1048576 max rows for Microsoft Excel 2007, 2010

     

     

    Terms & ConditionsAccessibility statement