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

C# 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 C#. This professional solution clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet using C#.

C#
Java
Python
PHP
Go
Node
Perl
Swift
Ruby
Android

Clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet - C# 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 C# SDK while maintaining the source spreadsheet's main structural and logical content. Our C# library is a professional solution to Clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet online. This Cloud SDK gives C# developers powerful functionality and perfect API.

Net code for clearing duplicate rows on local spreadsheets

namespace Aspose.Cells.Cloud.SDK.Tests.Api.Example
{
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Aspose.Cells.Cloud.SDK.Request;
using System.Collections.Generic;
using Aspose.Cells.Cloud.SDK.Api;
using Aspose.Cells.Cloud.SDK.Model;
using System;
using System.IO;
[TestClass]
public class CellsApiExample
{
string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
string localName = "Book1.xlsx";
string localPath = "D:/TestData/CellsCloud";
[TestCategory("Cells")]
[TestMethod]
public void Example()
{
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add(localName, File.OpenRead(localPath +"/"+ localName));
PostClearObjectsRequest request = new PostClearObjectsRequest { File = mapFiles, objecttype = "duplicaterows", outFormat = "pdf" };
cellsApi.PostClearObjects(request);
}
}
}
view raw Example-Clear-DuplicateRows.cs hosted with ❤ by GitHub


How to use C# API to clear duplicate rows

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


System Requirements

  1. NET Framework 4.5.2 or newer
  2. Net Standard 2.0 or newer