Extract data from specific cells from excel and store in google form

[Chitra_Pillai]

I want to extract specific cell value from excel and then store these data in the form created in google forms. All the fields must be extracted i.e. every field value is mandatory. Please help me!!

Attached is the image.
I want to extract the highlighted values and store these value in the google forms

[copy_writes (chethan)]

Welcome to Community
Could you please share the Excel File

Regards
Chethan P

[Chitra_Pillai]

Sample Input_All.xlsx (9.5 KB)
please find the excel file.

[copy_writes (chethan)]

Ok i will get back with solution

[copy_writes (chethan)]

Hear is the solution
I use like this you can use lookup data also or read cell also you can use did you observe the dell name its increment two so use the logic count two and inside for each you can get the data.

hear am use if condition if it null it wont read that data for this you can use LINQ code also for huge of data cell range is between B3:D13

Form Question 2.zip (10.2 KB)

Or you can use this also

Opdata=OpData.AsEnumerable.Where(Function (r) Not String.IsNullOrWhiteSpace(r(2).ToString)).CopyToDataTable

If you get the solution mark it as solution and close the thread

Regards
Chethan P

[Chitra_Pillai]

@copy_writes

pData.AsEnumerable.Where(Function (r) Not String.IsNullOrWhiteSpace(r(2).ToString)).CopyToDataTable

Thank you so much,it worked

[Chitra_Pillai]

i am getting the data, can you please tell me how to put the extracted data to queue. Only the values and not the field name into queue…I am new to uipath so still exploring things