How to export farpoint spread to excel xlsx vb6 with header

How to export farpoint spread to excel xlsx vb6 with header

Posted by: nubietester on 25 October 2017, 10:16 pm EST

• 

  nubietester

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 October 2017, 10:16 pm EST

  hello,
  
  i’am new in vb6 and fpSpread,
  
  i have sample project with view table use fpSpread, if i want to export in excel xlsx how do did that?

  thanks you

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 26 October 2017, 6:58 am EST

  Hello,

  To export Spread to Xlsx format please make sure that you are working with the latest version of Spread 8 COM. i.e. v8.0.28.
  
  You can use the code as follows to export the data to Xlsx:

  FpSpread1.SaveExcel2007File(ByVal FileName As String, ByVal Password As String, Flags AsSaveExcel2007FileFlagConstants, ByVal LogFileName As String)

  I hope it helps.

  Thanks,
  
  Deepak Sharma