SaveExcel as UseOOXMLFormat Missing headers?

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

  • 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!
  • Replied 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
  • Marked as Answer

    Replied 16 May 2018, 6:08 am EST

    Thank you Deepak! This is working.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels