This Gist repository contains code snippet related to Aspose.Cells Cloud SDK for .NET

Aspose.Cells-Cloud-SDK-NET

Aspose.Cells-Cloud-SDK-NET

Example-Assemble.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostAssemble(mapFiles, "ds","pdf");
Assert.IsNotNull(filesResult);

Example-Batch-Convet.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
            CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
			
            BatchConvertRequest batchConvertRequest = new BatchConvertRequest();
            batchConvertRequest.Format = "pdf";
            batchConvertRequest.MatchCondition = new MatchConditionRequest();
            batchConvertRequest.MatchCondition.FullMatchConditions = new List<string> {"Book1.xlsx", "myDocument.xlsx" };
            batchConvertRequest.SourceFolder = "BatchFolder";
            var response =  instance.PostBatchConvert(batchConvertRequest);
            Assert.IsInstanceOf<Stream>(response, "response is CellsCloudResponse");

Example-Clear.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostClearObjects(mapFiles, "chart");
Assert.IsNotNull(filesResult);

Example-Delete-Worksheets.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
            CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
			
            MatchConditionRequest matchConditionRequest = new MatchConditionRequest();
            matchConditionRequest.FullMatchConditions = new List<string>() { "Sheet1", "Sheet2", "Sheet3" }; ;
            var name = "Book1.xlsx";

            string folder = "DotNetTest";
            UpdateDataFile(instance, folder, "Book1.xlsx");

            var response = instance.CellsWorksheetsDeleteWorksheets(name, matchConditionRequest, folder);
            Assert.IsInstanceOf<CellsCloudResponse>(response, "response is System.IO.Stream");

Example-DeleteWorksheetShape.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
string name = "Book1.xlsx";
string sheetName = "Sheet1";
int? shapeindex = 0;
string folder = "Temp";
Aspose.Cells.Cloud.SDK.Api.CellsApi instance = new Aspose.Cells.Cloud.SDK.Api.CellsApi("your client id", "your client secret");
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsShapesDeleteWorksheetShape(name, sheetName, shapeindex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Example-DeleteWorksheetShapes.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
string name = "Book1.xlsx";
string sheetName = "Sheet1";
string folder = "Temp";
Aspose.Cells.Cloud.SDK.Api.CellsApi instance = new Aspose.Cells.Cloud.SDK.Api.CellsApi("your client id", "your client secret");
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsShapesDeleteWorksheetShapes(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Example-Export-chart-png.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "chart","png");
Assert.IsNotNull(filesResult);

Example-Export-chart-tiff.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "chart","tiff");
Assert.IsNotNull(filesResult);

Example-Export-picture-png.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "picture","png");
Assert.IsNotNull(filesResult);

Example-Export-picture-tiff.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "picture","tiff");
Assert.IsNotNull(filesResult);

Example-Export-shape-png.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "shape","png");
Assert.IsNotNull(filesResult);

Example-Export-shape-tiff.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "shape","tiff");
Assert.IsNotNull(filesResult);

Example-Export-workbook-pdf.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "workbook","pdf");
Assert.IsNotNull(filesResult);

Example-Export-workbook-tiff.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "workbook","tiff");
Assert.IsNotNull(filesResult);

Example-Export.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostExport(mapFiles, "chart","pdf");
Assert.IsNotNull(filesResult);

Example-GetWorksheetShape.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
string name = "Book1.xlsx";
string sheetName = "Sheet1";
int? shapeindex = 0;
string folder = "Temp";
Aspose.Cells.Cloud.SDK.Api.CellsApi instance = new Aspose.Cells.Cloud.SDK.Api.CellsApi("your client id", "your client secret");
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsShapesGetWorksheetShape(name, sheetName, shapeindex, folder);
Assert.IsInstanceOf<ShapeResponse>(response, "response is ShapeResponse");
Assert.AreEqual(response.Code, 200);

Example-GetWorksheetShapes.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
string name = "Book1.xlsx";
string sheetName = "Sheet1";
string folder = "Temp";
Aspose.Cells.Cloud.SDK.Api.CellsApi instance = new Aspose.Cells.Cloud.SDK.Api.CellsApi("your client id", "your client secret");
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsShapesGetWorksheetShapes(name, sheetName, folder);
Assert.IsInstanceOf<ShapesResponse>(response, "response is ShapesResponse");
Assert.AreEqual(response.Code, 200);

Example-Merge.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult filesResult = liteCellsApi.PostMerge(mapFiles, "pdf"，false);
Assert.IsNotNull(filesResult);

Example-Metadata-Delete.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult result = liteCellsApi.DeleteMetadata(mapFiles);
Assert.IsNotNull(result);

Example-Metadata-Get.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
IList<Aspose.Cells.Cloud.SDK.Model.CellsDocumentProperty> result = liteCellsApi.GetMetadata(mapFiles);
Assert.IsNotNull(result);

Example-Metadata-Update.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
IList<Aspose.Cells.Cloud.SDK.Model.CellsDocumentProperty> cellsDocumentProperties = new List<Aspose.Cells.Cloud.SDK.Model.CellsDocumentProperty>();
cellsDocumentProperties.Add(new Aspose.Cells.Cloud.SDK.Model.CellsDocumentProperty { Name = "Test" ,Value ="test" });
Aspose.Cells.Cloud.SDK.Model.FilesResult result = liteCellsApi.PostMetadata(mapFiles,cellsDocumentProperties);
Assert.IsNotNull(result);

Example-PostWorksheetShape.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
string name = "Book1.xlsx";
string sheetName = "Sheet1";
int? shapeindex = 0;
Shape dto = new Shape();
dto.LowerRightColumn = 10;
string folder = "Temp";
Aspose.Cells.Cloud.SDK.Api.CellsApi instance = new Aspose.Cells.Cloud.SDK.Api.CellsApi("your client id", "your client secret");
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsShapesPostWorksheetShape(name, sheetName, shapeindex, dto, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Example-Protect.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult result = liteCellsApi.PostProtect(mapFiles,"123456");
Assert.IsNotNull(result);

Example-PutWorksheetShape.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
string name = "Book1.xlsx";
string sheetName = "Sheet1";
string drawingType = "button";
int? upperLeftRow = 1;
int? upperLeftColumn = 1;
int? top = 10;
int? left = 10;
int? width = 100;
int? height = 90;
string folder = "Temp";
Aspose.Cells.Cloud.SDK.Api.CellsApi instance = new Aspose.Cells.Cloud.SDK.Api.CellsApi("your client id", "your client secret");
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsShapesPutWorksheetShape(name, sheetName,null,drawingType, upperLeftRow, upperLeftColumn, top, left, width, height,  folder);
Assert.IsInstanceOf<ShapeResponse>(response, "response is ShapeResponse");
Assert.AreEqual(response.Code, 200);

Example-Search.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
IList<Aspose.Cells.Cloud.SDK.Model.TextItem> result = liteCellsApi.PostSearch(mapFiles,"1");
Assert.IsNotNull(result);

Example-Split.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult result = liteCellsApi.PostSplit(mapFiles,"pdf");
Assert.IsNotNull(result);

Example-Unlock.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult result = liteCellsApi.PostUnlock(mapFiles,"123456");
Assert.IsNotNull(result);

Example-Watermark.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

Aspose.Cells.Cloud.SDK.Api.LiteCellsApi liteCellsApi = new Aspose.Cells.Cloud.SDK.Api.LiteCellsApi("your client id", "your client secret");
IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
Aspose.Cells.Cloud.SDK.Model.FilesResult result = liteCellsApi.PostWatermark(mapFiles,"aspose","#fff");
Assert.IsNotNull(result);

Examples-DotNet-CSharp-Cells-ApplyRichTextFormatting-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET2;
string cellName = "G8";
List<FontSetting> options = new List<FontSetting>();
Font font = new Font();
font.Size = 10;
FontSetting fs1 = new FontSetting();
fs1.Font = font;
fs1.Length = 2;
fs1.StartIndex = 0;
options.Add(fs1);
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostCellCharacters(name, sheetName, cellName, options, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNet-CSharp-Cells-CalculateCellFormula-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
CalculationOptions options = new CalculationOptions();
options.IgnoreError = true;
bool? ignoreError = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostWorkbookCalculateFormula(name, options, ignoreError, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Cells-ChangeCellStyleWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellName = CellName;
Style style = new Style();
style.Font = new Font();
style.Font.Size = 19;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostUpdateWorksheetCellStyle(name, sheetName, cellName, style, folder);
Assert.IsInstanceOf<StyleResponse>(response, "response is StyleResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Cells-ClearCellContentStyleWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? startRow = 1;
int? startColumn = 1;
int? endRow = 3;
int? endColumn = 3;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostClearContents(name, sheetName, range, startRow, startColumn, endRow, endColumn, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Cells-ClearCellFormattingWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? startRow = 1;
int? startColumn = 1;
int? endRow = 3;
int? endColumn = 10;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostClearFormats(name, sheetName, range, startRow, startColumn, endRow, endColumn, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Cells-GetCellStyleWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellName = CellName;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCellStyle(name, sheetName, cellName, folder);
Assert.IsInstanceOf<StyleResponse>(response, "response is StyleResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Cells-GetCellWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "A1";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetFirstCellWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "firstcell";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetLastCellWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "lastcell";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetMaxColumnWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "maxcolumn";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetMaxDataColumnWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "maxdatacolumn";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetMaxDataRowWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "maxdatarow";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetMaxRowWorksheet-1.cs

CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "maxdatarow";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetMergedCellWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? mergedCellIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsGetWorksheetMergedCell(name, sheetName, mergedCellIndex, folder);
Assert.IsInstanceOf<MergedCellResponse>(response, "response is MergedCellResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Cells-GetMinColumnWorksheet-1.cs

CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "mincolumn";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetMinDataColumnWorksheet-1.cs

CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "mindatacolumn";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetMinDataRowWorksheet-1.cs

CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "mindatarow";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-GetMinRowWorksheet-1.cs

CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "minrow";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Cells-MergeCellsWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? startRow = 1;
int? startColumn = 1;
int? totalRows = 4;
int? totalColumns = 4;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostWorksheetMerge(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Cells-SetFormulaForCellWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellName = CellName;
string value = Value;
string type = Type;
string formula = Formula;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostWorksheetCellSetValue(name, sheetName, cellName, value, type, formula, folder);
Assert.IsInstanceOf<CellResponse>(response, "response is CellResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Cells-SetRangeValueWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellarea = CELLAREA;
string value = Value;
string type = Type;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostSetCellRangeValue(name, sheetName, cellarea, value, type, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Cells-SetValueOfCell-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellName = CellName;
string value = Value;
string type = Type;
string formula = Formula;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostWorksheetCellSetValue(name, sheetName, cellName, value, type, formula, folder);
Assert.IsInstanceOf<CellResponse>(response, "response is CellResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Cells-UnmergeCellsWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? startRow = 1;
int? startColumn = 1;
int? totalRows = 4;
int? totalColumns = 4;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostWorksheetUnmerge(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Charts-AddChart-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET4;
string chartType = "Pie";
int? upperLeftRow = 5;
int? upperLeftColumn = 5;
int? lowerRightRow = 10;
int? lowerRightColumn = 10;
string area = "C7:D11";
bool? isVertical = true;
string categoryData = null;
bool? isAutoGetSerialName = null;
string title = null;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsPutWorksheetAddChart(name, sheetName, chartType, upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, area, isVertical, categoryData, isAutoGetSerialName, title, folder);
Assert.IsInstanceOf<ChartsResponse>(response, "response is ChartsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-ConvertChartToImage-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartNumber = 0;
string folder = TEMPFOLDER;
string format = "png";
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsGetWorksheetChart(name, sheetName, chartNumber, format, folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Charts-DeleteAllCharts-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsDeleteWorksheetClearCharts(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-DeleteChart-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsDeleteWorksheetDeleteChart(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<ChartsResponse>(response, "response is ChartsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-DeleteChartTitle-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsDeleteWorksheetChartTitle(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-GetChart-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartNumber = 0;
string folder = TEMPFOLDER;
string format = "png";
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsGetWorksheetChart(name, sheetName, chartNumber, format, folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Charts-GetChartArea-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartAreaGetChartArea(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<ChartAreaResponse>(response, "response is ChartAreaResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-GetChartFillFormat-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartAreaGetChartAreaFillFormat(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<FillFormatResponse>(response, "response is FillFormatResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-GetChartLegend-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsGetWorksheetChartLegend(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<LegendResponse>(response, "response is LegendResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-HideChartLegend-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsDeleteWorksheetChartLegend(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-SetChartTitle-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
Title title = new Title();
title.Text = "New title";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsPutWorksheetChartTitle(name, sheetName, chartIndex, title, folder);
Assert.IsInstanceOf<TitleResponse>(response, "response is TitleResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-ShowChartLegend-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsPutWorksheetChartLegend(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-UpdateChartLegend-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
Legend legend = new Legend();
legend.Width = 10;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsPostWorksheetChartLegend(name, sheetName, chartIndex, legend, folder);
Assert.IsInstanceOf<LegendResponse>(response, "response is LegendResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Charts-UpdateChartProperties-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
Chart chart = new Chart ();
chart.AutoScaling = true;

string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsPostWorksheetChart(name, sheetName, chartIndex, chart, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Charts-UpdateChartTitle-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = MYDOC;
string sheetName = SHEET3;
int? chartIndex = 0;
Title title = new Title();
title.Text = "Post title";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsChartsPostWorksheetChartTitle(name, sheetName, chartIndex, title, folder);
Assert.IsInstanceOf<TitleResponse>(response, "response is TitleResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Columns-AddEmptyRowInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? rowIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPutInsertWorksheetColumns(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<RowResponse>(response, "response is RowResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Columns-AutoFitColumnsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
AutoFitterOptions autoFitterOptions = new AutoFitterOptions();
int? startRow = 1;
int? endRow = 100;
bool? onlyAuto = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostAutofitWorkbookRows(name, autoFitterOptions, startRow, endRow, onlyAuto, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Columns-CopyColumnsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? sourceRowIndex = 1;
int? destinationRowIndex = 1;
int? rowNumber = 1;
string worksheet = SHEET2;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostCopyWorksheetRows(name, sheetName, sourceRowIndex, destinationRowIndex, rowNumber, worksheet, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Columns-DeleteColumnFromWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? rowIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsDeleteWorksheetRow(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Columns-GetColumnFromWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? rowIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetRow(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<RowResponse>(response, "response is RowResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Columns-GroupColumnsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? firstIndex = 1;
int? lastIndex = 1;
bool? hide = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostGroupWorksheetRows(name, sheetName, firstIndex, lastIndex, hide, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Columns-HideColumnsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? startrow = 1;
int? totalRows = 2;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostHideWorksheetRows(name, sheetName, startrow, totalRows, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Columns-UngroupColumnsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? firstIndex = 1;
int? lastIndex = 5;
bool? isAll = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostUngroupWorksheetRows(name, sheetName, firstIndex, lastIndex, isAll, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Columns-UnhideColumnsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? startrow = 1;
int? totalRows = 8;
double? height = 18;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostUnhideWorksheetRows(name, sheetName, startrow, totalRows, height, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNet-CSharp-ConditionalFormatting-AddConditionforFormatCondition-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? index = 0;
string type = "CellValue";
string operatorType = "Between";
string formula1 = "v1";
string formula2 = "v2";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsConditionalFormattingsPutWorksheetFormatConditionCondition(name, sheetName, index, type, operatorType, formula1, formula2, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-ConditionalFormatting-AddFormatCondition-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? index = 0;
string cellArea = CELLAREA;
string type = "CellValue";
string operatorType = "Between";
string formula1 = "v1";
string formula2 = "v2";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsConditionalFormattingsPutWorksheetFormatCondition(name, sheetName, index, cellArea, type, operatorType, formula1, formula2, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-ConditionalFormatting-ClearConditionFormattings-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsConditionalFormattingsDeleteWorksheetConditionalFormattings(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-ConditionalFormatting-FormatConditionArea-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? index = 0;
string cellArea = CELLAREA;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsConditionalFormattingsPutWorksheetFormatConditionArea(name, sheetName, index, cellArea, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-ConditionalFormatting-GetConditionalFormatting-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? index = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsConditionalFormattingsGetWorksheetConditionalFormatting(name, sheetName, index, folder);
Assert.IsInstanceOf<ConditionalFormattingResponse>(response, "response is ConditionalFormattingResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-ConditionalFormatting-GetWorksheetConditionalFormatting-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsConditionalFormattingsGetWorksheetConditionalFormattings(name, sheetName, folder);
Assert.IsInstanceOf<ConditionalFormattingsResponse>(response, "response is ConditionalFormattingsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-ConditionalFormatting-RemoveCellAreaFromConditionalFormatting-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? startRow = 1;
int? startColumn = 1;
int? totalRows = 4;
int? totalColumns = 6;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsConditionalFormattingsDeleteWorksheetConditionalFormattingArea(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-ConditionalFormatting-RemoveConditionalFormatting-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? index = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsConditionalFormattingsDeleteWorksheetConditionalFormatting(name, sheetName, index, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Document-Properties-GetAllProperties-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPropertiesGetDocumentProperties(name, folder);
Assert.IsInstanceOf<CellsDocumentPropertiesResponse>(response, "response is CellsDocumentPropertiesResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Document-Properties-GetParticularProperty-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string propertyName = "Author";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPropertiesGetDocumentProperty(name, propertyName, folder);
Assert.IsInstanceOf<CellsDocumentPropertyResponse>(response, "response is CellsDocumentPropertyResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Document-Properties-RemoveAllProperties-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPropertiesDeleteDocumentProperties(name, folder);
Assert.IsInstanceOf<CellsDocumentPropertiesResponse>(response, "response is CellsDocumentPropertiesResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Document-Properties-RemoveParticularProperty-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPropertiesDeleteDocumentProperties(name, folder);
Assert.IsInstanceOf<CellsDocumentPropertiesResponse>(response, "response is CellsDocumentPropertiesResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Document-Properties-SetParticularProperty-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string propertyName = "Name";
CellsDocumentProperty property = new CellsDocumentProperty();
//(null, "Author", "Val"
property.Name = "Author";
property.Value = "Val";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPropertiesPutDocumentProperty(name, propertyName, property, folder);
Assert.IsInstanceOf<CellsDocumentPropertyResponse>(response, "response is CellsDocumentPropertyResponse");
Assert.AreEqual(response.Code, 201);

Examples-DotNET-CSharp-Hyperlinks-AddHyperlinkWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? firstRow = 1;
int? firstColumn = 1;
int? totalRows = 2;
int? totalColumns = 3;
string address = "http://wwww.aspose.com";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsHypelinksPutWorksheetHyperlink(name, sheetName, firstRow, firstColumn, totalRows, totalColumns, address, folder);
Assert.IsInstanceOf<HyperlinkResponse>(response, "response is HyperlinkResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Hyperlinks-DeleteHyperlinkWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? hyperlinkIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsHypelinksDeleteWorksheetHyperlink(name, sheetName, hyperlinkIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Hyperlinks-GetHyperlinkWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? hyperlinkIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsHypelinksGetWorksheetHyperlink(name, sheetName, hyperlinkIndex, folder);
Assert.IsInstanceOf<HyperlinkResponse>(response, "response is HyperlinkResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Hyperlinks-UpdateHyperlinkWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? hyperlinkIndex = 0;
Hyperlink hyperlink = new Hyperlink( );
//new Link("http://wwww.aspose.com"),"http://www.aspose.com",new CellArea(2,2,1,1
hyperlink.Address = "http://www.aspose.com";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsHypelinksPostWorksheetHyperlink(name, sheetName, hyperlinkIndex, hyperlink, folder);
Assert.IsInstanceOf<HyperlinkResponse>(response, "response is HyperlinkResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Images-AutoShapeToImageWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi cellsApi = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);


String name = "Sample_Test_Book";
String fileName = name + ".xls";
String sheetName = "Sheet4";
int autoshapeNumber = 1;
String format = "png";
String storage = "";
String folder = "";

try
{
    // Upload source file to aspose cloud storage
    cellsApi.UploadFile(folder + @"\" + filename, File.Open( @"C:\TestData\" + filename));

    // Invoke Aspose.Cells Cloud SDK API to convert autoshape to image 
    ResponseMessage apiResponse = cellsApi.CellsAutoshapesGetWorksheetAutoshape(fileName, sheetName, autoshapeNumber, format, storage, folder);

    if (apiResponse != null)
    {
        Console.WriteLine("Convert AutoShape to Image , Done!");
        Console.ReadKey();
    }
}
catch (Exception ex)
{
    System.Diagnostics.Debug.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace);
}

Examples-DotNet-CSharp-ImportData-PostImportDataCloudFile-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
ImportIntArrayOption data = new ImportIntArrayOption();
data.DestinationWorksheet = SHEET1;
data.FirstColumn = 1;
data.FirstRow = 3;
data.ImportDataType = "IntArray";
data.IsVertical = true;
data.Data = new List<int?> { 1, 2, 3, 4 };
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostImportData(name, data, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");

Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-ImportData-postImportDataMultipartContent-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
ImportIntArrayOption data = new ImportIntArrayOption();
data.DestinationWorksheet = SHEET1;
data.FirstColumn = 1;
data.FirstRow = 3;
data.ImportDataType = "IntArray";
data.IsVertical = true;
data.Data = new List<int?> { 1, 2, 3, 4 };
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostImportData(name, data, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");

Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-OleObjects-AddOleObjectsWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;

int? upperLeftRow = 1;
int? upperLeftColumn = 1;
int? height = 100;
int? width = 80;
string oleFile = "OLEDoc.docx";
string imageFile = "word.jpg";
string folder = TEMPFOLDER;
OleObject oleObject = new OleObject();
oleObject.UpperLeftColumn = 1;
oleObject.UpperLeftRow = 1;
oleObject.Width = 80;
oleObject.Height = 100;
oleObject.ImageSourceFullName = imageFile;
oleObject.SourceFullName = oleFile;
oleObject = null;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
UpdateDataFile(instance, oleFile);
UpdateDataFile(instance, imageFile);
var response = instance.CellsOleObjectsPutWorksheetOleObject(name, sheetName, oleObject, upperLeftRow, upperLeftColumn, height, width,  oleFile,  imageFile, folder);
Assert.IsInstanceOf<OleObjectResponse>(response, "response is OleObjectResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-OleObjects-ConvertOleObjectToImage-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
int? objectNumber = 0;
string format = "png";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsOleObjectsGetWorksheetOleObject(name, sheetName, objectNumber, format, folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-OleObjects-DeleteAllOleObjectsWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsOleObjectsDeleteWorksheetOleObjects(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-OleObjects-DeleteSpecificOleObjectWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
int? oleObjectIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsOleObjectsDeleteWorksheetOleObject(name, sheetName, oleObjectIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-OleObjects-GetOleObjectWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
int? objectNumber = 0;
string format = null;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsOleObjectsGetWorksheetOleObject(name, sheetName, objectNumber, format, folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-OleObjects-UpdateSpecificOleObjectsWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsOleObjectsGetWorksheetOleObjects(name, sheetName, folder);
Assert.IsInstanceOf<OleObjectsResponse>(response, "response is OleObjectsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Pictures-AddPicturesWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;

int? upperLeftRow = 1;
int? upperLeftColumn = 1;
int? lowerRightRow = 10;
int? lowerRightColumn = 10;
string picturePath = "WaterMark.png";
string folder = TEMPFOLDER;
Picture picture = new Picture();
picture.SourceFullName = folder + "\\" + picturePath;
picture.UpperLeftRow = 1;
picture.UpperLeftColumn = 1;
picture.LowerRightRow = 10;
picture.LowerRightColumn = 10;
//picture = null;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
UpdateDataFile(instance,folder, picturePath);
var response = instance.CellsPicturesPutWorksheetAddPicture(name, sheetName,picture, upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, folder + "\\" + picturePath, folder);
Assert.IsInstanceOf<PicturesResponse>(response, "response is PicturesResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Pictures-ConvertPictureToImage-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
int? pictureNumber = 0;
string format = "png";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPicturesGetWorksheetPicture(name, sheetName, pictureNumber, format,folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Pictures-DeleteAllPicturesWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPicturesDeleteWorksheetPictures(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Pictures-DeleteSpecificPictureWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
int? pictureIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPicturesDeleteWorksheetPicture(name, sheetName, pictureIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Pictures-GetPictureWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
int? pictureNumber = 0;
string format = null;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPicturesGetWorksheetPicture(name, sheetName, pictureNumber, format,folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Pictures-UpdateSpecificPictureWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
int? pictureIndex = 0;
Picture picture = new Picture ();
picture.Left = 10;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPicturesPostWorksheetPicture(name, sheetName, pictureIndex, picture, folder);
Assert.IsInstanceOf<PictureResponse>(response, "response is PictureResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-PivotTables-AddPivotFieldInPivottable-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = PivTestFile;
string sheetName = SHEET4;
int? pivotTableIndex = 0;
string pivotFieldType = "Row";
PivotTableFieldRequest request = new PivotTableFieldRequest();
request.Data = new List<int?>() { 1};
bool? needReCalculate = null;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPivotTablesPutPivotTableField(name, sheetName, pivotTableIndex, pivotFieldType, request, needReCalculate, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-PivotTables-AddPivottableWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = PivTestFile;
string sheetName = SHEET4;
CreatePivotTableRequest request = new CreatePivotTableRequest();
request.Name = "TestPivot";
request.DestCellName = "C1";
request.SourceData = "Sheet1!C6:E13";
request.UseSameSource = true;
request.PivotFieldColumns = new List<int?> { 1};
request.PivotFieldData = new List<int?> { 2 };
request.PivotFieldRows = new List<int?> { 3 };
request = null;
string folder = TEMPFOLDER;
string sourceData = "Sheet1!C6:E13";
string destCellName = "C1";
string tableName = "TestPivot";
bool? useSameSource = true;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPivotTablesPutWorksheetPivotTable(name, sheetName, request, folder, null, sourceData, destCellName, tableName, useSameSource);
Assert.IsInstanceOf<PivotTableResponse>(response, "response is PivotTableResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-PivotTables-DeleteWorksheetPivotTable-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = PivTestFile;
string sheetName = SHEET4;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPivotTablesDeleteWorksheetPivotTables(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-PivotTables-DeleteWorksheetPivotTableIndex-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = PivTestFile;
string sheetName = SHEET4;
int? pivotTableIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPivotTablesDeleteWorksheetPivotTable(name, sheetName, pivotTableIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-PivotTables-GetWorksheetPivotTableByIndex-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = PivTestFile;
string sheetName = SHEET4;
int? pivottableIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPivotTablesGetWorksheetPivotTable(name, sheetName, pivottableIndex, folder);
Assert.IsInstanceOf<PivotTableResponse>(response, "response is PivotTableResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-PivotTables-GetWorksheetPivotTables-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = PivTestFile;
string sheetName = SHEET4;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPivotTablesGetWorksheetPivotTables(name, sheetName, folder);
Assert.IsInstanceOf<PivotTablesResponse>(response, "response is PivotTablesResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Rows-AddEmptyRowInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? rowIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPutInsertWorksheetRow(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<RowResponse>(response, "response is RowResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Rows-AutoFitRowsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
AutoFitterOptions autoFitterOptions = new AutoFitterOptions();
int? startRow = 1;
int? endRow = 100;
bool? onlyAuto = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostAutofitWorkbookRows(name, autoFitterOptions, startRow, endRow, onlyAuto, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Rows-CopyRowsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? sourceRowIndex = 1;
int? destinationRowIndex = 1;
int? rowNumber = 1;
string worksheet = SHEET2;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostCopyWorksheetRows(name, sheetName, sourceRowIndex, destinationRowIndex, rowNumber, worksheet, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Rows-DeleteRowFromWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? rowIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsDeleteWorksheetRow(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Rows-GetRowFromWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? rowIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetRow(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<RowResponse>(response, "response is RowResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Rows-GroupRowsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? firstIndex = 1;
int? lastIndex = 1;
bool? hide = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostGroupWorksheetRows(name, sheetName, firstIndex, lastIndex, hide, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Rows-HideRowsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? startrow = 1;
int? totalRows = 2;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostHideWorksheetRows(name, sheetName, startrow, totalRows, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Rows-UngroupRowsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? firstIndex = 1;
int? lastIndex = 5;
bool? isAll = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostUngroupWorksheetRows(name, sheetName, firstIndex, lastIndex, isAll, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Rows-UnhideRowsInWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? startrow = 1;
int? totalRows = 8;
double? height = 18;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsPostUnhideWorksheetRows(name, sheetName, startrow, totalRows, height, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNet-CSharp-Table-SortTableData-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET7;
int? listObjectIndex = 0;
DataSorter dataSorter = new DataSorter();
dataSorter.CaseSensitive = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsListObjectsPostWorksheetListObjectSortTable(name, sheetName, listObjectIndex, dataSorter, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Tasks-ImportTaskData-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET6;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));

TaskData taskData = new TaskData();
taskData.Tasks = new List<TaskDescription>();
TaskDescription task1 = new TaskDescription();
task1.TaskType = "ImportData";

ImportDataTaskParameter param1 = new ImportDataTaskParameter();
ImportBatchDataOption importOption = new ImportBatchDataOption();
importOption.IsInsert = true;
importOption.DestinationWorksheet = "Sheet1";
importOption.Source = new FileSource();
importOption.Source.FilePath = "Batch_data_xml.txt";
importOption.Source.FileSourceType = "CloudFileSystem";
param1.ImportOption = importOption;
param1.Workbook = new FileSource();
param1.Workbook.FileSourceType = "CloudFileSystem";
param1.Workbook.FilePath = BOOK1;
task1.TaskParameter = param1;
taskData.Tasks.Add(task1);
TaskDescription task2 = new TaskDescription();
task2.TaskType = "SaveResult";
SaveResultTaskParameter param2 = new SaveResultTaskParameter();
param2.ResultDestination = new ResultDestination();
param2.ResultDestination.DestinationType = "CloudFileSystem";
param2.ResultDestination.OutputFile = "BOOK1.pdf";
param2.ResultDestination.InputFile = BOOK1;
param2.ResultSource = "InMemoryFiles";
task2.TaskParameter = param2;
taskData.Tasks.Add(task2);
var response = instance.CellsTaskPostRunTask(taskData);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Text-FindTextWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string text = "test";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostWorkbooksTextSearch(name, text, folder);
Assert.IsInstanceOf<TextItemsResponse>(response, "response is TextItemsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Text-FindTextWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string text = "123456";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPostWorksheetTextSearch(name, sheetName, text, folder);
Assert.IsInstanceOf<TextItemsResponse>(response, "response is TextItemsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Text-GetTextItemWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookGetWorkbookTextItems(name, folder);
Assert.IsInstanceOf<TextItemsResponse>(response, "response is TextItemsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Text-GetTextItemWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsGetWorksheetTextItems(name, sheetName, folder);
Assert.IsInstanceOf<TextItemsResponse>(response, "response is TextItemsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Text-ReplaceTextWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string oldValue = "!22";
string newValue = "22";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostWorkbooksTextReplace(name, oldValue, newValue, folder);
Assert.IsInstanceOf<WorkbookReplaceResponse>(response, "response is WorkbookReplaceResponse");

Examples-DotNET-CSharp-Text-ReplaceTextWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string oldValue = "1234";
string newValue = "56678";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPostWorsheetTextReplace(name, sheetName, oldValue, newValue, folder);
Assert.IsInstanceOf<WorksheetReplaceResponse>(response, "response is WorksheetReplaceResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Workbook-CalculateFormulas-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string formula = "=NOW()";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsGetWorksheetCalculateFormula(name, sheetName, formula, folder);
Assert.IsInstanceOf<SingleValueResponse>(response, "response is SingleValueResponse");

Examples-DotNET-CSharp-Workbook-ConvertToAnotherFormat-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string folder = TEMPFOLDER;
SaveOptions saveOptions = new SaveOptions();
saveOptions.SaveFormat = "xml";
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name),"DropBox");
var response = instance.CellsSaveAsPostDocumentSaveAs(name, saveOptions,  BOOK1+".xml", null,null,folder, "DropBox");
Assert.IsInstanceOf<SaveResponse>(response, "response is SaveResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-ConvertWorkbookToAnotherFormatWithoutStorage-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string workbook = BOOK1;
string format = "pdf";
string password = null;
string outPath = null;
var response = instance.CellsWorkbookPutConvertWorkbook(GetTestDataStream(workbook), format, password, outPath);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Workbook-ConvertWorkbookWithAdditionalSettings-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string workbook = BOOK1;
string format = "pdf";
string password = null;
string outPath = "Book1.pdf";
var response = instance.CellsWorkbookPutConvertWorkbook(GetTestDataStream(workbook), format, password, outPath);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Workbook-CreateEmptyWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);            
string name = "NewBook" + Guid.NewGuid().ToString() + ".xlsx";
string templateFile = BOOK1;
string dataFile = "ReportData.xml";
string folder = TEMPFOLDER;

instance.UploadFile(folder + @"\" + dataFile, File.Open( @"C:\TestData\" +dataFile));
instance.UploadFile(folder + @"\" + templateFile, File.Open( @"C:\TestData\" +templateFile));

var response = instance.CellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, folder + "/" + dataFile, false, folder);
Assert.IsInstanceOf<WorkbookResponse>(response, "response is WorkbookResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-CreateWorkbookFromSmartMakerTemplate-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);            
string name = "NewBook" + Guid.NewGuid().ToString() + ".xlsx";
string templateFile = BOOK1;
string dataFile = "ReportData.xml";
string folder = TEMPFOLDER;

instance.UploadFile(folder + @"\" + dataFile, File.Open( @"C:\TestData\" +dataFile));
instance.UploadFile(folder + @"\" + templateFile, File.Open( @"C:\TestData\" +templateFile));

var response = instance.CellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, folder + "/" + dataFile, false, folder);
Assert.IsInstanceOf<WorkbookResponse>(response, "response is WorkbookResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-CreateWorkbookFromTemplate-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);            
string name = "NewBook" + Guid.NewGuid().ToString() + ".xlsx";
string templateFile =  "ReportTemplate.xlsx";
string dataFile =null;
string folder = TEMPFOLDER;

instance.UploadFile(folder + @"\" + dataFile, File.Open( @"C:\TestData\" +dataFile));
instance.UploadFile(folder + @"\" + templateFile, File.Open( @"C:\TestData\" +templateFile));


var response = instance.CellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, dataFile, false, folder);
Assert.IsInstanceOf<WorkbookResponse>(response, "response is WorkbookResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-DecryptWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
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.CellsWorkbookDeleteDecryptDocument(name, encryption, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-EncryptWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
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);

Examples-DotNET-CSharp-Workbook-MergeWorkbooks-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string mergeWith = "myDocument.xlsx";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
UpdateDataFile(instance, mergeWith);
var response = instance.CellsWorkbookPostWorkbooksMerge(name, mergeWith, folder);
Assert.IsInstanceOf<WorkbookResponse>(response, "response is WorkbookResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-NamesCountWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookGetWorkbookNames(name, folder);
Assert.IsInstanceOf<NamesResponse>(response, "response is NamesResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-ProtectWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
WorkbookProtectionRequest protection = new WorkbookProtectionRequest();
protection.Password = "123";
protection.ProtectionType = "All";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostProtectDocument(name, protection, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-RemoveModifyPassword-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookDeleteDocumentUnprotectFromChanges(name, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-SetModifyPassword-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
PasswordRequest password = new PasswordRequest();
password.Password = "123456";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPutDocumentProtectFromChanges(name, password, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-SplitWorkbooks-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string format = "png";
int? from = 1;
int? to = 3;
int? horizontalResolution = 100;
int? verticalResolution = 90;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookPostWorkbookSplit(name, format, from, to, horizontalResolution, verticalResolution, folder);
Assert.IsInstanceOf<SplitResultResponse>(response, "response is SplitResultResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Workbook-UnprotectWorkbook-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
WorkbookProtectionRequest protection = new WorkbookProtectionRequest();
protection.Password = "123";
protection.ProtectionType = "All";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorkbookDeleteUnprotectDocument(name, protection, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-AddCustomFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? fieldIndex = 0;
string operatorType1 = "LessOrEqual";
string criteria1 = "test";
bool? isAnd = false;
string operatorType2 = "LessOrEqual";
string criteria2 = "test";
bool? matchBlanks = true;
bool? refresh = false;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPutWorksheetCustomFilter(name, sheetName, range, fieldIndex, operatorType1, criteria1, isAnd, operatorType2, criteria2, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-AddDataFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? fieldIndex = 0;
string dateTimeGroupingType = "Day";
int? year = 2019;
int? month = 1;
int? day = 1;
int? hour = 1;
int? minute = 1;
int? second = 1;
bool? matchBlanks = true;
bool? refresh = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPutWorksheetDateFilter(name, sheetName, range, fieldIndex, dateTimeGroupingType, year, month, day, hour, minute, second, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-AddDynamicFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? fieldIndex = 0;
string dynamicFilterType = "May";
bool? matchBlanks = true;
bool? refresh = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPutWorksheetDynamicFilter(name, sheetName, range, fieldIndex, dynamicFilterType, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-AddIconFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? fieldIndex = 0;
string iconSetType = "None";
int? iconId = 0;
bool? matchBlanks = null;
bool? refresh = null;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPutWorksheetIconFilter(name, sheetName, range, fieldIndex, iconSetType, iconId, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-AddNewSheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? position = 1;
string sheettype = "VB";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPutAddNewWorksheet(name, sheetName, position, sheettype, folder);
Assert.IsInstanceOf<WorksheetsResponse>(response, "response is WorksheetsResponse");
Assert.AreEqual(response.Code, 201);

Examples-DotNet-CSharp-Worksheet-AddWorksheetFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? fieldIndex = 0;
string criteria = "test";
bool? matchBlanks = true;
bool? refresh = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPutWorksheetFilter(name, sheetName, range, fieldIndex, criteria, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-CalculateFormula-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string formula = "=NOW()";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsGetWorksheetCalculateFormula(name, sheetName, formula, folder);
Assert.IsInstanceOf<SingleValueResponse>(response, "response is SingleValueResponse");

Examples-DotNET-CSharp-Worksheet-ConvertWorksheetToImage-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? verticalResolution = 100;
int? horizontalResolution = 90;
string format = "png";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsGetWorksheet(name, sheetName, format, verticalResolution, horizontalResolution, null,null,folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");

Examples-DotNET-CSharp-Worksheet-CopyWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = "NewCopy.xlsx";
string sheetName = SHEET5;
string sourceSheet = SHEET6;
CopyOptions options = new CopyOptions();
options.ColumnCharacterWidth = true;
string sourceWorkbook = BOOK1;
string sourceFolder = TEMPFOLDER;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
UpdateDataFile(instance,folder, sourceWorkbook);
var response = instance.CellsWorksheetsPostCopyWorksheet(name, sheetName, sourceSheet, options,  sourceWorkbook, sourceFolder, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-DeleteDataFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? fieldIndex = 1;
string dateTimeGroupingType = "Day";
int? year = 2010;
int? month = 10;
int? day = 1;
int? hour = 1;
int? minute = 1;
int? second = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterDeleteWorksheetDateFilter(name, sheetName, fieldIndex, dateTimeGroupingType, year, month, day, hour, minute, second, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-DeleteFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? fieldIndex = 1;
string criteria = "test";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterDeleteWorksheetFilter(name, sheetName, fieldIndex, criteria, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-DeleteWatermarkBackground-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsDeleteWorksheetBackground(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-DeleteWorksheetComments-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsDeleteWorksheetComments(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-FilterListUsingColorFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? fieldIndex = 0;
ColorFilterRequest colorFilter = new ColorFilterRequest();
Color color = new Color();//0, 255, 245, 2
color.R = 255;
color.A = 245;
color.B = 245;
color.G = 0;

colorFilter.ForegroundColor = new CellsColor();
colorFilter.ForegroundColor.Color = color;
colorFilter.ForegroundColor.ThemeColor = new ThemeColor();
colorFilter.ForegroundColor.ThemeColor.ColorType = "Text2";
colorFilter.ForegroundColor.ThemeColor.Tint =1;
colorFilter.ForegroundColor.Type = "Automatic";
colorFilter.BackgroundColor = new CellsColor();
colorFilter.BackgroundColor.Color = new Color();
colorFilter.BackgroundColor.Color.A = 255;
colorFilter.BackgroundColor.Color.R = 255;
colorFilter.BackgroundColor.Color.B = 0;
colorFilter.BackgroundColor.Color.G = 0;
colorFilter.BackgroundColor.ThemeColor = new ThemeColor();
colorFilter.BackgroundColor.ThemeColor.ColorType = "Text2";
colorFilter.BackgroundColor.ThemeColor.Tint = 1;
colorFilter.BackgroundColor.Type = "Automatic";
colorFilter.Pattern = "Solid";
bool? matchBlanks = true;
bool? refresh = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPutWorksheetColorFilter(name, sheetName, range, fieldIndex, colorFilter, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-FilterTop10-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? fieldIndex = 0;
bool? isTop = true;
bool? isPercent = true;
int? itemCount = 1;
bool? matchBlanks = null;
bool? refresh = null;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPutWorksheetFilterTop10(name, sheetName, range, fieldIndex, isTop, isPercent, itemCount, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-FreezePanes-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? row = 1;
int? column = 1;
int? freezedRows = 4;
int? freezedColumns = 5;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPutWorksheetFreezePanes(name, sheetName, row, column, freezedRows, freezedColumns, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-GetAutoshape-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi cellsApi = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);


String fileName = "Sample_Test_Book.xls";
String sheetName = "Sheet4";
int autoshapeNumber = 1;
String storage = "";
String folder = "";

try
{
    // Upload source file to aspose cloud storage
    cellsApi.UploadFile(folder + @"\" + filename, File.Open( @"C:\TestData\" + filename));

    // Invoke Aspose.Cells Cloud SDK API to get autoshape from worksheet
    AutoShapeResponse apiResponse = cellsApi.GetWorksheetAutoshape(fileName, sheetName, autoshapeNumber, storage, folder);

    if (apiResponse != null && apiResponse.Status.Equals("OK"))
    {
        AutoShape autoShape = apiResponse.AutoShape;
        Console.WriteLine(autoShape.HtmlText);
        Console.ReadKey();
    }
}
catch (Exception ex)
{
    System.Diagnostics.Debug.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace);
}

Examples-DotNET-CSharp-Worksheet-GetColumn-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? columnIndex = 1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsGetWorksheetColumn(name, sheetName, columnIndex, folder);
Assert.IsInstanceOf<ColumnResponse>(response, "response is ColumnResponse");
Assert.AreEqual(response.Status, "OK");

Examples-DotNET-CSharp-Worksheet-GetComment-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellName = "B3";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsGetWorksheetComment(name, sheetName, cellName, folder);
Assert.IsInstanceOf<CommentResponse>(response, "response is CommentResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-GetValidation-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? validationIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetValidationsGetWorksheetValidation(name, sheetName, validationIndex, folder);
Assert.IsInstanceOf<ValidationResponse>(response, "response is ValidationResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-GetWorksheetAutoFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterGetWorksheetAutoFilter(name, sheetName, folder);
Assert.IsInstanceOf<AutoFilterResponse>(response, "response is AutoFilterResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-GetWorksheetCount-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsGetWorksheets(name, folder);
Assert.IsInstanceOf<WorksheetsResponse>(response, "response is WorksheetsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-HideWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
bool? isVisible = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPutChangeVisibilityWorksheet(name, sheetName, isVisible, folder);
Assert.IsInstanceOf<WorksheetResponse>(response, "response is WorksheetResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-MatchBlankCells-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? fieldIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPostWorksheetMatchBlanks(name, sheetName, fieldIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-MatchNonBlankCells-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? fieldIndex = 0;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPostWorksheetMatchNonBlanks(name, sheetName, fieldIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-MoveWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
WorksheetMovingRequest moving = new WorksheetMovingRequest();//SHEET3, "after"
moving.DestinationWorksheet = SHEET3;
moving.Position = "after";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPostMoveWorksheet(name, sheetName, moving, folder);
Assert.IsInstanceOf<WorksheetsResponse>(response, "response is WorksheetsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNet-CSharp-Worksheet-RefreshAutoFilter-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsAutoFilterPostWorksheetAutoFilterRefresh(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-RemoveWorksheet -1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsDeleteWorksheet(name, sheetName, folder);
Assert.IsInstanceOf<WorksheetsResponse>(response, "response is WorksheetsResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-RenameWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string newname = "renametest";
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPostRenameWorksheet(name, sheetName, newname, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-SetWatermarkBackground-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));

var response = instance.CellsWorksheetsPutWorksheetBackground(name, sheetName, GetTestDataByteArray("WaterMark.png"), folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-SortWorksheetData-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellArea = CELLAREA;
DataSorter dataSorter = new DataSorter();
dataSorter.CaseSensitive = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPostWorksheetRangeSort(name, sheetName, cellArea, dataSorter, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-UnfreezePanes-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
int? row = 1;
int? column = 1;
int? freezedRows = 2;
int? freezedColumns = 2;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsDeleteWorksheetFreezePanes(name, sheetName, row, column, freezedRows, freezedColumns, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-UnhideWorksheet-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
bool? isVisible = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPutChangeVisibilityWorksheet(name, sheetName, isVisible, folder);
Assert.IsInstanceOf<WorksheetResponse>(response, "response is WorksheetResponse");
Assert.AreEqual(response.Code, 200);

Examples-DotNET-CSharp-Worksheet-UpdateWorksheetProperties-1.cs

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
Worksheet sheet = new Worksheet();
sheet.Index = 0;
sheet.IsGridlinesVisible = true;
string folder = TEMPFOLDER;
instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
var response = instance.CellsWorksheetsPostUpdateWorksheetProperty(name, sheetName, sheet, folder);
Assert.IsInstanceOf<WorksheetResponse>(response, "response is WorksheetResponse");
Assert.AreEqual(response.Code, 200);