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

C# Clear to clear blank rows on local Microsoft Excel and OpenOffice Calc spreadsheet

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

C#
Java
Python
PHP
Go
Node
Perl
Swift
Ruby
Android

Clear blank 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 blank rows on local Microsoft Excel and OpenOffice Calc spreadsheet is a complex task. Clearing blank 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 blank 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 blank rows on local spreadsheets

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
namespace Aspose.Cells.Cloud.SDK.Example
{
using Aspose.Cells.Cloud.SDK.Api;
using Aspose.Cells.Cloud.SDK.Request;
using System;
using System.Collections.Generic;
using System.IO;
public partial class CellsApiExample
{
public void PostClearObjectsBlankrowsExample()
{
CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("Book1.xlsx", File.OpenRead(@"TestData\Book1.xlsx"));
mapFiles.Add("myDocument.xlsx", File.OpenRead(@"TestData\myDocument.xlsx"));
PostClearObjectsRequest request = new PostClearObjectsRequest { File = mapFiles, objecttype = "blankrows", outFormat = "pdf" };
cellsApi.PostClearObjects(request);
}
}
}
view raw Example-Clear-BlankRows.cs hosted with ❤ by GitHub


How to use C# API to clear blank 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