Export To Excel "error saving excel file."

Posted by: ramnath-fp on 8 September 2017, 2:52 pm EST

  • Posted 8 September 2017, 2:52 pm EST

    Hi,

    I am testing spread 5.0 version.

    When i am export excel file show error "error saving excel file."

    I have Windows Server 2003 version and Office 2007.

    But another pc which have  Windows Server 2003 and  Office 2003(Here exported data successfully).

    Tell me about problem.

     

    thanks and regards,

    RAM NATH 

    MUMBAI(INDIA)

     

     

  • Replied 8 September 2017, 2:52 pm EST

    Is this spread 5.0 version for Winforms or for ASP.net?  In the future to avoid this question post in either the Winforms or Asp.Net forums.

    Are you using the latest release version 5.0.##22.2008 for Winforms or 5.0.##24.2008 for asp? You can download the latest versions at ftp://ftp.fpoint.com/SpreadASPNet5/ or ftp://ftp.fpoint.com/SpreadWinforms5/

    If you are using the latest version can you send us the excel file so we can test with it? There is a menu on the options tab above where you post a message to attach files etc.

  • Replied 8 September 2017, 2:52 pm EST

    Hi,

    I am testing spread 5.0.3503.2008 version( Winforms).

    I have bind datatable to spread and want to save data in excel format display  "error saving excel file."

    ------------------------------------------

    fpspread_sheet1.SaveExcel("c:\\export\\abc.xls", FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly);

    ------------------------------------------

    I have Windows Server 2003 version and Office 2007(Problem in this pc during export).

     -----------------------------------------------

    But another pc which have  Windows Server 2003 and  Office 2003(Here exported data successfully).

    also in another pc which have  Windows Vista and  Office 2007(Here exported data successfully).

     -----------------------------------------------

    Tell me about problem.

     

    thanks and regards,

    RAM NATH 

    MUMBAI(INDIA)

     

  • Replied 8 September 2017, 2:52 pm EST

    Please download the last maintenance release of your product to see if this is still an issue. You can get it at 

    ftp://ftp.fpoint.com/SpreadWinforms5/spwin5_net35-3522.zip





  • Replied 8 September 2017, 2:52 pm EST

    Hi

     I test version spwin5_net35-3522 and I still have the same problem.

    My application creates a Spread where each row as one thumbnail picture, one link cell and 8 other columns with text (small text)

    When I save to Spread format, it save and loads without problems.

    However I notice that if I have around 1000 rows, Spread can export to excel, but with 2000 or more it took a long time till return an error.

    I got two kind of errors, the picture with a messages box error was generated when exporting more than 3000 rows to Excel.

    I have a file with 8MB (zipped) that you can load directly to Spread, I try to attach it but it may be to big.

     

    Regards



  • Replied 8 September 2017, 2:52 pm EST

    Hello,

    Your query has been answered at the following link http://www.clubfarpoint.com/Forums/forums/thread/104138.aspx.

    Thanks,

    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels