C# API to protect cloud Microsoft Excel and OpenOffice Calc spreadsheet with password

C# library to protect cloud Microsoft Excel and OpenOffice Calc spreadsheet with password

Use Cells Protect REST API to protect cloud Microsoft Excel and OpenOffice Calc spreadsheet with password workflows in C#. This professional solution protects cloud Microsoft Excel and OpenOffice Calc spreadsheet online with passwords using C#.

Protect cloud Microsoft Excel and OpenOffice Calc spreadsheet with password - C# REST API

API Request:
POST
https://api.aspose.cloud/v3.0/cells/{name}/encryption

Protecting a cloud spreadsheet with a password is a complex task. Protecting a cloud spreadsheet with password 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 protect cloud spreadsheets with a password online. This Cloud SDK gives C# developers powerful functionality and perfect API.

C# code for encryption cloud 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 PostEncryptWorkbook1Example()
{
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"));
PostEncryptWorkbookRequest request = new PostEncryptWorkbookRequest
{
name = "Book1.xlsx",
encryption = new Model.WorkbookEncryptionRequest
{
Password = "123456",
KeyLength = 128,
EncryptionType = "XOR"
},
folder = "TestData/In"
};
cellsApi.PostEncryptWorkbook(request);
}
}
}
// Obsolet
//CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
//string name = BOOK1;
//WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest();
//encryption.Password = "123456";
//encryption.KeyLength = 128;
//encryption.EncryptionType = "XOR";
//string folder = TEMPFOLDER;
//instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
//var response = instance.CellsWorkbookPostEncryptDocument(name, encryption, folder);
//Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
//Assert.AreEqual(response.Code, 200);


How to use C# API to encrypt


  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 CellsWorkbookPostEncryptDocument method to get the resultant stream


System Requirements


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