How to convert quicly XLSX file to XLS file?

Edouard Durand

Hello,

I have several XLSX files and I would like to convert each of its files to XLS format in a very fast time, that is to say the conversion of an XLSX file to XLS should take some 100 ms.
To do this, I had thought of using Interop, but it is very slow, at least 8 seconds to convert an XLSX file to XLS.

With Interop, it is very slow to convert XLSX to XLS.

Do you know of a library in C# that allows you to convert an XLSX file to XLS very quickly (ideally 300 ms/file) ?
If yes, could you give me an example of C # code, please?

Thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Marvin Reid5y ago
Converting from multiple XLSX files to the XLS file can be done by using the DocumentConverter class found in the LEADTOOLS SDK. It is thread safe to meet the speed requirements. You can use this code to perform the conversion:
using (DocumentConverter documentConverter = new DocumentConverter())
{
   var input = @"C:\Input\Leadtools.xlsx");
   var output = @"C:\Output\output.xls");
   var jobData = DocumentConverterJobs.CreateJobData(input, output, DocumentFormat.Xls);
   jobData.JobName = "conversion job";

   var documentWriter = new DocumentWriter();
   documentConverter.SetDocumentWriterInstance(documentWriter);

   var renderingEngine = new AnnWinFormsRenderingEngine();
   documentConverter.SetAnnRenderingEngineInstance(renderingEngine);

   var job = documentConverter.Jobs.CreateJob(jobData);
   documentConverter.Jobs.RunJob(job);
}
leadtools.com/help/sdk/v21/dh/doxc/documentconverter.html
leadtools.com/help/sdk/v21/tutorials/dotnet-winforms-convert-files-with-the-document-converter.html
0
Leon D6y ago
You can use Free Spire.XLS(https://www.nuget.org/packages/FreeSpire.XLS/) library to quickly convert xlsx file to xls file by using the following code:
Workbook book = new Workbook();
book.LoadFromFile("XLS1.xlsx");
book.SaveToFile("result.xls", ExcelVersion.Version97to2003);
For more information, refer to this link:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Conversion/NET-Excel-Conversion-between-Excel-97-2003.xls-and-Excel-2007.xlsx.html
0