Transfer data from Word to Excel using PAD

[Jy3]

I don't seem to be able to extract the content in the table cell of a word document using Ui Element. Somehow it extracted the cell name, "Data Item "Table Cell".  I am using Version: 2.6.48.21069.

Thanks.

[fraenK]

Did you try this action to get the table?

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/uiautomation#extract...

[Jy3]

Thank you for responding.

Yes, I have tried that. 

I follow the steps in this video https://www.youtube.com/watch?v=IQ_KpBC8fwo&t=1769s but I don't get the red box with Edit.This is what I getFrom the video

[fraenK]

Your screenshot shows that PAD has identified the cell and you have selected it with Ctrl. That's it. The label of the red box can be different and doesn't really matter in this case. The action should output the value of the cell, doesn't it?

[Jy3]

No, it doesn't capture the value of the cell. I get "Table Cell" instead of "12846" in the example below.

[fraenK · Accepted solution]

Works fine for me with the sample documents, I'm getting the "Edit" elements.

Beware that those documents contain form fields ("Edit"). The same thing doesn't work with cells just filled with text ("DataItem"). The later seems to be a limitation of PAD with the Microsoft UI Automation Framework, works fine with UiPath. 

[Jy3]

Noted. Thank you very much.

[fraenK]

For regular table cells you can click on the element, send Pos1 key, hold Shift key while sending End key, then send Ctrl+C. As a alternative 😂

[tanzic]

Or click the upper left corner of the Word cell then send Ctrl+C you can get the content. I found a solution of this question https://youtu.be/q_apiOC7uBI 

[Bartbobbrt]

I tried this but it fails every few times. It doesn't seem to be a robust solution for this problem.

[Bartbobbrt]

Is there a way to convert it? So far the files I'm trying to work on contain only DataItem fields and I can't find a working solution.

[Daniel_Pa]

You could always copy the content from the Word files, although this breaks any formatting and does not recognize tables - thus you would have to use some advanced text gymnastics to get desired values.

Alternatively, you could also convert the files to PDF (there are several possible ways, either online bulk converters, desktop conversion tools, but my preferred way would probably be using some VBA - as this is independent and can be automated). Though the output would be similar and require further processing to find desired values:

Original Word file content:

Could you provide an example of the content you are trying to extract? I'd be glad to help you write up some RegEx to try and get the desired values.

[Bartbobbrt]

Hi Daniel,

Please use the link below for an example file.

https://easyupload.io/yd2822

I made a few bots already but this is breaking my neck.

Thanks

[Daniel_Pa]

Hi Bartbobbrt

Below I've copied the data to an Excel file, from where you should be able to extract the desired values, if the format is consistent.

If the data is not consistent, you might have to to loop through the Excel file to find specific values, and then offset your reading of corresponding values in relation to them.

Let me know, if you need help with this and please suggest what values to extract for me to give a meaningful example.