Opening excel files

Posted by: dkaminski on 8 September 2017, 2:50 pm EST

  • Posted 8 September 2017, 2:50 pm EST

    I am using the new FarPoint Grid for Windows Forms version 6.0 but having some issues opening excel files on some computers. The same file can be opened correctly on other computers. There doesn't seem to be a reason why the spread if throwing the error. Opening the excel file using the shell command works in all computers "System.Diagnostics.Process.Start(sWorkbook)"

    This is the error message:

    Load Excel Workbook  Error No: 5  Error Location: Load Excel Workbook  -------------------------  

    Exception Message: Error Opening file  

    Exception Source: FarPoint.Win.Spread  

    Exception Target Site: a  

    Exception Location:    

    at FarPoint.Win.Spread.FpSpread.a(String A_0, Int32 A_1, String A_2, Int32 A_3, String A_4, ExcelOpenFlags A_5, ExcelWarningList A_6, String A_7, ExcelFileHandler A_8)     

    at FarPoint.Win.Spread.FpSpread.a(String A_0, Int32 A_1, String A_2, Int32 A_3, String A_4, ExcelOpenFlags A_5, ExcelWarningList A_6, String A_7)     

    at FarPoint.Win.Spread.FpSpread.OpenExcel(String fileName, String password)     

    at FarPoint.Win.Spread.FpSpread.OpenExcel(String fileName)     

    at NGM.frmCustomerInfo.LoadExcelWorkbook(String sWorkbookName, String sSheetName)------------------------- 

     

    Thanks,

    Daniel 

  • Replied 8 September 2017, 2:50 pm EST

    Can you attach your excel file that is giving you difficulty here?
  • Replied 8 September 2017, 2:50 pm EST

    Paul, I have been doing a bit more digging, and it seems the issue is not directly caused by the Farpoint Spread. The application with the issue is fairly complex and looks like there is something else that is causing the Spread to fail when trying to open the excel files. Using a small sample application, I was able to confirm that Spread could open the Excel files in any of the computers without an issue. I will let you know if I find something you could help me with.

    Thanks,

    Daniel 

Need extra support?

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

Learn More

Forum Channels