get Table data in to Collection form MS word Document

[NaveenG]

Hello All, need to get table data form MS word Document  to Collections.. any ideas how to get it   regards, Naveen

[Mustafa_UlasYig]

Hi NaveenG As far as I can see, table data from MS Word documents are tab separated. So you have 2 options: 1) Copy the table data to Excel worksheet and use Excel VBO action ""Get Worksheet as Collection"". Tab separated values get their own cell in Excel when pasted. 2) See my last comment from this thread: https://portal.blueprism.com/forums/technical-queries/general/how-fetch-data-separated-tab-collection-text-file - where I provide a solution for how to fetch data from a text file, same principles apply here. They are both quite fast actions, but of course it all depends on how much data you have to fetch with regards to which option is faster. Good luck BR, Mustafa

[NaveenG]

Thanks mustafauy for your inputs...

[NaveenG]

Hi mustafauy, as of now im able to take only one cell value form ms word document  table as  of below S.No  name   employeee 1       Naveen 123466 able to take values as  X value:1  Y value: 1 in BO as Ms word... Can we take range of values, i mean can we take total 1st column values form table in ms document by using any BO??

[Mustafa_UlasYig]

Hi Naveen Use Ctrl A + Ctrl C, and if necessary, filter out text before and after your MS Word document's table - and follow either one of the instructions above. BR, Mustafa