NodeJS API to clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet

NodeJS Clear to clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet

Use Cells Clear REST API to clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet workflows in NodeJS. This professional solution clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet using NodeJS.

Clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet - NodeJS REST API

API Request:

POST

https://api.aspose.cloud/v3.0/cells/clear

Api Reference

Clearing duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet is a complex task. Clearing duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet transitions is performed by our NodeJS SDK while maintaining the source spreadsheet's main structural and logical content. Our NodeJS library is a professional solution to Clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet online. This Cloud SDK gives NodeJS developers powerful functionality and perfect API.

NodeJS code for clearing duplicate rows on local spreadsheets

	const { CellsApi, PostClearObjectsRequest } = require("asposecellscloud");
	const clientId = process.env.CellsCloudClientId;
	const clientSecret = process.env.CellsCloudClientSecret;
	const ApiURL = process.env.CellsCloudApiBaseUrl;

	const localPath = "D:/aspose-cells-cloud-node/TestData/"
	var fs = require('fs');
	var path = require('path');
	const cellsApi = new CellsApi(clientId, clientSecret,"v3.0",ApiURL);
	const AssemblyTestXlsx = "assemblytest.xlsx";
	const DataSourceXlsx = "datasource.xlsx";
	const dataAssemblyTestXlsx = fs.createReadStream(path.join(localPath, AssemblyTestXlsx));
	const dataDataSourceXlsx = fs.createReadStream(path.join(localPath, DataSourceXlsx));

	const req = new PostClearObjectsRequest({
	file: { AssemblyTestXlsx: dataAssemblyTestXlsx, DataSourceXlsx: dataDataSourceXlsx },
	objecttype: "DuplicateRows"
	});


	cellsApi.postClearObjects(req)
	.then((result) => {
	console.log("successfully")
	const buff = Buffer.from(result.body.files[0].fileContent, 'base64');
	fs.writeFileSync(result.body.files[0].filename, buff);
	})
	.catch((error) => {
	console.error('Unhandled Promise Rejection:', error);
	});

view raw Example-Clear-DuplicateRows.js hosted with ❤ by GitHub

How to use Node API to clear duplicate rows

Create an account at Dashboard to get free API quota & authorization details
Initialize CellsApi with Client Id, Client Secret, Base URL & API version
Call postClearObjects method to get the resultant stream

System Requirements

node v6.17.1 or newer