SaveExcel as UseOOXMLFormat Missing headers?

SaveExcel as UseOOXMLFormat Missing headers?

Posted by: mbaker on 21 March 2018, 2:52 pm EST

• 

  mbaker

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 March 2018, 2:52 pm EST

  I’m running a fairly older version of Farpoint.web.spread 4.0.3525.2008 and I can save as OOXMLFomat however the column headers are missing from the exported version. If I keep it as xls version the headers come out by default. It doesn’t appear to have an override version of the SaveExcel with both the UseOOXMLFormat and include headers property. Just wanted to confirm this or is there another way to export the headers while saving as XLSX format? Or do I have to update my Farpoint control to a newer version? Thanks!

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 March 2018, 10:42 pm EST

  Hello,

  You can use the code as follows:

  fpSpread1.SaveExcel("C:\\excelfile.xlsx", FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat|FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders);
  
  

  Thanks,
  
  Deepak Sharma

• 

  mbaker

  • Post Options:
  • Link
    Copy

  Posted 16 May 2018, 6:08 am EST

  Thank you Deepak! This is working.