I’m reading an Excel spreadsheet using Excel Application Scope with a Read Range and I’ve assigned the data table name as “workinprogress”. I’m also using an assign as follows:
ReqType = row(3).ToString
to pull that cell data. The issue I’m having is that instead of pulling the data from the Excel file I’ve specified, its pulling different data from the same row(3) in a different spreadsheet. I am using that spreadsheet much further up in the workflow. How do I correct this error?