Excel "File Error: Data may have been lost


#1

Hey Aspose.Cells

I have had a problem with excel workbook after it have been updated with a password and a link to another file. That it says that Data may have been lost but i can find any thing wrong with the document. And i have also try to update to the lates aspose.cells. Sow i hope you can help me with this problem.

Peter Dahl

Carlsberg IT


#2

Hi Peter,

Could you please post your template file and sample code here? I will check it ASAP.


#3

I have try to make a simple program there just make the template and save it to another file, and the same problem happend, i hope you can help me with the issue.

Peter Dahl

Carlsberg IT


#4

Dim llicense As Aspose.Cells.License = New Aspose.Cells.License
llicense.SetLicense("Aspose.Custom.lic")

Dim excel As Aspose.Cells.Excel = New Aspose.Cells.Excel

Try
excel.Open("D:\\KalkylMall.XLS", FileFormatType.Excel2003)


Catch ex As Exception
MessageBox.Show(ex.Message)

End Try
excel.Save("d:\\result.xls", Aspose.Cells.FileFormatType.Excel2003)


#5

Hi Peter,

Please send your file and sample code to nanjing@aspose.com.
By the way, which version of Aspose.Cells are you using?


#6

Thank you for the sample code. Could you please also send me the template file? Thank you very much.


#7

I have found the problem. Aspose can’t find out to open a template with a workbook protectioncode when you not have the code to unprotect the excel template. when i remove the protection it worked.