Datatable extraction from base web

[Zishan_Sk]

Hello, Experts I was given the duty of extracting table data from the webpage ( https://baseweb.design/components/data-table/ ), which has several tables on it. Please try and let me know how to obtain first table data using table extraction or any other method as the table extraction wizard is unable to retrieve exact details.

[singh_sumit (Sumit Singh Tariyal)]

Hey @Zishan_Sk are you reffering to this in the below screenshot.

your output would look like this..

simply enable the CV option and check the Scroll option so it will extract the data where the mouse scroll

cheers

[Zishan_Sk]

Hi thanks for your attention. i need to ask which studio version you are using. I am using latest version and the wizard dont
have option to enable CV. and also the data is not captured in expected manner. refer the SS below.

[singh_sumit (Sumit Singh Tariyal)]

Hey @Zishan_Sk UiPath community 2025.0.161

cheers

[Darshan_Sable]

@Zishan_Sk did you updated uiautomation package to latest one?

[Zishan_Sk]

yes i did that. but cv option not appeared.

[Darshan_Sable]

@Zishan_Sk

can you check inside uiautomation package hierarchy UiPath.vision is installed ? if not try installing that..

[Zishan_Sk]

Hi @Darshan_Sable I checked it is available in list.

[Zishan_Sk]

@singh_sumit , Can you copy and place the table metadata and table settings here.

[Darshan_Sable]

Also from project setting can you check if computer vision section has the cv api details

[Anil_G (Anil Gorthi)]

@Zishan_Sk

as far as the structure of the table is concerned only the styling component is defining the rows and no seaprate tag

so each value is extracted as separate row in same column

so a little post processing will extract the full data

so after extraction as there are 8 columns…loop on the extracted table and create the required table with 8 columns and send the data

Extract and then process it

Extract
table settings

"<Table xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' Type='Structured' AddCvHeader='true' IsScrollEnabled='false'>
	<Column xsi:type='DataColumn' ReferenceName='Column0' Name='New column 0'>
		<IsValidName>true</IsValidName>
		<ValidationErrorMessage />
		<IsExtra>false</IsExtra>
		<CanExtractSimilar>false</CanExtractSimilar>
		<Format xsi:type='TextColumnFormat' />
	</Column>
</Table>"

meta data

<extract> <column exact='1' name='Column0' attr='fulltext'> <webctrl tag='div' idx='2' /> <webctrl tag='div' idx='2' /> <webctrl tag='div' idx='1' /> <webctrl tag='div' idx='1' /> <webctrl tag='div' /> <webctrl tag='div' /> <webctrl tag='div' idx='1' /> <webctrl tag='div' idx='1' /> </column> </extract>

for each values
Enumerable.Range(0,Cint(ExtractDataTable.RowCount/8)).ToArray

Add data row
{ExtractDataTable.Rows(currentNumber*8)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+1)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+2)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+3)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+4)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+5)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+6)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+7)(0).ToString}

Flow

output

Hope this helps

cheers

[Zishan_Sk]

Excellent Mr @Anil_G , Thanks for the brief note.