Error trying to open excel file

Error trying to open excel file

Posted by: ljk on 21 June 2023, 12:44 am EST

• 

  ljk

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 June 2023, 12:44 am EST

  I am opening SDJAB2024FORM.xlsx and saving it as SDJAB2024FORM_Copy.xlsx. When trying to open then SDJAB2024FORM_Copy.xlsx, a popup says “We found a problem with some content in ‘SDJAB2024FORM_Copy.xlsx’. Do you want us to try to recover as much as we can?” Chose Yes. Then get the message “Repaired Records: View from /xl/worksheet/sheet4.xml part”
  
  This is what the log file says:
  
  error198720_01.xml

  Errors were detected in file ‘C:\TFS\Trunk\Code\SAS\bin\Debug\SDJAB2024FORM_Copy.xlsx’

  Repaired Records: View from /xl/worksheets/sheet4.xml part

  This is the code I am using to open and save the excel file.
  
  Dim spr As New FarPoint.Win.Spread.FpSpread
  
  spr.OpenExcel(“C:\TFS\Trunk\Code\SAS\bin\Debug\SDJAB2024FORM.xlsx”)
  
  spr.SaveExcel(“C:\TFS\Trunk\Code\SAS\bin\Debug\SDJAB2024FORM_Copy.xlsx”, FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat Or FarPoint.Excel.ExcelSaveFlags.DocumentCaching)
  
  How can I resave this file without getting the error?SDJAB2024FORM.zip

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 June 2023, 7:47 pm EST

  Hi,

  It seems like you have created a duplicate case.
  
  We have responded here: https://www.grapecity.com/my-account/my-support/case/4b9b8b85-3910-ee11-8f6d-000d3a574715.

  Now we will continue with the above.

  regards,
  
  Nitin