Problems reading frozen panes?

Aspose.Cells Product Family
1

Hi,

I’m trying to open a spreasheet (using Apose.Excel 1.6) that contains several worksheets that use frozen panes. The Open method fails with the following exception message:-

{“Erros in Excel Open method.” }

If I remove the frozen panes in all the worksheets, the Open method works but unfortunately the ability to read these is a requirement.

Any ideas?

2

Dear Bennean,

Please download hotfix 1.6.1 and have a try.

If the problem still exists, please send the file to me. I will investigate it as soon as possible.

3

@bennean,
Aspose.Excel is discontinued now and a more advanced and efficient version is available as Aspose.Cells. You can manage the worksheet view like freezing the panes using this latest library as follows:

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(fstream);

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Applying freeze panes settings
worksheet.FreezePanes(3, 2, 3, 2);

// Saving the modified Excel file
workbook.Save(dataDir + "output.xls");

// Closing the file stream to free all resources
fstream.Close();

For more details have a look at the following article:
Worksheet Views

Download the latest version of Aspose.Cells for .NET from the following link:

Aspose.Cells for .NET (Latest Version)

You can download the latest demos here.