Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
This Gist repository contains code snippet related to Aspose.Cells Cloud SDK for .NET
Aspose.Cells-Cloud-SDK-NET
// 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";
UpdateDataFile(instance,folder, name);
var response = instance.CellsShapesDeleteWorksheetShape(name, sheetName, shapeindex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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";
UpdateDataFile(instance,folder, name);
var response = instance.CellsShapesDeleteWorksheetShapes(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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";
UpdateDataFile(instance,folder, name);
var response = instance.CellsShapesGetWorksheetShape(name, sheetName, shapeindex, folder);
Assert.IsInstanceOf<ShapeResponse>(response, "response is ShapeResponse");
Assert.AreEqual(response.Code, 200);
// 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";
UpdateDataFile(instance,folder, name);
var response = instance.CellsShapesGetWorksheetShapes(name, sheetName, folder);
Assert.IsInstanceOf<ShapesResponse>(response, "response is ShapesResponse");
Assert.AreEqual(response.Code, 200);
// 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";
UpdateDataFile(instance,folder, name);
var response = instance.CellsShapesPostWorksheetShape(name, sheetName, shapeindex, dto, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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";
UpdateDataFile(instance,folder, 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);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostCellCharacters(name, sheetName, cellName, options, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookPostWorkbookCalculateFormula(name, options, ignoreError, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostUpdateWorksheetCellStyle(name, sheetName, cellName, style, folder);
Assert.IsInstanceOf<StyleResponse>(response, "response is StyleResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostClearContents(name, sheetName, range, startRow, startColumn, endRow, endColumn, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostClearFormats(name, sheetName, range, startRow, startColumn, endRow, endColumn, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCellStyle(name, sheetName, cellName, folder);
Assert.IsInstanceOf<StyleResponse>(response, "response is StyleResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
}
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "maxdatarow";
string folder = TEMPFOLDER;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsGetWorksheetMergedCell(name, sheetName, mergedCellIndex, folder);
Assert.IsInstanceOf<MergedCellResponse>(response, "response is MergedCellResponse");
Assert.AreEqual(response.Code, 200);
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "mincolumn";
string folder = TEMPFOLDER;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "mindatacolumn";
string folder = TEMPFOLDER;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "mindatarow";
string folder = TEMPFOLDER;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
string name = BOOK1;
string sheetName = SHEET1;
string cellOrMethodName = "minrow";
string folder = TEMPFOLDER;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder);
Assert.IsInstanceOf<Object>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostWorksheetMerge(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
var response = instance.CellsPostWorksheetCellSetValue(name, sheetName, cellName, value, type, formula, folder);
Assert.IsInstanceOf<CellResponse>(response, "response is CellResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostSetCellRangeValue(name, sheetName, cellarea, value, type, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
var response = instance.CellsPostWorksheetCellSetValue(name, sheetName, cellName, value, type, formula, folder);
Assert.IsInstanceOf<CellResponse>(response, "response is CellResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostWorksheetUnmerge(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,folder, 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);
// 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";
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsGetWorksheetChart(name, sheetName, chartNumber, format, folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsDeleteWorksheetClearCharts(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsDeleteWorksheetDeleteChart(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<ChartsResponse>(response, "response is ChartsResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsDeleteWorksheetChartTitle(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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";
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsGetWorksheetChart(name, sheetName, chartNumber, format, folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartAreaGetChartArea(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<ChartAreaResponse>(response, "response is ChartAreaResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartAreaGetChartAreaFillFormat(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<FillFormatResponse>(response, "response is FillFormatResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsGetWorksheetChartLegend(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<LegendResponse>(response, "response is LegendResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsDeleteWorksheetChartLegend(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsPutWorksheetChartTitle(name, sheetName, chartIndex, title, folder);
Assert.IsInstanceOf<TitleResponse>(response, "response is TitleResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsPutWorksheetChartLegend(name, sheetName, chartIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsPostWorksheetChartLegend(name, sheetName, chartIndex, legend, folder);
Assert.IsInstanceOf<LegendResponse>(response, "response is LegendResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsPostWorksheetChart(name, sheetName, chartIndex, chart, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsChartsPostWorksheetChartTitle(name, sheetName, chartIndex, title, folder);
Assert.IsInstanceOf<TitleResponse>(response, "response is TitleResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, 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);
// 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;
UpdateDataFile(instance,folder, 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);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsConditionalFormattingsDeleteWorksheetConditionalFormattings(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsConditionalFormattingsPutWorksheetFormatConditionArea(name, sheetName, index, cellArea, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsConditionalFormattingsGetWorksheetConditionalFormatting(name, sheetName, index, folder);
Assert.IsInstanceOf<ConditionalFormattingResponse>(response, "response is ConditionalFormattingResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsConditionalFormattingsGetWorksheetConditionalFormattings(name, sheetName, folder);
Assert.IsInstanceOf<ConditionalFormattingsResponse>(response, "response is ConditionalFormattingsResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsConditionalFormattingsDeleteWorksheetConditionalFormattingArea(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsConditionalFormattingsDeleteWorksheetConditionalFormatting(name, sheetName, index, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPropertiesGetDocumentProperties(name, folder);
Assert.IsInstanceOf<CellsDocumentPropertiesResponse>(response, "response is CellsDocumentPropertiesResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPropertiesGetDocumentProperty(name, propertyName, folder);
Assert.IsInstanceOf<CellsDocumentPropertyResponse>(response, "response is CellsDocumentPropertyResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPropertiesDeleteDocumentProperties(name, folder);
Assert.IsInstanceOf<CellsDocumentPropertiesResponse>(response, "response is CellsDocumentPropertiesResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPropertiesDeleteDocumentProperties(name, folder);
Assert.IsInstanceOf<CellsDocumentPropertiesResponse>(response, "response is CellsDocumentPropertiesResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPropertiesPutDocumentProperty(name, propertyName, property, folder);
Assert.IsInstanceOf<CellsDocumentPropertyResponse>(response, "response is CellsDocumentPropertyResponse");
Assert.AreEqual(response.Code, 201);
// 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.PutCreate(fileName, "", "", System.IO.File.ReadAllBytes(Common.GetDataDir() + fileName));
// Invoke Aspose.Cells Cloud SDK API to convert autoshape to image
ResponseMessage apiResponse = cellsApi.GetWorksheetAutoshapeWithFormat(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);
}
// 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;
UpdateDataFile(instance, TEMPFOLDER, BOOK1);
var response = instance.CellsWorkbookPostImportData(name, data, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, TEMPFOLDER, BOOK1);
var response = instance.CellsWorkbookPostImportData(name, data, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, 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);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsOleObjectsGetWorksheetOleObject(name, sheetName, objectNumber, format, folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsOleObjectsDeleteWorksheetOleObjects(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsOleObjectsDeleteWorksheetOleObject(name, sheetName, oleObjectIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsOleObjectsGetWorksheetOleObject(name, sheetName, objectNumber, format, folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsOleObjectsGetWorksheetOleObjects(name, sheetName, folder);
Assert.IsInstanceOf<OleObjectsResponse>(response, "response is OleObjectsResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, 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);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPicturesGetWorksheetPicture(name, sheetName, pictureNumber, format,folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPicturesDeleteWorksheetPictures(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPicturesDeleteWorksheetPicture(name, sheetName, pictureIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPicturesGetWorksheetPicture(name, sheetName, pictureNumber, format,folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPicturesPostWorksheetPicture(name, sheetName, pictureIndex, picture, folder);
Assert.IsInstanceOf<PictureResponse>(response, "response is PictureResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPivotTablesPutPivotTableField(name, sheetName, pivotTableIndex, pivotFieldType, request, needReCalculate, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, 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);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPivotTablesDeleteWorksheetPivotTables(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPivotTablesDeleteWorksheetPivotTable(name, sheetName, pivotTableIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPivotTablesGetWorksheetPivotTable(name, sheetName, pivottableIndex, folder);
Assert.IsInstanceOf<PivotTableResponse>(response, "response is PivotTableResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsPivotTablesGetWorksheetPivotTables(name, sheetName, folder);
Assert.IsInstanceOf<PivotTablesResponse>(response, "response is PivotTablesResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPutInsertWorksheetRow(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<RowResponse>(response, "response is RowResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookPostAutofitWorkbookRows(name, autoFitterOptions, startRow, endRow, onlyAuto, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostCopyWorksheetRows(name, sheetName, sourceRowIndex, destinationRowIndex, rowNumber, worksheet, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsDeleteWorksheetRow(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsGetWorksheetRow(name, sheetName, rowIndex, folder);
Assert.IsInstanceOf<RowResponse>(response, "response is RowResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostGroupWorksheetRows(name, sheetName, firstIndex, lastIndex, hide, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostHideWorksheetRows(name, sheetName, startrow, totalRows, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostUngroupWorksheetRows(name, sheetName, firstIndex, lastIndex, isAll, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsPostUnhideWorksheetRows(name, sheetName, startrow, totalRows, height, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Status, "OK");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsListObjectsPostWorksheetListObjectSortTable(name, sheetName, listObjectIndex, dataSorter, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, 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");
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookPostWorkbooksTextSearch(name, text, folder);
Assert.IsInstanceOf<TextItemsResponse>(response, "response is TextItemsResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsPostWorksheetTextSearch(name, sheetName, text, folder);
Assert.IsInstanceOf<TextItemsResponse>(response, "response is TextItemsResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookGetWorkbookTextItems(name, folder);
Assert.IsInstanceOf<TextItemsResponse>(response, "response is TextItemsResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsGetWorksheetTextItems(name, sheetName, folder);
Assert.IsInstanceOf<TextItemsResponse>(response, "response is TextItemsResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookPostWorkbooksTextReplace(name, oldValue, newValue, folder);
Assert.IsInstanceOf<WorkbookReplaceResponse>(response, "response is WorkbookReplaceResponse");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsPostWorsheetTextReplace(name, sheetName, oldValue, newValue, folder);
Assert.IsInstanceOf<WorksheetReplaceResponse>(response, "response is WorksheetReplaceResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsGetWorksheetCalculateFormula(name, sheetName, formula, folder);
Assert.IsInstanceOf<SingleValueResponse>(response, "response is SingleValueResponse");
// 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;
UpdateDataFileToOtherStorage(instance, folder, name, "DropBox");
SaveOptions saveOptions = new SaveOptions();
saveOptions.SaveFormat = "xml";
var response = instance.CellsSaveAsPostDocumentSaveAs(name, saveOptions, BOOK1+".xml", null,null,folder, "DropBox");
Assert.IsInstanceOf<SaveResponse>(response, "response is SaveResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, TEMPFOLDER, BOOK1);
var response = instance.CellsWorkbookPutConvertWorkbook(GetTestDataStream(workbook), format, password, outPath);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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";
UpdateDataFile(instance, TEMPFOLDER, BOOK1);
var response = instance.CellsWorkbookPutConvertWorkbook(GetTestDataStream(workbook), format, password, outPath);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance, folder, templateFile);
UpdateDataFile(instance, folder, dataFile);
var response = instance.CellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, folder + "/" + dataFile, false, folder);
Assert.IsInstanceOf<WorkbookResponse>(response, "response is WorkbookResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, templateFile);
UpdateDataFile(instance, folder, dataFile);
var response = instance.CellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, folder + "/" + dataFile, false, folder);
Assert.IsInstanceOf<WorkbookResponse>(response, "response is WorkbookResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, templateFile);
UpdateDataFile(instance, folder, dataFile);
var response = instance.CellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, dataFile, false, folder);
Assert.IsInstanceOf<WorkbookResponse>(response, "response is WorkbookResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookDeleteDecryptDocument(name, encryption, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookPostEncryptDocument(name, encryption, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
UpdateDataFile(instance, mergeWith);
var response = instance.CellsWorkbookPostWorkbooksMerge(name, mergeWith, folder);
Assert.IsInstanceOf<WorkbookResponse>(response, "response is WorkbookResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookGetWorkbookNames(name, folder);
Assert.IsInstanceOf<NamesResponse>(response, "response is NamesResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookPostProtectDocument(name, protection, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookDeleteDocumentUnprotectFromChanges(name, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookPutDocumentProtectFromChanges(name, password, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookPostWorkbookSplit(name, format, from, to, horizontalResolution, verticalResolution, folder);
Assert.IsInstanceOf<SplitResultResponse>(response, "response is SplitResultResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorkbookDeleteUnprotectDocument(name, protection, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
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);
// 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;
UpdateDataFile(instance,TEMPFOLDER , BOOK1);
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);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsAutoFilterPutWorksheetDynamicFilter(name, sheetName, range, fieldIndex, dynamicFilterType, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
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);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsPutAddNewWorksheet(name, sheetName, position, sheettype, folder);
Assert.IsInstanceOf<WorksheetsResponse>(response, "response is WorksheetsResponse");
Assert.AreEqual(response.Code, 201);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsAutoFilterPutWorksheetFilter(name, sheetName, range, fieldIndex, criteria, matchBlanks, refresh, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsGetWorksheetCalculateFormula(name, sheetName, formula, folder);
Assert.IsInstanceOf<SingleValueResponse>(response, "response is SingleValueResponse");
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsGetWorksheet(name, sheetName, format, verticalResolution, horizontalResolution, null,null,folder);
Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream");
// 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;
UpdateDataFile(instance,folder, 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);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
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);
// 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;
UpdateDataFile(instance,TEMPFOLDER, BOOK1);
var response = instance.CellsAutoFilterDeleteWorksheetFilter(name, sheetName, fieldIndex, criteria, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsDeleteWorksheetBackground(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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;
UpdateDataFile(instance,folder, name);
var response = instance.CellsWorksheetsDeleteWorksheetComments(name, sheetName, folder);
Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
// 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();