Incorrect File Format - Export to Excel - Freeze Pane

Incorrect File Format - Export to Excel - Freeze Pane

Posted by: albert.alinazar on 24 February 2020, 6:55 am EST

• 

  albert.alinazar

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 February 2020, 6:55 am EST

  I’m trying to export to excel file.
  
  it works fine on flat json file, without freeze panes. But when I apply freeze pane it return “Incorrect file format” when exported.
  
  Here is attached json file can not be exported (attachment)

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 26 February 2020, 2:13 am EST

  Hi Albert,

  We are sorry but we are unable to replicate the issue at our end. In our tests, we were able to export the excel file successfully with or without freeze panes.
  
  We used the following sample and the attached excel file for testing purpose, please have a look at it and let us know if we are missing something in order to replicate the issue:
  
  https://stackblitz.com/edit/react-tzafbk?file=index.js
  
  Also, let us know the exact spread version you are using so that we may test using the same version.

  Regards
  
  Sharad
  
  Book1.zip

• 

  albert.alinazar

  • Post Options:
  • Link
    Copy

  Posted 26 February 2020, 5:15 am EST

  Dear Sharad,

  Thanks for your response.

  I already tried in my development environment using evaluation versions on react frameworks. The error is sill exist.

  I also tried on html version. The same error message produced on freeze panes.

  Here is my code including test file and script.
  
  export_files.zip

  My excel version is Microsoft Excel 2013.

  Thanks,
  
  Albert

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 27 February 2020, 4:18 am EST

  Hi Albert,

  The issue in the sample is arising because a different version of Spread.Sheets and Spread.ExcelIo is used. In the sample the Spread.Sheets version is 12.2.5 whereas the ExcelIo build used is of version 13.0.5. Please make sure that both Spread.Sheets and excelio are of the same build version.

• 

  albert.alinazar

  • Post Options:
  • Link
    Copy

  Posted 27 February 2020, 6:15 am EST

  Dear Sharad,
  
  Tt’s working fine now, Thanks