Loop Excel Dataset does not return any value

[rafernandezsan]

Hello.

When executing the command Loop Excel Dataset, the values of each cell is not returned into the variable passed as an argument to the command.
The Loop.CurrentIndex is updated.

How can I retrieve the values from the dataset? In a row structure?

[saucepleez]

Hi, are you still having issues with this functionality?

[rafernandezsan]

Hello. Yes. This is an issue still

On Sat, 30 Nov 2019 at 03:27, saucepleez ***@***.***> wrote: Hi, are you still having issues with this functionality? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#158?email_source=notifications&email_token=ALIT4LNQGHIJOPWUEZ5I6ULQWHFQ5A5CNFSM4JCYRRR2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFPXZLY#issuecomment-559905967>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALIT4LN42OTO57AHG5HWWFTQWHFQ5ANCNFSM4JCYRRRQ> .

-- Rafael Fernández SAP TM Consultant

[saucepleez]

Hello,

I have attached a sample task which shows how to pull values out of Excel. Please see if the attached sample below is working fine for you. Please note, you will need to change the workbook location in the script.

Sample.xlsx

Excel Sample.txt (rename to .xml)

[rafernandezsan]

Hello. I've used the technique as in your example but I was expecting to be able to use the command "*Loop Excel Dataset*" As I have a table dataset and I'd like to read line by line. is it possible to use the Loop Excel Dataset for that?

…

On Tue, Dec 3, 2019 at 4:00 AM saucepleez ***@***.***> wrote: Hello, I have attached a sample task which shows how to pull values out of Excel. Please see if the attached sample below is working fine for you. Please note, you will need to change the workbook location in the script. [image: image] <https://user-images.githubusercontent.com/5113950/70016684-fcbb7f00-154e-11ea-9cbe-5dc14952404a.png> Sample.xlsx <https://github.com/saucepleez/taskt/files/3914284/Sample.xlsx> Excel Sample.txt <https://github.com/saucepleez/taskt/files/3914287/Excel.Sample.txt> (rename to .xml) — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#158?email_source=notifications&email_token=ALIT4LLRSGJDTTCNWPNXTHLQWXDVVA5CNFSM4JCYRRR2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFX5GTA#issuecomment-560976716>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALIT4LOXLNOFFDA3IPJAW5DQWXDVVANCNFSM4JCYRRRQ> .

-- Rafael Fernández SAP TM Consultant

[saucepleez]

@rafernandezsan I made a few changes to the Excel Dataset command and I have added a sample for looping the Excel dataset programatically which demonstrates how you can retrieve the values.