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 provee algunos métodos de sobrecarga Range.Copy para copiar el rango. Y Range.CopyStyle para copiar solo el estilo del rango; Range.CopyData para copiar solo el valor del 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.Worksheets; | |
// Get the first worksheet in the worksheets collection. | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Create a range of cells. | |
Range sourceRange = worksheet.Cells.CreateRange("A1", "A2"); | |
// Input some data with some formattings into | |
// A few cells in the range. | |
sourceRange[0, 0].PutValue("Test"); | |
sourceRange[1, 0].PutValue("123"); | |
// Create target range of cells. | |
Range targetRange = worksheet.Cells.CreateRange("B1", "B2"); | |
// Copy source range to target range in the same workhseet | |
targetRange.Copy(sourceRange); | |
// Create target range of cells. | |
workbook.Worksheets.Add(); | |
worksheet = workbook.Worksheets[1]; | |
targetRange = worksheet.Cells.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.Worksheets[0]; | |
targetRange = worksheet.Cells.CreateRange("A1", "A2"); | |
// Copy source range to target range in another workbook | |
targetRange.Copy(sourceRange); |
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.Worksheets; | |
// Get the first worksheet in the worksheets collection. | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Create a range of cells. | |
Range sourceRange = worksheet.Cells.CreateRange("A1", "A2"); | |
// Input some data with some formattings into | |
// A few cells in the range. | |
sourceRange[0, 0].PutValue("Test"); | |
sourceRange[1, 0].PutValue("123"); | |
// Create target range of cells. | |
Range targetRange = worksheet.Cells.CreateRange("B1", "B2"); | |
// Init paste options. | |
PasteOptions options = new PasteOptions(); | |
// Set paste type. | |
options.PasteType = PasteType.ValuesAndFormats; | |
options.SkipBlanks = 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.Worksheets; | |
// Get the first worksheet in the worksheets collection. | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Create a range of cells. | |
Range sourceRange = worksheet.Cells.CreateRange("A1", "A2"); | |
// Input some data with some formattings into | |
// A few cells in the range. | |
sourceRange[0, 0].PutValue("Test"); | |
sourceRange[1, 0].PutValue("123"); | |
// Create target range of cells. | |
Range targetRange = worksheet.Cells.CreateRange("B1", "B2"); | |
// Copy the data of source range to target range | |
targetRange.CopyData(sourceRange); |