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

Help Something Else
, ,
1

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!!

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

2

Welcome to Community
Could you please share the Excel File

Regards
Chethan P

3

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

4

Ok i will get back with solution

5

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

image
image813×431 14.2 KB

image
image694×486 12.9 KB

Form Question 2.zip (10.2 KB)

Or you can use this also
image

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 :beer:

Regards
Chethan P

6

Thank you so much,it worked

1 Like
7

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

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.