Support > Forums > OpenBots Studio > Excel to a Non Web Application

Excel to a Non Web Application

Dustin Krick

  • Reporter
  • Calender Icon March 02,2023 at 1:43 PM

What command would be use to take excel cells and then enter them into a non web application?

I'm struggling to find what to use online.

It would be like a first name (A2), last name (B2) and then entering that data into a field on an application and pressing enter.

I would need repeat that process through the entirety of the excel sheet and if found assign a true value, if not found assign a false value inside excel.

Any help would be appreciated!

This forum has 317 topics, 687 replies, and was last updated 4 months ago by Nataly Alvarado...

Rushabh Arbat

  • Participant
  • Calender Icon March 07,2023 at 6:36 PM

Hi Dustin Krick,

Can you please share the error description, so we can take closer look at.

May be the error occurred due to assign wrong variable or the variable does not assign.

Thanks.

Dustin Krick

  • Participant
  • Calender Icon March 02,2023 at 8:19 PM

I was able to set that up identical to the screen shot that you sent me.

This is the message that I'm receiving: 'Object reference not set to an instance of an object.'

Any thoughts on this?

Rushabh Arbat

  • Participant
  • Calender Icon March 02,2023 at 6:41 PM

Hi Dustin Krick, ​

For the desktop application or non-web application we have desktop commands, and as per your scenario, by using loop you can iterate a data from excel file and set to the particular field in the application by using desktop set text command and then for press enter you can use desktop click command or send advance keystrokes command. let us know if you have any questions.

Thanks

You are not authorized to reply, please click here to login and add your reply to this topic.