Cannot create Aspose.Cells object from Excel 2003 document

Aspose.Cells Product Family
1

Using Aspose.Cells version 5.1.2.4 with VB.NET Framework 1.1 with a fully licensed version with a current support agreement:

I am a developer and we are using Aspose.Cells objects to update custom document properties containing revision and other document metadata from our database and using those properties to set text in the worksheet footers.

An error is occurring when creating an Aspose.Cells object with the following code:
At the top of the class:

Imports Aspose.Cells

In the constructor of the class:

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

In the sub to add custom properties:

Dim app as Object
app = New Workbook(m_filePath)

…where ‘m_filePath’ is a string variable containing the UNC path to the attached document

Using Document Inspector in Office 2007 to examine the document’s hidden objects, I see a ‘Printer Path’ property set and if I remove it, the document will work, but I believe this constructor should still execute properly without error without removing the printer path.

Thank You,

John Romanchik, Software Application Developer - Cebos, Ltd.

5936 Ford Court, Ste. 203
Brighton, MI 48116
(810) 534-2222 x240
(810) 534-0131 fax

E-mail:
john.romanchik@cebos.com.

2

Hi,

We are not very sure about your issue, could you explain it more.
By the way we use:
e.g
FileStream fs = File.Open(fileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
in the background for opening files, we use this code to open the file to the stream.

For you issue, kindly do create a simple console application, zip it and post it here to reproduce the issue. Also attach your template file here. We will check it soon.

By the way, I am attaching latest fixed version here, may be you can try it and it works fine there for your issue.

Thank you.


3

Hi,

I have also checked and tested your template file.

Well, a simple opening your file with Aspose.Cells for .NET would give an exception using the code:
Workbook workbook =
workbook = new Workbook(“e:\test2\5110220910+QAR1.xls”);

The exception occurs due to the fact that your file contains MS Excel 95/5.0 or earlier records.

For your information, Aspose.Cells supports BIFF8 or greater formats (Excel 97 - Excel 2007). I think you may try the following steps to work with the file:

Open your template .xls file in MS Excel (e.g…,Ms Excel 2003 or 2007).
Save the file As “Microsoft Office Excel Workbook”.
Now you can use Aspose.Cells to open/manipulate the file for your requirements, it will work fine.

Thank you.

4

That worked. Thank you.

5

@JR_Columbo,

Aspose.Cells now provides support (read/write) for older MS Excel file formats, including MS Excel 95/5.0 and 97, alongside its robust compatibility with newer versions such as MS Excel 2007, 2010, 2013, 2019, 2021 Workbook, Office 365, and OpenOffice formats. This enhancement ensures greater flexibility and usability across a wide range of Excel versions.

For detailed information on all supported file formats, please refer to the Supported File Formats documentation.

We encourage you to download the latest version of Aspose.Cells using the links below:

Please feel free to reach out to us with any questions or feedback you may have.