Insertar Rangos

Introducción

En Excel, puedes seleccionar un rango, luego insertar un rango y desplazar otros datos hacia la derecha o hacia abajo.

Insertar Rangos Usando la Librería de Excel Python de Aspose.Cells

Aspose.Cells para Python via .NET proporciona el método Cells.insert_range para insertar un rango.

Cómo Insertar Rangos y Desplazar Celdas a la Derecha

Insertar un rango y desplazar celdas a la derecha como los siguientes códigos con Aspose.Cells:

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")

Cómo insertar rangos y desplazar celdas hacia abajo

Inserte un rango y desplace las celdas hacia abajo como los siguientes códigos con Aspose.Cells:

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")