Attempting to follow along with Practice 1 of the module Excel and Data Tables. Got so far and needed to fall back to looking at the solution. The text for the solution is
I get to the last step in the solution which is using a Write Cell activity to update an existing Excel workbook/sheet. I am presented with an error:
Argument ‘Text’: Cannot implicitly convert type ‘double’ to ‘string’
Is there no way to tell the cell I’m writing general or a specific type of data?
To clear past this error, I added .ToString() on the sum. Fine. Not what I want, but whatever it takes to clear this practice.
I run the sequence and after the window minimizes, brings up Excel and then closes it, I’m presented with the final issue to deal with. Excel is in use. I have another instance of Excel (another worksheet) open, I close that. Same error. I restart Studio Pro. Same error. I completely reboot the machine, start Studio Pro, reload the project. Same error.
After this, I loaded up ProcessExplorer and fed it the file in question. It returned no matches for processes with the file already in use.
I’m really starting to not like this whole business of RPA…