I'm trying to loop through a folder of excel files and read cell "O2" and save as variable. It saves as nothing

Help Studio
, ,
1

I am looping through a folder of excel files. I’ve already used System.IO.Directory.GetFiles(str_folderPath, “*.xlsx”) and am using a variable called currentFile for each seperate excel file. I then need to read cell “O2” from each and save the value as a variable called vendorEmail. I’ve tried read cell workbook but when I write cell it writes nothing. Not sure why it is not reading the value.

2

@mojo001

  1. Is there a value in O2?
  2. Did you try with read range in excel or with changing the format field in workbook activities
  3. Are there more than 1 variables with same name

cheers

3

There is an email address in O2. There is only 1 variable with that name. I’ve tried both workbook activities and excel read range and neither read the email address.

4

@mojo001

Can you share a sample file…or show how you are reading?

are you reading right file and sheet?

cheers

5

image
image1273×502 44.9 KB

This is a screenshot of that part of my process.