Why do I get an error when calling the GetCellValue method and using a MicrosoftExcel Connector?
In Robotic Automation Studio, when you use the GetCellValue 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.
Published December 6, 2016 — Updated September 18, 2018