Export to Excel creates 0 bytes Spreadsheet

Export to Excel creates 0 bytes Spreadsheet

Posted by: curtis.gilbertson on 19 November 2019, 12:30 pm EST

• 

  curtis.gilbertson

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 November 2019, 12:30 pm EST

  We have used the spread for years in a number of applications. We have upgraded all of our projects to 12.45.20193. Only one of our applications exhibits the behavior of a zero byte file created when we issue this code:
  
  myExcelSaveFlags = FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat Or FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders Or FarPoint.Excel.ExcelSaveFlags.SaveAsViewed

  sprListingSummary.SaveExcel(sExcelFile, myExcelSaveFlags)

  This is a very large app, and cannot be sent to you.
  
  Any ideas where to start looking?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 November 2019, 12:40 am EST

  Hello Curtis,

  Could you please save the spread into “XML” and share it with us. So that we can look into this issue at our end.
  
  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#spwin-save-spreadfile.html

  Also, you can drop the file here if it has some confidential information:
  
  https://www.dropbox.com/request/RzMUldXILcH6PcPQhvA9

  Thanks,
  
  Mohit