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());
}
