StudioX - Read Cell

RPA Discussions
1

Hi,

After running activity “Run Spreadsheet Macro” within a “For Each File in Folder” activity, I need to read cell K2 from the macro results. If the value in cell K2 equals “0”, then I want to move file to a different folder, if not equal to “0” then keep file where it is.

Problem is, I can’t figure out how to read cell K2 after the macro finishes. Running macro and moving files works fine. But cant read cel K2 to determine where to move the file. Please see screenshot of my workflow. Error occurs on “Read Cell Value” activity. Please help if you can.

Error ERROR Validation Error Compiler error(s) encountered processing expression “Excel”. Option Strict On disallows implicit conversions from ‘UiPath.Excel.IWorkbookQuickHandle’ to ‘UiPath.Excel.IReadCellRef’. Main.xaml***

Capture2
Capture

2

Hi,

There are some ways to input cell address.

  • Use Excel → Indicate in Excel
  • Use Excel → Custom Input

img20220128-3

  • Use Advanced Editor

img20220128-1
img20220128-1638×552 18.6 KB

Hope this helps you.

Regards,

1 Like