How can I populate a list from a web site with excel data

Hi!

How can I populate a list on a website (where it can’t be written with TypeInto) from an excel with data to be completed by the client?
Thanks!

@BID,

Read the excel using read range activity then using the below line of code you can convert the required column into a List of string.

Use this list with a For each and type into activity to type the values in the website.

yourDataTable.AsEnumerable().[Select](Function(r) r.Field(Of Object)(column.ColumnName)).ToList()

@sarathi125

Where do i write the code? Sorry, I’m a beginner…

@BID,

Use Excel Application scope to read the excel data
declare a datatable to get the output from read range

then in Assign activity in the right side you can write this code
Left side use a List(of String) variable type.

@sarathi125
I read the range, but I can’t handle the Assign activity.
And the output when reading my range will be “yourDataTable” from the code given by you?

@BID,

Check the xaml, I have included two ways, one is fully commented out, if you want use it.
Sequence1.xaml (14.2 KB)

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