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
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