Workbook.Worksheets
Workbook.Worksheets property
Gets the WorksheetCollection
collection in the spreadsheet.
public WorksheetCollection Worksheets { get; }
Return Value
WorksheetCollection
collection
Examples
// Called: sorter.Sort(workbook.Worksheets[1].Cells, CellArea.CreateCellArea("A2", "C6"));
public void Workbook_Property_Worksheets()
{
Workbook workbook = new Workbook(Constants.sourcePath + "example.xlsx");
DataSorter sorter = workbook.DataSorter;
sorter.AddKey(1, SortOnType.CellColor, SortOrder.Descending, Color.Red);
sorter.Sort(workbook.Worksheets[1].Cells, CellArea.CreateCellArea("A2", "C6"));
Assert.AreEqual("2", workbook.Worksheets[1].Cells["B5"].StringValue);
workbook.Save(Constants.destPath + "example.xlsx");
workbook = new Workbook(Constants.destPath + "example.xlsx");
sorter = workbook.DataSorter;
sorter.AddKey(1, SortOnType.CellColor, SortOrder.Ascending, Color.Red);
sorter.Sort(workbook.Worksheets[1].Cells, CellArea.CreateCellArea("A2", "C6"));
Assert.AreEqual("2", workbook.Worksheets[1].Cells["B2"].StringValue);
workbook.Save(Constants.destPath + "example.xlsx");
}
See Also
- class WorksheetCollection
- class Workbook
- namespace Aspose.Cells
- assembly Aspose.Cells