Find and Replace Text in Excel Spreadsheets using C++

01_Find_and_Replace_Text_in_Excel_Spreadsheets_using_CPP

Find and Replace Text in Excel Spreadsheets using C++

Find-and-replace-text-in-Excel.cpp

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

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

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

// Create an instance of the IReplaceOptions class
intrusive_ptr<IReplaceOptions> replaceOptions = Factory::CreateIReplaceOptions();

// Set case sensitivity option
replaceOptions->SetCaseSensitive(false);

// Set text matching option
replaceOptions->SetMatchEntireCellContents(false);

// Replace text
workbook->Replace(new String("Text to find"), new String("Text replacement"), replaceOptions);

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