public void Cells_WorksheetColumns_Tests() { try { storageService.File.CopyFile(Utils.CloudStorage_Input_Folder + "/cells-sample.xlsx", Utils.CloudStorage_Output_Folder + "/cells-sample.xlsx"); WorksheetColumnsResponse worksheetColumnsResponse = cellsService.WorksheetColumns.ReadWorksheetColumnsInfo(name, "sheet1", Utils.CloudStorage_Output_Folder); WorksheetColumnResponse worksheetColumnResponse = cellsService.WorksheetColumns.SetWorksheetColumnWidth(name, "sheet1", 1, 500, Utils.CloudStorage_Output_Folder); WorksheetColumnResponse worksheetColumnResponse2 = cellsService.WorksheetColumns.ReadWorksheetColumnDataByColumnIndex(name, "sheet1", 1, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.HideWorksheetColumns(name, "sheet1", 0, 5, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.UnhideWorksheetColumns(name, "sheet1", 0, 5, 150, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.GroupWorksheetColumns(name, "sheet1", 0, 3, true, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.UngroupWorksheetColumns(name, "sheet1", 0, 3, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.ClearCellsContents(name, "sheet1", "A1:F5", 1, 1, 5, 5, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.ClearCellsFormats(name, "sheet1", "A1:F5", 1, 1, 5, 5, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.MergeCells(name, "sheet1", 0, 0, 5, 5, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.UnmergeCells(name, "sheet1", 0, 0, 5, 5, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.CopyWorksheetColumns(name, "sheet1", 1, 2, 2, "sheet1", Utils.CloudStorage_Output_Folder); WorksheetRowResponse WorksheetRowResponse = cellsService.WorksheetColumns.ReadWorksheetRowDataByRowIndex(name, "sheet1", 0, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.DeleteWorksheetRow(name, "sheet1", 1, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.InsertNewWorksheetRow(name, "sheet1", 2, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.UpdateWorksheetRow(name, "sheet1", 2, 120, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.HideWorksheetRows(name, "sheet1", 1, 2, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.UnhideWorksheetRows(name, "sheet1", 1, 5, 120, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.GroupWorksheetRows(name, "sheet1", 1, 3, true, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.UngroupWorksheetRows(name, "sheet1", 1, 4, true, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.CopyWorksheetRows(name, "sheet1", 1, 5, 5, "sheet1", Utils.CloudStorage_Output_Folder); CellsResponse cellsResponse = cellsService.WorksheetColumns.GetCellsInfo(name, "sheet1", 1, 10, Utils.CloudStorage_Output_Folder); WorkbookCellResponse workbookCellResponse1 = cellsService.WorksheetColumns.ReadCellDataByCellName(name, "sheet1", "C4", Utils.CloudStorage_Output_Folder); WorksheetRowsResponse worksheetRowsResponse = cellsService.WorksheetColumns.ReadWorksheetRowsInfo(name, "sheet1", Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.SetHtmlstringValueIntoCell(name, "sheet1", "A1", Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.DeleteSeveralWorksheetRows(name, "sheet1", 1, 10, false, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.CopyCellIntoCell(name, "sheet1", "A1", "sheet1", "C4", 5, 3, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.InsertSeveralNewWorksheetRows(name, "sheet1", 1, 10, true, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.SetCellRangeValue(name, "sheet1", "A1", "Aspose", "string", Utils.CloudStorage_Output_Folder); WorkbookCellResponse workbookCellResponse = cellsService.WorksheetColumns.SetCellValue(name, "sheet1", "A1", "Aspose", "string", string.Empty, Utils.CloudStorage_Output_Folder); WorksheetColumnsResponse worksheetColumnsResponse3 = cellsService.WorksheetColumns.InsertWorksheetColumns(name, "sheet1", 1, 5, false, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.DeleteWorksheetColumns(name, "sheet1", 1, 5, false, Utils.CloudStorage_Output_Folder); WorkbookStyleResponse workbookStyleResponse = cellsService.WorksheetColumns.ReadCellStyleInfo(name, "sheet1", "B5", Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.UpdateCellStyle(name, "sheet1", "A1", workbookStyleResponse.Style, Utils.CloudStorage_Output_Folder); cellsService.WorksheetColumns.UpdateCellRangeStyle(name, "sheet1", "A1:F5", workbookStyleResponse.Style, Utils.CloudStorage_Output_Folder); storageService.File.DownloadFile(Utils.CloudStorage_Output_Folder + "/cells-sample.xlsx", Utils.Local_Output_Path + "/cells-sample.xlsx"); } catch (Exception ex) { Assert.Fail(ex.Message); } }
static void Main() { string dataDir = Common.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string input = "sample1.xlsx"; Common.StorageService.File.UploadFile(dataDir + input, input, storage: Common.STORAGE); string sheetName = "Sheet1"; WorksheetRowResponse apiResponse = Common.CellsService.WorksheetColumns.ReadWorksheetRowDataByRowIndex(input, sheetName, 0, Common.FOLDER, storage: Common.STORAGE); Console.WriteLine(" Row: " + apiResponse.Row.link.ToString()); }