Excel Export in Wijmo Flexsheet with Table

Excel Export in Wijmo Flexsheet with Table

Posted by: kuhnimanagam_raznin on 31 July 2018, 6:04 am EST

• 

  kuhnimanagam_raznin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 31 July 2018, 6:04 am EST

  Hi Team,

  I was trying to export the flexsheet with table in it.

  I have created the table using the addTableFromArrayfunction with ‘Properties’ parameter having subset of the columns from the array which is used to load data to the table.

  While exporting this sheet,Microsoft Excel is giving the error"Excel Found unreadable Content.Do you want to recover the contents of this page".If I give ‘Yes’ I get all the data exported.But is there a way we can avoid this message in this scenario?

  Thanks,
  
  Raznin

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 31 July 2018, 11:03 pm EST

  Hi,
  
  We are unable to replicate the issue at our end.
  
  Our implementation steps include:-

  •Create a table in flexSheet using addTableFromArray() method with properties parameter set to some values.
  
  •Export the flexSheet to excel
  
  Here is sample we used for replicating the issue:-
  
  https://stackblitz.com/edit/js-pxb6ea?file=index.js

  Please have a look at it and let us know if we are missing something to replicate the issue.

  ~Manish

• 

  kuhnimanagam_raznin

  • Post Options:
  • Link
    Copy

  Posted 3 August 2018, 8:18 am EST

  Thanks Manish,

  It is working with the latest build,was not working with version 20181.462.

  I notice that when I added a blank column in the properties field like [‘’,‘id’,‘country’,‘sales’],I get the same error from Microsoft Excel.I have a requirement to have some blank columns in the Table.Is there any other way to do this without getting the error while exporting.

  Thanks,
  
  Raznin

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 5 August 2018, 11:34 pm EST

  Hi,
  
  We are sorry but we are unable to replicate the issue in build 5.20181.462 too.

  However, as you mentioned the issue can be observed if we add an extra column with the blank name. This is because Excel doesn’t allow you to have empty table column names/headers.
  
  You can confirm this behaviour by creating a table in excel and try to set one of its column headers to blank.

  You may fix this by providing at least one char for each column name in the table properties, you may also use space.

  Regards