Update Excel Documents via C++

Modify Microsoft Excel XLSX, XLS files within C++ based applications without installing Microsoft Office^®.

It’s common for organization to update their data, stored in excel files such as students data, patients records and warehouse items list etc via company software. Aspose.Total for C++ API provides the functionality of modifying the spreadsheets using the software. Programmers can enhance the software with the modification capabilities by just writing few lines of API code. Aspose.Cells for C++ API that is part of Aspose.Total for C++ package makes this modification process easy. Below is the process of updating the Excel document.

Update Excel Documents using C++

Using Aspose.Cells for C++ API, load the source document using CreateIWorkbook . Access the Worksheet using GetIWorksheets()->GetObjectByIndex(0) and required cell using GetICells()->GetObjectByIndex. By using the PutValue method, modify the content in the accessed cell. Lastly invoke the save() method to save the document.

C++ Code - Update Excel Documents

	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);