剪切和粘贴区域
Contents
[
Hide
]
剪切和粘贴单元格
Aspose.Cells 提供了在工作表内部移动和粘贴单元格的能力,使用 Cells 集合的 insertCutCells 方法。 insertCutCells 接受以下参数。
以下示例展示了如何在工作表中剪切和粘贴单元格。
示例代码
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
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
// The path to the documents directory. | |
String dataDir = Utils.getSharedDataDir(CountNumberOfCells.class) + "Worksheets/"; | |
// Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
Worksheet worksheet = workbook.getWorksheets().get(0); | |
worksheet.getCells().get(0, 2).setValue(1); | |
worksheet.getCells().get(1, 2).setValue(2); | |
worksheet.getCells().get(2, 2).setValue(3); | |
worksheet.getCells().get(2, 3).setValue(4); | |
worksheet.getCells().createRange(0, 2, 3, 1).setName("NamedRange"); | |
Range cut = worksheet.getCells().createRange("C:C"); | |
worksheet.getCells().insertCutCells(cut, 0, 1, ShiftType.RIGHT); | |
workbook.save(dataDir + "CutAndPasteCells.xlsx"); |