Hi,
I have a word document as input file which is shown below.
Data in Input File:
FirstName,LastName,Age,Address
Lakshmi,jam,30,Nellore
Sudheer,Zedoi,32,sullurpet
How to extract this data from word to excel?
Hi,
I have a word document as input file which is shown below.
Data in Input File:
FirstName,LastName,Age,Address
Lakshmi,jam,30,Nellore
Sudheer,Zedoi,32,sullurpet
How to extract this data from word to excel?
Hey @vinjam_likitha
Please read the word document data using Word activities
https://docs.uipath.com/activities/docs/word-read-text
Then you can please use Generate Data Table activity to which the above string will be passed as an input & choose column delimiter as comma
.
This will output the string as data table.
Hope that helps.
Thanks
#nK
Hi,
I got the below output for the test.xaml (6.7 KB)xaml.
|FirstName|LastName|Age|Address|
|akshmi|jam|30|Nellore|
|udheer|Zedoi|32|sullurpet|
Laskshmi and sudheer ‘L’ and S are missing
@vinjam_likitha You can do this using below steps
Please find attached workflow
Example.zip (2.6 KB)
Hi @vinjam_likitha ,
Do you have to Extract All the Tables Present in the Word Document?
If so, Could you try the Workflow in the below Post, If the Tables are of Complex type, there may be differences in the Output.