Utilize Sheet.SheetId property of OpenXml using Aspose.Cells
Possible Usage Scenarios
Sheet.SheetId property is found inside the DocumentFormat.OpenXml.Spreadsheet namespace and is part of OpenXml. You can see this property and its value inside workbook.xml as shown in the following screenshot. Aspose.Cells provides the equivalent property as Worksheet.TabId.
Utilize Sheet.SheetId property of OpenXml using Aspose.Cells
The following sample code loads the sample Excel file, reads its Sheet or Tab Id, then it assigns it new Tab Id and saves it as output Excel file. Please also see the console output of the code given below for a reference.
Sample Code
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
//Load source Excel file | |
Workbook wb = new Workbook("sampleSheetId.xlsx"); | |
//Access first worksheet | |
Worksheet ws = wb.getWorksheets().get(0); | |
//Print its Sheet or Tab Id on console | |
System.out.println("Sheet or Tab Id: " + ws.getTabId()); | |
//Change Sheet or Tab Id | |
ws.setTabId(358); | |
//Save the workbook | |
wb.save("outputSheetId.xlsx"); |
Console Output
Sheet or Tab Id: 1297