Identify that a pivot table was within the imported sheet

Posted by: adisa.craig on 8 November 2019, 9:36 am EST

  • Posted 8 November 2019, 9:36 am EST

    I am currently using the excelIO.open function to import xlsx files, currently if the xlsx file contains a pivot table the function throws an error which says the file format isn't supported.
    Firstly is there a way to identify that the reason the file failed was because of the pivot tables not being supported and
    secondly when will pivot tables support be added to spreadjs
  • Replied 10 November 2019, 7:27 pm EST

    Hi Adisa,
    We are sorry, we are unable to replicate the issue at our end with the latest release v13 designer:
    https://www.grapecity.com/spreadjs/designer/content/index.html

    Please verify at your end using SpreadJS designer and attached excel file.

    Regards,
    Manish Gupta
    PivotExcel.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels