Update Excel Files using C++

update-excel-documents.cpp

StringPtr dirPath = new String("..\\Data\\sourcePath\\");

StringPtr outPath = new String("..\\Data\\OutputPath\\");

StringPtr srcCSV = dirPath->StringAppend(new String(L"srcFile.csv"));

StringPtr updatedCSV = outPath->StringAppend(new String(L"outReadWriteCSV.csv"));

intrusive_ptr<IWorkbook> wb = Factory::CreateIWorkbook(srcCSV);

intrusive_ptr<IWorksheet> ws = wb->GetIWorksheets()->GetObjectByIndex(0);

intrusive_ptr<ICell> cell = ws->GetICells()->GetObjectByIndex(new String("A1"));

StringPtr strVal = cell->GetStringValue();

StringPtr cellValue = new String("Cell Value: ");
Console::WriteLine(cellValue->StringAppend(strVal));

cell = ws->GetICells()->GetObjectByIndex(new String("C4"));

intrusive_ptr<String> strValPtr = new String(strVal);
cell->PutValue(strValPtr);

wb->Save(updatedCSV, SaveFormat_CSV);