Commenting spreadsheet errors
This script checks all used cells for formula errors like "#DIV/0!" and comments each error:
- open an existing spreadsheet file to check for errors;
- create a loop for columns and nest another loop for rows;
- get each cell (ApiWorksheet/GetRangeByNumber) and check the value for errors;
- comment the cell (ApiRange/AddComment) if an error exists.
This sample is available for the C++ and .Net DocBuilder Frameworks.
Download the sample and get more information on the Builder framework samples page.
Resulting document