Convert XLS to SQL using Cells Cloud SDK for NodeJS
API
PUT
https://api.aspose.cloud/v3.0/cells/convert
Converting file formats from XLS to SQL can be a complex task. Our NodeJS SDK handles all XLS to SQL format conversions while preserving the main structural and logical content of the source XLS spreadsheet. Our NodeJS library provides a professional solution for converting XLS to SQL files online. This Cloud SDK empowers NodeJS developers with powerful functionality and ensures high-quality SQL output.
NodeJS Code Example for converting XLS to SQL using Cells Cloud SDK
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node/
const { CellsApi, CellsWorkbook_PutConvertWorkbookRequest } = require("asposecellscloud");
const localPath = "../TestData/source/";
var fs = require('fs');
var path = require('path');
const cellsApi = new CellsApi(process.env.ProductClientId, process.env.ProductClientSecret);
var req = new CellsWorkbook_PutConvertWorkbookRequest({
file: fs.createReadStream(localPath + "datasource.xls"),
format: "sql",
});
cellsApi.cellsWorkbookPutConvertWorkbook(req)
.then((result) => {
console.log(result)
});
How to convert XLS to SQL using the Cells Cloud NodeJS library.
- Register an account at Dashboard to get free API quota & authorization details
- Install NodeJS library and add the reference (import the library) to your project.
- Open the source file in JavaScript.
- Use the `putConvertWorkbook` method to retrieve the resulting stream.
System Requirements
- node v6.17.1 or newer