Copiar Rangos de Excel

Introducción

En Excel, puede seleccionar un rango, copiarlo y luego pegarlo con opciones específicas en la misma hoja de cálculo, en otras hojas de cálculo o en otros archivos.

Copiar Rangos Usando Aspose.Cells

Aspose.Cells proporciona algunos métodos de sobrecarga Range.Copy para copiar el rango.

Copiar Rango

Creando dos rangos: el rango de origen, el rango de destino, luego copiando el rango de origen al rango de destino con el método Range.Copy.

Vea el siguiente código:

// 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);
// Create a range of cells.
Range sourceRange = worksheet.getCells().createRange("A1", "A2");
// Input some data with some formats into a few cells in the range.
sourceRange.get(0, 0).putValue("Test");
sourceRange.get(1, 0).putValue("123");
// Create target range of cells.
Range targetRange = worksheet.getCells().createRange("B1", "B2");
// Copy source range to target range in the same workhseet
targetRange.copy(sourceRange);
// Create target range of cells.
workbook.getWorksheets().add();
worksheet = workbook.getWorksheets().get(1);
targetRange = worksheet.getCells().createRange("A1", "A2");
// Copy source range to target range in another workhseet
targetRange.copy(sourceRange);
//Copy to another workbook
Workbook anotherWorkbook = new Workbook();
worksheet = workbook.getWorksheets().get(0);
targetRange = worksheet.getCells().createRange("A1", "A2");
// Copy source range to target range in another workbook
targetRange.copy(sourceRange);
view raw Copy-Range.java hosted with ❤ by GitHub

Pegar Rango Con Opciones

Aspose.Cells admite pegar el rango con un tipo específico.

// 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);
// Create a range of cells.
Range sourceRange = worksheet.getCells().createRange("A1", "A2");
// Input some data with some formats into a few cells in the range.
sourceRange.get(0, 0).putValue("Test");
sourceRange.get(1, 0).putValue("123");
// Create target range of cells.
Range targetRange = worksheet.getCells().createRange("B1", "B2");
// Init paste options.
PasteOptions options = new PasteOptions();
// Set paste type.
options.setPasteType(PasteType.VALUES_AND_FORMATS);
options.setSkipBlanks(true);
// Copy source range to target range
targetRange.copy(sourceRange, options);

Solo copiar datos del rango.

También puedes copiar los datos con el método Range.CopyData como en los siguientes códigos:

// 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);
// Create a range of cells.
Range sourceRange = worksheet.getCells().createRange("A1", "A2");
// Set a few cells in the range.
sourceRange.get(0, 0).putValue("Test");
sourceRange.get(1, 0).putValue("123");
// Create target range of cells.
Range targetRange = worksheet.getCells().createRange("B1", "B2");
//Only copy data the range.
targetRange.CopyData(sourceRange);