FpSpread excel Save overload method

FpSpread excel Save overload method

Posted by: dnjsxmf on 5 September 2021, 6:42 pm EST

• 

  dnjsxmf

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 September 2021, 6:42 pm EST

  I am using .Net 4.0 Version Fpspread.

  I am using FpSpread.SaveExcel(string fileName, IncludeHeaders includeHeaders) method. (I use various IncludeHeaders Enum Values)

  But now, I should use SaveExcel(string fileName, ExcelSaveFlags saveFlags) method because of saving over 256 column data in excel (in xlsx, not xls)

  And there is not SaveExcel(string fileName, IncludeHeaders includeHeaders, ExcelSaveFlags saveFlags) overload method.

  so, should I code like that for saving xlsx?

                      FarPoint.Excel.ExcelSaveFlags flag = FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat;
  
                      switch (includeHeaders)
                      {
                          case IncludeHeaders.ColumnHeadersCustomOnly:
                              flag |= FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders;
                              break;
                          case IncludeHeaders.RowHeadersCustomOnly:
                              flag |= FarPoint.Excel.ExcelSaveFlags.SaveCustomRowHeaders;
                              break;
                          case IncludeHeaders.BothCustomOnly:
                              flag |= FarPoint.Excel.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders;
                              break;
                          default:
                              break;
                      }
  
                      grid.SaveExcel(fileName, flag);
  

  Thanks.

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 6 September 2021, 3:13 pm EST

  Hi,

  Yes, the ExcelSaveFlags enums you’ve mentioned are the equivalents for the IncludeHeaders enums you were using before.
  
  So, you can use it like this.

  Regards,
  
  Jitender