Kopiera områden i Excel med C++
Contents
[
Hide
]
Introduktion
I Excel kan du markera ett område, kopiera området och sedan klistra in det med specifika alternativ på samma arbetsblad, andra arbetsblad eller andra filer.
Kopiera områden med hjälp av Aspose.Cells
Aspose.Cells tillhandahåller några överlagrade Range.Copy metoder för att kopiera området. Och Range.CopyStyle kopierar endast stil för området; Range.CopyData kopierar endast värdet av området.
Kopiera område
Skapa två områden: källområdet, målområdet, sedan kopiera källområdet till målområdet med Range.Copy-metoden.
Se följande kod:
#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;
int main()
{
Aspose::Cells::Startup();
// Instantiate a new Workbook.
Workbook workbook;
// Get all the worksheets in the book.
WorksheetCollection worksheets = workbook.GetWorksheets();
// Get the first worksheet in the worksheets collection.
Worksheet worksheet = worksheets.Get(0);
// Create a range of cells.
Range sourceRange = worksheet.GetCells().CreateRange(u"A1", u"A2");
// Input some data with some formattings into
// A few cells in the range.
sourceRange.Get(0, 0).PutValue(u"Test");
sourceRange.Get(1, 0).PutValue(u"123");
// Create target range of cells.
Range targetRange = worksheet.GetCells().CreateRange(u"B1", u"B2");
// Copy source range to target range in the same worksheet
targetRange.Copy(sourceRange);
// Create a new worksheet.
worksheets.Add();
worksheet = worksheets.Get(1);
targetRange = worksheet.GetCells().CreateRange(u"A1", u"A2");
// Copy source range to target range in another worksheet
targetRange.Copy(sourceRange);
// Copy to another workbook
Workbook anotherWorkbook;
worksheet = workbook.GetWorksheets().Get(0);
targetRange = worksheet.GetCells().CreateRange(u"A1", u"A2");
// Copy source range to target range in another workbook
targetRange.Copy(sourceRange);
std::cout << "Copy operations completed successfully!" << std::endl;
Aspose::Cells::Cleanup();
}
Klistra in område med alternativ
Aspose.Cells stöder att klistra in området med specifik typ.
#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;
int main()
{
Aspose::Cells::Startup();
// Instantiate a new Workbook.
Workbook workbook;
// Get all the worksheets in the book.
WorksheetCollection worksheets = workbook.GetWorksheets();
// Get the first worksheet in the worksheets collection.
Worksheet worksheet = worksheets.Get(0);
// Create a range of cells.
Range sourceRange = worksheet.GetCells().CreateRange(u"A1", u"A2");
// Input some data with some formattings into A few cells in the range.
sourceRange.Get(0, 0).PutValue(u"Test");
sourceRange.Get(1, 0).PutValue(u"123");
// Create target range of cells.
Range targetRange = worksheet.GetCells().CreateRange(u"B1", u"B2");
// Init paste options.
PasteOptions options;
// Set paste type.
options.SetPasteType(PasteType::ValuesAndFormats);
options.SetSkipBlanks(true);
// Copy source range to target range
targetRange.Copy(sourceRange, options);
std::cout << "Data copied successfully!" << std::endl;
Aspose::Cells::Cleanup();
}
Endast kopiera data för området
Du kan också kopiera data med Range.CopyData-metoden enligt följande koder:
#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;
int main()
{
Aspose::Cells::Startup();
// Instantiate a new Workbook.
Workbook workbook;
// Get all the worksheets in the book.
WorksheetCollection worksheets = workbook.GetWorksheets();
// Get the first worksheet in the worksheets collection.
Worksheet worksheet = worksheets.Get(0);
// Create a range of cells.
Range sourceRange = worksheet.GetCells().CreateRange(u"A1", u"A2");
// Input some data with some formatting into
// A few cells in the range.
sourceRange.Get(0, 0).SetValue(u"Test");
sourceRange.Get(1, 0).SetValue(123);
// Create target range of cells.
Range targetRange = worksheet.GetCells().CreateRange(u"B1", u"B2");
// Copy the data of source range to target range
targetRange.CopyData(sourceRange);
std::cout << "Data copied successfully!" << std::endl;
Aspose::Cells::Cleanup();
}