Table of Contents

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.


Suggest Edit
Did you find this content helpful?

50% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.