Read values from an Excel pivot table

Help Studio
, ,
1

Hi,

I know this may sound like a simple question, but I can’t work it out and really need some help!

I have an excel spreadsheet. On the spreadsheet is a simple single-column pivot table that lists some reference numbers. I need to get the list of numbers from the pivot table and insert that list into an email. I think I know how to do the email part, but I can’t work out how to read the data from the pivot table? Please help! :slightly_smiling_face:

Thanks!

2

@paulparkes

You can use read range activity to read any data

Cheers

3

Hi,

Thanks for your reply. I did try that, but it didn’t show the data, only the cell references, ie. “A127:A141”. Although I’ve been following many tutorials, I’m clearly doing something wrong but I don’t know what.

Thanks