TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

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