Read After filter

Help Activities
, ,
1

Hi Team,

I am Filtering an excel sheet and i need to get the text (folder Path) in this cell however it’s giving me an error (can’t find the Path column) in read cell activity so any advice?

image

2

@omar_ismail

As you are using excel activities, in use file activity will mention the folder path of the excel…
so again for other excel activities we wont find any separate column for excel path

3

I didn’t get it can you elaborate more?
and what is the solution?

4

Hello @omar_ismail

Sequence:
TryCatch:
Try:
- Open Excel Application Scope to work with the Excel file:
- Excel Application Scope (WorkbookPath: “YourExcelFilePath.xlsx”)
- Excel Read Cell (CellAddress: “A2”, Result: cellValue, SheetName: “Sheet1”)
- Use cellValue for further processing:
- Log Message (Message: “Cell Value: {cellValue}”, LogLevel: Info)
Catch:
- Handle exceptions if the column or cell is not found:
- Log Message (Message: “Error: {Exception.Message}”, LogLevel: Error)

Thanks & Cheers!!!

5

it’s not A2 Cell as i am filtering this Sheet so the cell number could be anything

6

@omar_ismail

Sequence:
TryCatch:
Try:
- Open Excel Application Scope to work with the Excel file:
- Excel Application Scope (WorkbookPath: “YourExcelFilePath.xlsx”)
- Excel Read Range (SheetName: “Sheet1”, Range: “”, Result: dtFilteredData)
- Use dtFilteredData for further processing:
- For Each Row in dtFilteredData
- Assign (assign the row data to variables or process it as needed)
Catch:
- Handle exceptions if there is an issue with reading the filtered data:
- Log Message (Message: “Error: {Exception.Message}”, LogLevel: Error)