I am working on a wizard that copies data from excel to a website, resulting in the return of a new account number that I need to paste back to the same excel document. Is that possible? When completed, I would have all the original excel data used to create the account and the column following that data would be the new account number.
Solved
RPA - past new value to excel
+5Best answer by JJMedina
Hi
Once you generate the account number you can either:
- Use the recorder clicking on the new account element on the screen. Once done switching click action of the insert menu by Read from Screen. That will allow you to store the value of the account in a $variable$ that you can paste back into the excel spreadsheet in the same row and column (where you are working the rest of the elements of your spreadsheet) to obtain that new account. You can paste it in the subsequent column.
- Use the HTML command Get object value and target the element of the screen where you have the new Account. It will require that you store the element into a $variable$ that you can paste back into the excel spreadsheet in the same row and column (where you are working the rest of the elements of your spreadsheet) to obtain that new account. You can paste it in the subsequent column.
I hope that helps.
Best,
+3- Nintex Employee
- 3 replies
Yes
You can do that using Nintex RPA.
Please follow below two guidelines to do that learn about how to use Excel and HTML DAC
https://help.nintex.com/en-US/kryonrpa/24.4/Content/AdvancedCommands/ExcelCommands/Excel_Commands.htm?tocpath=Studio%7CStudio%20Features%7CDynamic%20Commands%7CExcel%20Commands%7C_____0#_Toc103165065
Hope above helps you to resolve the issue.
Translate
+5Thank you! I do know how to get the html object and how to paste to excel. I just didn’t know how, if possible, to paste the value into the excel document that is being used for extracting data for the wizard.
Translate
- Nintex Employee
- 3 replies
- Answer
Hi
Once you generate the account number you can either:
- Use the recorder clicking on the new account element on the screen. Once done switching click action of the insert menu by Read from Screen. That will allow you to store the value of the account in a $variable$ that you can paste back into the excel spreadsheet in the same row and column (where you are working the rest of the elements of your spreadsheet) to obtain that new account. You can paste it in the subsequent column.
- Use the HTML command Get object value and target the element of the screen where you have the new Account. It will require that you store the element into a $variable$ that you can paste back into the excel spreadsheet in the same row and column (where you are working the rest of the elements of your spreadsheet) to obtain that new account. You can paste it in the subsequent column.
I hope that helps.
Best,
Translate
+5Thank you JJ! I will give them a try. Right now I am using ‘get html object value’ and it is blank.
Do I also need to add a loop or something to make sure the account number is in the right row on the spreadsheet? I am trying hard to learn how to use this software and appreciate your help.
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.