Type into format

Learn Academy Feedback
, , ,
1

Hi,

I am trying to run an excel automation to copy data and fill into a form. It’s worked well with out inputting data’s. Now I want it to input student data name and all but the conversion is not working. Error is ‘compiler error encountered processing expression ‘dataTable’ option strict on disallows implicit conversion from ‘system.data.datatable’ to system.collections.IEnumeratable.’

image
image1512×2016 1.01 MB

2

You need to use it in for each row
Look like this
Test.xlsx (8.1 KB) Main.xaml (7.5 KB)

2 Likes
3

You have multiple options

either go with foreach row activity and loop through datatable or if you want any specific row value use

datatable.Rows(0)(“FullName”).ToString

here we are referring zeroth index of datatable

4

Can you help with a view here I can seem to read the file when I download

5

Have you look that workflow?
It will give you idea

6

yeah i did sorry but whats the read range activity for ?

7

Hi @Morgan7 ,

Read range activity is used to read an excel and store the excel tabular data to a .net datatype called datatable.

Regards
Roshan

8

Thanks guys i am fine now it worked … :grinning: :wink:

9

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