Copy Rows and Columns in Excel using C++

readme.md

You can find detailed information at: Copy Rows and Columns in Excel using C++

Copy_Column.cpp

// Source directory path.
StringPtr srcDir = new String("SourceDirectory\\Excel\\");

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Load the input Excel file
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook(srcDir->StringAppend(new String("Sample1.xlsx")));

// Get the first worksheet
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Copy Column
worksheet->GetICells()->CopyIColumn(worksheet->GetICells(), 0, 6);

// Save the Excel file
workbook->Save(outDir->StringAppend(new String("CopyColumn_out.xlsx")));

Copy_Columns.cpp

// Source directory path.
StringPtr srcDir = new String("SourceDirectory\\Excel\\");

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Load the input Excel file
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook(srcDir->StringAppend(new String("Sample1.xlsx")));

// Get the first worksheet
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Copy Columns
worksheet->GetICells()->CopyIColumns(worksheet->GetICells(), 0, 6, 3);

// Save the Excel file
workbook->Save(outDir->StringAppend(new String("CopyColumns_out.xlsx")));

Copy_Row.cpp

// Source directory path.
StringPtr srcDir = new String("SourceDirectory\\Excel\\");

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Load the input Excel file
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook(srcDir->StringAppend(new String("Sample1.xlsx")));

// Get the first worksheet
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Copy Row
worksheet->GetICells()->CopyIRow(worksheet->GetICells(), 1, 15);

// Save the Excel file
workbook->Save(outDir->StringAppend(new String("CopyRow_out.xlsx")));

Copy_Rows.cpp

// Source directory path.
StringPtr srcDir = new String("SourceDirectory\\Excel\\");

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Load the input Excel file
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook(srcDir->StringAppend(new String("Sample1.xlsx")));

// Get the first worksheet
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Copy Rows
worksheet->GetICells()->CopyIRows(worksheet->GetICells(), 1, 15, 3);

// Save the Excel file
workbook->Save(outDir->StringAppend(new String("CopyRows_out.xlsx")));