Dear users,
im creating a flow to retrieve attachments from emails, save the file and some click funtions to select stuff in the excel. i then want to read the whole sheet. but the read range activity is giving me an error:
Value for a required activity argument ‘Range’ was not supplied.
Activity is valid only inside the “Use Excel File” scope.
as far as i understood if you leave the range blank, it will take the whole sheet/file? and the activity is within a “use excel file” scope.
could it have an impact if the file has multiple sheets?
Thanks
Micky
Hey @Michael_Brumloop can you share the screenshot of implementation and error message?
Regards,
Ajay Mishra
Hey @Ajay_Mishra
sure thing. here you go
both the activity and error are in the screen.
does this help?
gr
micky
First of all you have to take a Excel Application Scope → Use Excel File → Then Read Range.
Pass below value in Range property:
Excel.Sheet("Error")
Note: In Above Syntax Excel is a reference that we have used in Use Excel File Activtiy, Then .Sheet("Error") Error is the example sheet name that we have to read from the input file.
Screenshot for your reference:
Regards,
Ajay Mishra
Hey @Ajay_Mishra , that seemd to have worked as im no longer getting the error. the next error i received was: Read Range: Could not read range A:XFD.
@Michael_Brumloop Can you specify which activity is throwing error now!? And Attach a screenshot!
Regards,
Ajay Mishra
@Ajay_Mishra , my apologies. that would indeed help.
please find below the entire workflow. at the end when the “read range” activity runs, i get the error as discribed in my earlier post
hope this gives you a better understanding
gr
micky
You have a Use Application (UI automation) opening the Excel file then you’re trying to read it with the Use Excel File and Read Range. You can’t do this. You’re trying to open the file twice. Why are you doing UI automation with Excel? You shouldn’t. To read data, you ONLY should have the Use Excel File and Read Range.
@Michael_Brumloop delete Use Application Activity and Excel application scope, only keep my suggested activities in if activity i.e Use Excel and in that a Read Range.
Regards,
Ajay Mishra
1 Like
Thank you for your help till now @Ajay_Mishra @postwick
i changed as per your advise to below:
unfortunately, while not receiving an error, the read range seems to be stuck at execution and nothing the flow does not end.
How many rows are in the Excel file? It can take some time if there is a lot of data.
my apologies for the delay.
it has 5000 lines. this shouldn’t take that long, right?
How many columns? And how long is it taking? Are you reading the file from a network share or locally? What’s the file size?
its around 5000 rows and 19 columns
it has never completed even after 20 min of waiting.
the file is being read from a local drive
and the file is 2,2 mb large