Posted: 7 Aug 2018 8:34 EDT Last activity: 9 Aug 2018 8:56 EDT
Operation is not allowed while Microsoft Excel is in the 'Edit Mode' how to resolve this issue?
I am trying to copy data from one excel, paste those data to the lookup table and finally from this lookup table i want to paste this to the another excel file and the end i am running a macro. However when I launch mu automation i recieve "Operation is not allowed while Microsoft Excel is in the 'Edit Mode'." this error message points to "export data" part thus i think that something is wrong there.
In my experience, this issue appears when you are accessing an invalid cell. For example, if you call GetCellValue on cell A, it will produce this error. If you use A1 as the value, it will work. From your screenshot, you may have some extra characters after A6 that might be the problem. Incidentally, the lookupTable and the proxy in your screenshot are not required as ExportData returns a DataTable you can pass directly to the ImportData method of the other connector (assuming you aren't doing something with the dataTable in between).