Please see if anything is incorrect here.
This is what I am trying to fetch. 3 rows and 5 columns
Hey read rangeX should be used inside excel process scope
Regards
Hi, why you use double read range activity in your process workflow?
use excel application process activity, use excel unchecked create if not exists checkbox and then read range activity
It is under excel scope and use excel ,Screenshot doesn’t show it. I am using double read range because I am hoping atleaset one of them should work. If I wouldnt be using inside “Use Excel” it should give an error. So that’s not an issue.
Any other solution?
Okay, use Read Range Workbook activity then.
Are you not getting the data?
Or is there any other issue?
One read range should suffice you dont need multiple
Cheers
This is not working. I am doing some actions on that sheet and then I need to pull some columns, therefore it shows error.
yes not getting data. no other issue.
please close your excel first and then run
Close the excel file if it is open
Just to check can you try givign the first cell number instead of leaving blank and try
Cheers
Read range output is in datatable type variable and suppose you need to check this output in message box then use output data table activity and give this output data table output in messsage box
here you use read range output directly in message box that’s why you not getting data in message box
Don’t get confused
- Read range workbook activity (Var_dt)
- output data table activity use read range output (Var_dt) in this
- and in message box give output data table output and check
Just a dumb question, but why are your column headers not on row 1? You have the checkboxes on for header row and visible rows only. Maybe uncheck all, put your data up on the top like normal and filter for what you want from the resulting datatable.
This is an issue
This is downloaded file from internal source. Need to check if I could delete 1-3 rows to bring header on top.
Do you suggest doing that? If done, Would it work?
did that. getting the same blank data table.
Any solution?
I am still stuck on Read Range Activity
1 Like