Extraction of table in Word, to be input into Excel as columns

[UIPYH]

I have a number of word documents with 3 tables each where I want to extract information from, after which these information are to be populated into Excel as columns and records. Attached as picture is how the table in Microsoft Word looks like.

Thanks!

[vrdabberu (Varunraj Dabberu)]

Hi @UIPYH

Check out this thread

Extract Data from Word Table to Data table or Excel

refering to the last screenshot following LINQ (taken from your post) Group p By FName=p.Item(“FacilityName”).ToString Into grp=Group Let ra= New Object() {FName, grp.Max(Function® CInt(r(“Beds”).toString.Trim)),grp.Sum(Function® Convert.ToDouble(r(“TotalCost”).toString.Replace("$","").Trim))} Select BedCount.Rows.Add(ra)).CopyToDataTable() and the reported output: FName1,124,2906.32 FName2,120,1859.19 is reasonable and within the expectation (2 Groups, 2 rows, Max, Sums) as it deriveable c…

Regards

[UIPYH]

Hi @vrdabberu , my table is slightly different as the headers are not at the top…

[Sharath_HK (Sharath Keshavamurthy)]

@UIPYH

You can try the below marketplace component

Extract or Update Tables in Word File - RPA Component | UiPath Marketplace |...