SaveExcel with the format .xlsx

Posted by: lhanicotte on 8 September 2017, 2:31 pm EST

  • Posted 8 September 2017, 2:31 pm EST

    Hi,

     

    I have a problem when I save my spread in the extension .xlsx. The excel file is created but i can't open it with excel 2007.

    I have a error message which explain that the extension or the format of my file is not valide.

    If I save my spread with the extension .xls, I have no problem to open it with excel 2007.

    Have you any idea?

     

  • Replied 8 September 2017, 2:31 pm EST

    Did you use ExcelSaveFlags? I tried this and it works for me.

    <FONT size=2 face=Consolas><FONT size=2 face=Consolas>

    fpSpread1.SaveExcel(</FONT></FONT><FONT color=#a31515 size=2 face=Consolas><FONT color=#a31515 size=2 face=Consolas><FONT color=#a31515 size=2 face=Consolas>"C:\\Users\\paul\\Desktop\\Book1.xlsx"</FONT></FONT></FONT><FONT size=2 face=Consolas><FONT size=2 face=Consolas>, FarPoint.Excel.</FONT></FONT><FONT color=#2b91af size=2 face=Consolas><FONT color=#2b91af size=2 face=Consolas><FONT color=#2b91af size=2 face=Consolas>ExcelSaveFlags</FONT></FONT></FONT><FONT size=2 face=Consolas><FONT size=2 face=Consolas>.UseOOXMLFormat);

    </FONT></FONT>
  • Replied 8 September 2017, 2:31 pm EST

    thanks for the answer
Need extra support?

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

Learn More

Forum Channels