Split Text to Columns in Excel using C++

01_Split_Text_to_Columns_in_Excel_using_CPP

Split Text to Columns in Excel using C++

Text-To-Column.cpp

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

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

// Path of the output excel file
StringPtr outputFile = outDir->StringAppend(new String("TextToColumns.xlsx"));

// Create an instance of the IWorkbook class
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook();

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

// Add sample data
intrusive_ptr<String> str = new String("John Teal");
worksheet->GetICells()->GetObjectByIndex(new String("A1"))->PutValue(str);
str = new String("Peter Graham");
worksheet->GetICells()->GetObjectByIndex(new String("A2"))->PutValue(str);
str = new String("Brady Cortez");
worksheet->GetICells()->GetObjectByIndex(new String("A3"))->PutValue(str);
str = new String("Mack Nick");
worksheet->GetICells()->GetObjectByIndex(new String("A4"))->PutValue(str);
str = new String("Hsu Lee");
worksheet->GetICells()->GetObjectByIndex(new String("A5"))->PutValue(str);

// Create an instance of the ITxtLoadOptions class
intrusive_ptr<ITxtLoadOptions> options = Factory::CreateITxtLoadOptions();

// Specify the separator for separating the text
options->SetSeparator(' ');

// Split Text to Columns
worksheet->GetICells()->TextToColumns(0, 0, 5, options);

// Save the output excel file
workbook->Save(outputFile);