Get form data from Word and submit webform

#1

Hi,
I am trying my first robot and looking for solutions to copy form data from Word docx and enter it into our site to submit a form.

How do I extract form contents from word and use them in my site.

Form
Form1366×728 73.2 KB

For eg: Form fields like Name, Position, Department, Manager etc

#2

Hi @uitestuser1 and welcome.

one approach would be to use RPA.Word.Application:

*** Settings ***
Documentation   Get Text From Word.
Library    RPA.Word.Application

*** Tasks ***
Get Text From Word
    Open Application
    Open File    <path-to-word-file>
    ${text}=    Get All Texts
    Quit Application

Now you can analyze the raw text and generate the related regex to extract the needed values.

Here’s the link to the library docs (with further examples):

1 Like
#3

@RoboHeart - Thank you so much. But, I will also need to take the form data where user inputs using checkbox.
Eg:
Lunch account required?
☒ Yes
☐ No

How can I take these from the raw text using regex as it changes as per what the user has selected. Please let me know.

#4

To be honest, I never tried this before with rpa-framework.

If Word is declaring it like a control you might get it with RPA.Desktop:

or RPA.Desktop.Windows:

#5

@RoboHeart Thanks much. I will check on it.