Wijmo5: FlexGrid while export to Excel date issue

Wijmo5: FlexGrid while export to Excel date issue

Posted by: sudhakar-wd on 14 September 2017, 11:29 am EST

• 

  sudhakar-wd

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:29 am EST

  I am getting a different issue with date while exporting flex grid to excel.
  
  For particular months Augest( as num 8 ) and September( as num 9 ) and any records(rows) between these rows(augest and septemper), I am getting decremented date for those months in excel.

  Ex: If my date in flexgrid is 9/1/2015 but after export in excel it is 8/31/2015
  
  and If my date in flexgrid is 8/14/2015 but after export in excel it is 8/13/2015

  I attached screensshots of flexgrid and excel.
  
  

  

• 

  raunak

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:29 am EST

  Hi

  We are sorry to mention but we could not replicate the issue at our end using the latest build of Wijmo5 i.e. 5.20153.109.

  You can download the same by using the following link:

  http://wijmo.com/almost-there?dlfile=http://wijmo.com/get/C1Wijmo-Eval_5.20153.109.zip

  Kindly, check your sample application with the latest build. If issue still persists, then we request you to please share a small stripped down sample application or modify the attached sample application replicating the issue so that we can look into it accordingly.

  Regards,
  
  Raunak Ladha
  
  2016/01/FlexGrid_DateColumn_ExportToExcel.zip

• 

  keira.jones0607

  • Post Options:
  • Link
    Copy

  Posted 13 February 2018, 8:32 am EST

  Well, it might happen you may be trying to create a sheet name excel doesn’t like.
  
  Another option would be to export to CSV and open that with Excel. At least with CSV you can see what your exported data looks like with any file viewer that supports plain text.

  Or else try to repair the Exported corrupted Excel file with the MS Excel Repair tool.

  Source: http://www.repairmsexcel.com