How to invoke Excel data to Terminal and How to udate the Excelsheet


#1

Hi All ,

Please help me on this


#2

Hi Srinu,

It’s a bit hard to tackle such a general question, but as a principle you just need to work through this logically.

Prerequisites are going to be:

  • Once you’ve got UiPath installed, you will also need to install the Terminal Activities (I think Excel is installed by default).
  • There is a bit of messing around to get a terminal going in my experience, you need to try a few of the different options provided by UiPath. I’ve written before about how I have done it - Regarding Issue in connecting mainframe via Aviva Emulator -TN3270

So from here you’ll need to open your excel using those activities, and open a terminal connection using those activities.

Once you’re connecting to terminal, you just need to read out of the excel into string variables what you need, and use the send keys activities to send to the terminal. Then you use the read activities from the terminal and read what you need into a variable, and then use the excel activities to type it where you need it in the excel.


#3

Thanking you David

I’ll try it