Identify that a pivot table was within the imported sheet

Identify that a pivot table was within the imported sheet

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

• 

  adisa.craig

  • Post Options:
  • Link
    Copy

  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

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 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