This content has been archived and is no longer being maintained.

Table of Contents

Article

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.

Tags:

Published December 6, 2016 — Updated September 18, 2018


60% found this useful

Have a question? Get answers now.

Visit the Pega Support Community to ask questions, engage in discussions, and help others.