Code Snippet for Converting XLS to XLSX in Cross-Platform Projects

Help Studio
, , ,
1

Hi All,

Just wanted to share this code snippet with you guys which could help converting an XLS file to a XLSX file on a cross-platform project. It uses a Coded workflow to achieve this with the Free Spire.XLS package, sadly this makes it that the limit is up to 5 sheets per workbook and 150 rows in a sheet. This way you can get the sheets from a workbook that is an XLS without getting any strange errors.

Enjoy!
Convert XLS To XLSX.zip (173.3 KB)

2 Likes
Converting Excel FIles
How to convert xls to xlsx
Forum Engagement Daily Reports
2

Thanks Kevin! Very helpfull and will definitely use in my solution. I was running into this issue since we use cloud-robot-serverless and wanted to use ‘ClosedXML.Excel.XL Workbook’ to retrieve sheet names, however, ‘xls’ is not supported.

3

CovertXLStoXLSX.zip (929 Bytes)

This coded workflow uses the NPOI NuGet package to perform the conversion without limitations. To use it, make sure to install the package. Formulas are included, but note that cell values are currently limited to strings. Feel free to modify or extend this if needed.

1 Like
4

Hello,

Thank you for sharing this code snippet and the workflow! This is a great solution for those needing to handle legacy XLS files in cross-platform projects, especially since it avoids the strange errors sometimes encountered with the old format.

It is helpful to know that using the Free Spire.XLS package imposes a limit of up to 5 sheets per workbook and 150 rows in a sheet, as you mentioned. This is an important detail for anyone looking to implement this solution.

I appreciate you taking the time to share this with the community!