Last active
September 16, 2018 10:08
-
-
Save aspose-cloud/f21c488545888fe78bbd97e47790246b to your computer and use it in GitHub Desktop.
The GIST contains .NET Examples of Aspose.Cells Cloud APIs.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| The GIST contains .NET Examples of Aspose.Cells Cloud APIs. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| string name = MYDOC; | |
| string sheetName = SHEET3; | |
| int? chartNumber = 0; | |
| string folder = TEMPFOLDER; | |
| string format = "png"; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsChartsGetWorksheetChart(name, sheetName, chartNumber, format, folder); | |
| Assert.IsInstanceOf<System.IO.Stream>(response, "response is System.IO.Stream"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| string name = BOOK1; | |
| string sheetName = SHEET1; | |
| string folder = TEMPFOLDER; | |
| UpdateDataFile(folder, name); | |
| int? firstRow = 0; | |
| int? firstColumn = 0; | |
| int? rowCount = 3; | |
| int? columnCount = 2; | |
| var response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, null, firstRow, firstColumn, rowCount, columnCount, folder); | |
| Assert.IsInstanceOf<SaaSposeResponse>(response, "response is SaaSposeResponse"); | |
| Assert.AreEqual(response.Code, 200); | |
| var rangeName = "A1:B3"; | |
| response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, rangeName, null, null, null, null, folder); | |
| Assert.IsInstanceOf<SaaSposeResponse>(response, "response is SaaSposeResponse"); | |
| Assert.AreEqual(response.Code, 200); | |
| rangeName = "Name_2"; | |
| response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, rangeName, null, null, null, null, folder); | |
| Assert.IsInstanceOf<SaaSposeResponse>(response, "response is SaaSposeResponse"); | |
| Assert.AreEqual(response.Code, 200); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest(); | |
| encryption.Password = "123456"; | |
| encryption.KeyLength = 128; | |
| encryption.EncryptionType = "XOR"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookDeleteDecryptDocument(name, encryption, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookDeleteDocumentUnprotectFromChanges(name, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| WorkbookProtectionRequest protection = new WorkbookProtectionRequest(); | |
| protection.Password = "123"; | |
| protection.ProtectionType = "All"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookDeleteUnprotectDocument(name, protection, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookDeleteWorkbookName(name, "Name_2", folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookDeleteWorkbookNames(name, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string password = null; | |
| bool? isAutoFit = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookGetWorkbook(name, password, isAutoFit, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookGetWorkbookDefaultStyle(name, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string nameName = "Name_2"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookGetWorkbookName(name, nameName, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookGetWorkbookNames(name, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookGetWorkbookNameValue(name, "Name_2", folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookGetWorkbookSettings(name, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookGetWorkbookTextItems(name, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| AutoFitterOptions autoFitterOptions = null; | |
| int? startRow = 1; | |
| int? endRow = 100; | |
| bool? onlyAuto = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPostAutofitWorkbookRows(name, autoFitterOptions, startRow, endRow, onlyAuto, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest(); | |
| encryption.Password = "123456"; | |
| encryption.KeyLength = 128; | |
| encryption.EncryptionType = "XOR"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPostEncryptDocument(name, encryption, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| 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 = null; | |
| UpdateDataFile(null, "Book1.xlsx"); | |
| var response = instance.CellsWorkbookPostImportData(name, data, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| WorkbookProtectionRequest protection = new WorkbookProtectionRequest(); | |
| protection.Password = "123"; | |
| protection.ProtectionType = "All"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPostProtectDocument(name, protection, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| CalculationOptions options = new CalculationOptions(); | |
| options.IgnoreError = true; | |
| bool? ignoreError = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPostWorkbookCalculateFormula(name, options, ignoreError, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string xmlFile = "ReportData.xml"; | |
| string folder = null; | |
| string outPath = null; | |
| UpdateDataFile(folder, name); | |
| UpdateDataFile("", xmlFile); | |
| var response = instance.CellsWorkbookPostWorkbookGetSmartMarkerResult(name, xmlFile, folder, outPath); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| WorkbookSettings settings = new WorkbookSettings(); | |
| settings.AutoCompressPictures = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPostWorkbookSettings(name, settings, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string mergeWith = "myDocument.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| UpdateDataFile("", mergeWith); | |
| var response = instance.CellsWorkbookPostWorkbooksMerge(name, mergeWith, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string format = "png"; | |
| int? from = 1; | |
| int? to = 3; | |
| int? horizontalResolution = 100; | |
| int? verticalResolution = 90; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPostWorkbookSplit(name, format, from, to, horizontalResolution, verticalResolution, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string oldValue = "!22"; | |
| string newValue = "22"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPostWorkbooksTextReplace(name, oldValue, newValue, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string text = "test"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPostWorkbooksTextSearch(name, text, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string format = "xlsx"; | |
| string password = null; | |
| string outPath = null; | |
| UpdateDataFile(null, "Book1.xlsx"); | |
| var response = instance.CellsWorkbookPutConvertWorkbook(format, password, outPath); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| PasswordRequest password = new PasswordRequest(); | |
| password.Password = "123456"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorkbookPutDocumentProtectFromChanges(name, password, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); | |
| string name = "NewBook" + DateTime.Now.ToString("yymmddhhmiss") + ".xlsx"; | |
| string templateFile = "Book1.xlsx"; | |
| string dataFile = "ReportData.xml"; | |
| string folder = null; | |
| UpdateDataFile(folder, templateFile); | |
| UpdateDataFile(folder, dataFile); | |
| var response = instance.CellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, folder + "/" + dataFile, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| ProtectSheetParameter protectParameter = new ProtectSheetParameter(); | |
| protectParameter.Password = "12345"; | |
| protectParameter.ProtectionType = "All"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsDeleteUnprotectWorksheet(name, sheetName, protectParameter, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsDeleteWorksheet(name, sheetName, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsDeleteWorksheetBackground(name, sheetName, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string cellName = "C1"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsDeleteWorksheetComment(name, sheetName, cellName, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsDeleteWorksheetComments(name, sheetName, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| int? row = 1; | |
| int? column = 1; | |
| int? freezedRows = 2; | |
| int? freezedColumns = 2; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsDeleteWorksheetFreezePanes(name, sheetName, row, column, freezedRows, freezedColumns, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsGetNamedRanges(name, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| int? verticalResolution = 100; | |
| int? horizontalResolution = 90; | |
| string format = "png"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsGetWorksheet(name, sheetName, format, verticalResolution, horizontalResolution, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string formula = "=NOW()"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsGetWorksheetCalculateFormula(name, sheetName, formula, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string cellName = "B3"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsGetWorksheetComment(name, sheetName, cellName, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| int? mergedCellIndex = 1; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsGetWorksheetMergedCell(name, sheetName, mergedCellIndex, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsGetWorksheetMergedCells(name, sheetName, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsGetWorksheets(name, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsGetWorksheetTextItems(name, sheetName, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| int? firstColumn = 1; | |
| int? lastColumn = 10; | |
| AutoFitterOptions autoFitterOptions = null; | |
| int? firstRow = 1; | |
| int? lastRow = 19; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostAutofitWorksheetColumns(name, sheetName, firstColumn, lastColumn, autoFitterOptions, firstRow, lastRow, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| int? rowIndex = 1; | |
| int? firstColumn = 1; | |
| int? lastColumn = 10; | |
| AutoFitterOptions autoFitterOptions = new AutoFitterOptions(); | |
| autoFitterOptions.AutoFitMergedCells = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostAutofitWorksheetRow(name, sheetName, rowIndex, firstColumn, lastColumn, autoFitterOptions, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| AutoFitterOptions autoFitterOptions = new AutoFitterOptions(); | |
| autoFitterOptions.AutoFitMergedCells = true; | |
| int? startRow = 1; | |
| int? endRow = 10; | |
| bool? onlyAuto = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostAutofitWorksheetRows(name, sheetName, autoFitterOptions, startRow, endRow, onlyAuto, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "NewCopy.xlsx"; | |
| string sheetName = "Sheet5"; | |
| string sourceSheet = "Sheet6"; | |
| CopyOptions options = new CopyOptions(); | |
| options.ColumnCharacterWidth = true; | |
| string sourceWorkbook = "Book1.xlsx"; | |
| string sourceFolder = null; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| UpdateDataFile(folder, sourceWorkbook); | |
| var response = instance.CellsWorksheetsPostCopyWorksheet(name, sheetName, sourceSheet, options, sourceWorkbook, sourceFolder, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| WorksheetMovingRequest moving = new WorksheetMovingRequest();//SHEET3, "after" | |
| moving.DestinationWorksheet = "Sheet3"; | |
| moving.Position = "after"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostMoveWorksheet(name, sheetName, moving, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string newname = "renametest"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostRenameWorksheet(name, sheetName, newname, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| Worksheet sheet = new Worksheet(); | |
| sheet.Index = 0; | |
| sheet.IsGridlinesVisible = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostUpdateWorksheetProperty(name, sheetName, sheet, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| int? value = 1; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostUpdateWorksheetZoom(name, sheetName, value, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string cellName = "B3"; | |
| Comment comment = new Comment(); | |
| comment.Author = "Roy"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostWorksheetComment(name, sheetName, cellName, comment, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string cellArea = "A1:C10"; | |
| DataSorter dataSorter = new DataSorter(); | |
| dataSorter.CaseSensitive = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostWorksheetRangeSort(name, sheetName, cellArea, dataSorter, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string text = "123456"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostWorksheetTextSearch(name, sheetName, text, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string oldValue = "1234"; | |
| string newValue = "56678"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPostWorsheetTextReplace(name, sheetName, oldValue, newValue, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| int? position = 1; | |
| string sheettype = "VB"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPutAddNewWorksheet(name, sheetName, position, sheettype, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| bool? isVisible = true; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPutChangeVisibilityWorksheet(name, sheetName, isVisible, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| ProtectSheetParameter protectParameter = new ProtectSheetParameter(); | |
| protectParameter.ProtectionType = "All"; | |
| protectParameter.Password = "123"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPutProtectWorksheet(name, sheetName, protectParameter, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPutWorksheetBackground(name, sheetName, File.ReadAllBytes(@"c:\Data\WaterMark.png"), folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| string cellName = "C1"; | |
| Comment comment = new Comment(); | |
| comment.Author = "roy"; | |
| WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest(); | |
| encryption.Password = "123456"; | |
| encryption.KeyLength = 128; | |
| encryption.EncryptionType = "XOR"; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPutWorksheetComment(name, sheetName, cellName, comment, folder); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ | |
| CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration()); | |
| string name = "Book1.xlsx"; | |
| string sheetName = "Sheet1"; | |
| int? row = 1; | |
| int? column = 1; | |
| int? freezedRows = 4; | |
| int? freezedColumns = 5; | |
| string folder = null; | |
| UpdateDataFile(folder, name); | |
| var response = instance.CellsWorksheetsPutWorksheetFreezePanes(name, sheetName, row, column, freezedRows, freezedColumns, folder); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment