OpenExcel

OpenExcel

Posted by: jarlath on 8 September 2017, 6:10 am EST

• 

  scotts-fp

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 4:19 am EST

  Hello,

  There should be no limit on the size of file that is opened. However it will take longer to open the larger the file is and the more the number of styles set inside the Excel file.

• 

  infoshare-fp

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 4:19 am EST

  but to open an excel file of size above 2MB,it’s returning false…

• 

  bobm

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 4:19 am EST

  What version of Excel was the file created in?  We only support BIFF-8.  Could you attach the file so we can test it here?  I opened an xls file that was 3.5MB in size with no problems, other than time.
  
  

• 

  jarlath

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 6:10 am EST

  I am using Spread.net 6 and Visual Studio 2010. I am trying to open a spreadsheet in Excel and tried typing in exactly as the documentation described. However, I get an exception every time. Below are what I have been trying:

  FpSpread1.SaveExcel(“C:\MappingPractice.xls”, FarPoint.Excel.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders)

  FpSpread1.OpenExcel(“C:\MappingPractice.xls”, FarPoint.Excel.ExcelOpenFlags.RowAndColumnHeaders)

  The exception is: “{“File Save Error in C:\MappingPractice.xls”}”

  I have plenty of hard drive space free, nearly 2 TBs. Any thought?