How to Convert ODS to XLSX in Node.JS

Cloudmersive
Sep 28, 2020 · 2 min read

OpenDocument Spreadsheet (ODS) is an XML-based format that is similar to Excel as it provides spreadsheet creation and editing capabilities. The main difference, however, is that ODS files are available for free through the OpenOffice suite. This provides users without standard access to the traditional Office suite with alternatives to its (often expensive) applications. To allow for improved sharing between the formats, XLSX and ODS, the following API will show you how to convert ODS to XLSX instantly.

Image for post
Image for post

Our first step is to install our SDK:

npm install cloudmersive-convert-api-client --save

Or, you can add this to this snippet to your package.json:

"dependencies": {
"cloudmersive-convert-api-client": "^2.4.8"
}

Then, you can call our function, ConvertDocumentOdsToXlsx:

var CloudmersiveConvertApiClient = require('cloudmersive-convert-api-client');
var defaultClient = CloudmersiveConvertApiClient.ApiClient.instance;
// Configure API key authorization: Apikey
var Apikey = defaultClient.authentications['Apikey'];
Apikey.apiKey = 'YOUR API KEY';
var apiInstance = new CloudmersiveConvertApiClient.ConvertDocumentApi();var inputFile = Buffer.from(fs.readFileSync("C:\\temp\\inputfile").buffer); // File | Input file to perform the operation on.var callback = function(error, data, response) {
if (error) {
console.error(error);
} else {
console.log('API called successfully. Returned data: ' + data);
}
};
apiInstance.convertDocumentOdsToXlsx(inputFile, callback);

With that, you can improve accessibility and affordability for your organizational documentation. You can access your free API Key on the Cloudmersive website. This will give you access to 800 monthly calls across our library of APIs.

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store