Why do I get an error when calling the SetCellValue method and using a MicrosoftExcel Connector?
In Pega Robot Studio, when you use the SetCellValue method and the MicrosoftExcel Connector to work with a Microsoft Excel spreadsheet, you get the following error message:
Operation is not allowed while Microsoft Excel is in the 'Edit Mode'.
Make sure that the cell you are calling is valid. For example; Excel spreadsheets start at row 1 instead of row zero, so the first valid cell is A1, instead of A0.
Updated on January 10, 2020