Select by clic one Excel row

[tpdemontfort (firedog07)]

Hello,
In a customer file in Excel, I want to click to select the line with Name, First name, Street, City of the customer to make his invoice and send it in pdf.

I have already made a Read Range of a specific line to extract that and temporarily I put the data in another Excel file.

But I would like that when I start the execution

• The Excel Customer file opens and waits
• I click on the name cell of a customer
• The execution resumes and takes the customer information: Name, First name, Street, City

After with this information I will fill my invoice and export it in pdf.

Can you help me

Thanks in advance

[Ehab_Sawars]

can you explain more what after you get the row
not sure why you want to open excel rather than use for each row and get whatever you want from the file

[tpdemontfort (firedog07)]

Thank you for your answer.

I have an Excel file with my customer information.
I help a customer, I make him an invoice.
I go to my Excel file where his information is.
And I fill out a file that contains his information Name, First name, Address, City, then the treatment carried out, Windows installation, virus removal, HDD recovery …

I want by UiPath

• Open this Excel info file
• Click on his name in Excel and by UiPath take this information, Name, First name, Address, City
• Add a pop-up with the treatment carried out, Windows installation, virus removal, HDD recovery …
• The amount of the service
• Generate a pdf with all his information and the date

All that remains is to send by email this pdf document generated by UiPath

[tpdemontfort (firedog07)]

Nobody has an idea ?

[Melroy_Dsa]

Hi @tpdemontfort,

Assuming you have the Customer Name, you can simply assign it to a variable and use For Each to find out which row contains that particular Customer Name.
Compare currentRow(“Name”) with CustomerName,
If it matches, store the row as a DataRow or a Dictionary of Key and Pair values, and then use the values to perform other operations.

If you do not have the CustomerName you can maybe have an input dialog box, where you can manually enter the name rather than clicking a cell in the Excel sheet.

Hope this Helps!

[tpdemontfort (firedog07)]

Hi,
In the end and not without difficulty …
I put a Local Trigger which waits for my click on a cell in column A.

In THIS case I select cell A144

I spleet Cell

And set the address of the cells wanted by this row variable

[tpdemontfort (firedog07)]

But to get to the selection it’s not easy

I have to take use application/Browser
And put in the click so that it detects the Excel file

Afterwards I can configure it and take it out of the “Use Application/Browser” area and it keeps the view of the Excel file that it did not see before going through the “Use Application/Browser” step.