剪切和粘贴单元格
Contents
[
Hide
]
剪切和粘贴单元格
Aspose.Cells for Python via Java提供了剪切和粘贴单元格的功能。为此,API提供了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
output_directory = "Examples/SampleFiles/OutputDirectory/" | |
# Instantiating a Workbook object | |
workbook = Workbook() | |
# Get the first worksheet | |
worksheet = workbook.getWorksheets().get(0) | |
# Set values | |
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") | |
# Cut and paste cells | |
cut = worksheet.getCells().createRange("C:C") | |
worksheet.getCells().insertCutCells(cut, 0, 1, ShiftType.RIGHT) | |
# Save the excel file. | |
workbook.save(output_directory + "CutAndPasteCells.xlsx") |