Aralıkları Sil
Contents
[
Hide
]
Giriş
Excel’de bir aralık seçebilir, ardından onu silip diğer verileri sola veya yukarı kaydırabilirsiniz.
Aspose.Cells Kullanarak Aralıkları Sil
Aralıkları Sil ve Hücreleri Sola Kaydır
Aralıkları Sil ve Hücreleri Sola Kaydır
Aşağıdaki kodlarla Aspose.Cells ile bir aralığı silin ve hücreleri sola kaydırın:
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
// Instantiate a new Workbook. | |
Workbook workbook = new Workbook(); | |
// Get all the worksheets in the book. | |
WorksheetCollection worksheets = workbook.getWorksheets(); | |
// Get the first worksheet in the worksheets collection. | |
Worksheet worksheet = workbook.getWorksheets().get(0); | |
// Get cells. | |
Cells cells = worksheet.getCells(); | |
// Set a few cells in the range. | |
cells.get("C2").putValue("C2"); | |
cells.get("C3").putValue("C3"); | |
CellArea ca = CellArea.createCellArea("B2", "B3"); | |
cells.deleteRange(1,1,2,2, ShiftType.LEFT); | |
String b2 = worksheet.getCells().get("B2").getStringValue(); | |
Aralıkları Sil ve Hücreleri Yukarı Kaydır
Aşağıdaki kodlarla Aspose.Cells ile bir aralığı silin ve hücreleri yukarı kaydırın:
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
// Instantiate a new Workbook. | |
Workbook workbook = new Workbook(); | |
// Get all the worksheets in the book. | |
WorksheetCollection worksheets = workbook.getWorksheets(); | |
// Get the first worksheet in the worksheets collection. | |
Worksheet worksheet = workbook.getWorksheets().get(0); | |
// Gets cells. | |
Cells cells = worksheet.getCells(); | |
// Get cells. | |
Cells cells = worksheet.getCells(); | |
// Set a few cells in the range. | |
cells.get("B4").putValue("B4"); | |
cells.get("B5").putValue("B5"); | |
cells.deleteRange(1,1,2,1, ShiftType.UP); |