Aralıkları Ekle

Giriş

Excel’de bir aralığı seçebilir, ardından sağa veya aşağıya diğer verileri kaydırarak bir aralık ekleyebilirsiniz.

Aspose.Cells for Python via .NET, bir aralık eklemek için Cells.insert_range yöntemi sağlar.

Aspose.Cells ile aşağıdaki kodları kullanarak bir aralık ekleyin ve hücreleri sağa kaydırın:

+from aspose.cells import CellArea, ShiftType, Workbook
+#  Instantiate a new Workbook.
+workbook = Workbook()
+#  Get all the worksheets in the book.
+worksheets = workbook.worksheets
+#  Get the first worksheet in the worksheets collection.
+worksheet = workbook.worksheets[0]
+cells = worksheet.cells
+#  Create a range of cells.
+sourceRange = cells.create_range("A1", "A2")
+startRow = sourceRange.first_row
+startCol = sourceRange.first_column
+#  Input some data with some formattings into
+#  A few cells in the range.
+cells.get(startRow, startCol).put_value("Test")
+cells.get(startRow + 1, startCol).put_value("123")
+ca = CellArea.create_cell_area("A1", "A2")
+worksheet.cells.insert_range(ca, ShiftType.RIGHT)
+print(worksheet.cells.get("B1").string_value == "Test")

Aspose.Cells ile aşağıdaki kodları kullanarak bir aralık ekleyin ve hücreleri aşağı kaydırın:

+from aspose.cells import CellArea, ShiftType, Workbook
+#  Instantiate a new Workbook.
+workbook = Workbook()
+#  Get all the worksheets in the book.
+worksheets = workbook.worksheets
+#  Get the first worksheet in the worksheets collection.
+worksheet = workbook.worksheets[0]
+cells = worksheet.cells
+#  Create a range of cells.
+sourceRange = cells.create_range("A1", "A2")
+startRow = sourceRange.first_row
+startCol = sourceRange.first_column
+#  Input some data with some formattings into
+#  A few cells in the range.
+cells.get(startRow, startCol).put_value("Test")
+cells.get(startRow + 1, startCol).put_value("123")
+ca = CellArea.create_cell_area("A1", "A2")
+worksheet.cells.insert_range(ca, ShiftType.DOWN)
+print(worksheet.cells.get("A3").string_value == "Test")