Read Range Activity Is Throwing an error

Help
,
8

ok.

  • so reading Excel works (xlsm or xlsx).
  • you are using datatable1.Select("Account="+Account), start reading the range from A2 with add headers therefore you won’t have any “Account” column. You should start reading from A1
  • …which is impossible because you have duplicate columns like “Country Citizenship”
  • there is no Account column
  • For Each is not well configured (the type param should be DataRow and not DataRow())

therefore you can

  • read from A2 without “Add Headers” checked
  • the filter should be in this case datatable1.Select("Column0="+Account)ExcelSelectMethod.xaml (15.0 KB)

The Excel and DataTypes Tutorials are must see.

I have removed the zip. Not sure if that is real data or sample data.

2 Likes