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.