"Data may be lost" error for one of the excel while opening it

Aspose.Cells Product Family
1

Hi Aspose Team,

We are getting "File error : Data may have been lost" error while opening the attached excel sheet.

It opens fine on Windows 2003 OS m/c. The error is noticed while opening the file on machine which has Windows 2007 or higher version of OS.

Password to open excel : Cpi123

Regards,

Muin

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET

If you open your source file into Ms-Excel, you will get the Data lost message.

However, if you open the output file into Ms-Excel, you will not get the Data lost message.

It means, your source file is corrupt and Aspose.Cells rectifies it.

I have tested it using the following code using the latest version:
Aspose.Cells
for .NET v7.2.1.7. Please download and try it. Let us know your feedback

I am attaching the output file for your reference.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Comp_by_Role_Group.xls”;


LoadOptions opts = new LoadOptions();

opts.Password = “Cpi123”;


Workbook workbook = new Workbook(filePath, opts);


//Save the workbook

workbook.Save(filePath + “.out.xlsx”, SaveFormat.Xlsx);