Unable to convert MS Excel workbook from XLSX to XLS format

Aspose.Cells Product Family
1

I am trying to convert the attached workbook from *.xlsx format to *.xls. Aspose.Cells create a *.xls file, but when I open it with MS Excel there is an error message: “We found a problem with some content in …”.
MS Excel opens the original workbook without any problem.

Code sample:
var wb = new Workbook(inputFile);
wb.Save(“workbook.xls”);

I use Aspose.Cells.dll 25.2.0.0 and Microsoft® Excel® for Microsoft 365 MSO (Version 2501 Build 16.0.18429.20132) 64-bit.
test5.zip (19.2 KB)

2

@licenses

It seems you are encountering an issue when converting an Excel workbook from XLSX to XLS format using Aspose.Cells. The error message you receive in Microsoft Excel indicates that there may be a problem with the content of the generated XLS file.

To ensure a successful conversion, you can try the following steps:

  1. Use the Correct Save Format: When saving the workbook, explicitly specify the save format as SaveFormat.Excel97To2003. This can help avoid any issues related to format compatibility. Here’s how you can modify your code:

    var wb = new Workbook(inputFile);
wb.Save("workbook.xls", SaveFormat.Excel97To2003);

  2. Check for Compatibility Issues: Ensure that the original XLSX file does not contain features that are not supported in the XLS format. Some advanced features in XLSX may not translate well to the older XLS format.

  3. Update Aspose.Cells: You are using version 25.2.0.0 of Aspose.Cells. Consider updating to the latest version, as there may have been bug fixes or improvements related to file format conversions.

  4. Test with a Simple Workbook: To isolate the issue, try converting a simple XLSX file that contains basic data and formatting. If this works, the problem may lie with specific content in your original workbook.

  5. Review Documentation and Examples: You can refer to the official Aspose documentation and examples for saving files in different formats. For instance, there are examples available that demonstrate how to save a workbook in the Excel 97-2003 format, which might provide additional insights.

If you continue to experience issues after trying these suggestions, please provide more details about the content of the original XLSX file, as this may help in diagnosing the problem further.

Sources:
[1]: SaveFileInExcel972003format.cs

3
  1. I have tried to state the format directly, but the result is the same. The workbook is corrupted.
  2. These are not supposed to corrupt a workbook.
  3. I use the latest version of Aspose.Cells already.
  4. Most of the other workbooks convert without corruption of data.
  5. I checked these already.
4

@licenses,

Thanks for the template XLSX file.

After initial testing, I am able to reproduce the issue as you mentioned when converting your template XLSX file to XLS. I found the output file is corrupted and MS Excel gives error message when opening the file into it.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57846

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

5

@licenses,

We are pleased to inform you that your issue (logged earlier as “CELLSNET-57846”) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v25.3) scheduled for release first half of March (next month). You will be notified when the next version is published.

6

The issues you have found earlier (filed as CELLSNET-57846) have been fixed in this update. This message was posted using Bugs notification tool by leoluo