Hi all
I’m trying set the range colour for an Excel file, but to do that I need the Excel to be a DriveItem
For Find Files and Folders, there’s a Site Url - I don’t have a site URL, it’s just a file on my laptop.
How would I go about finding this please?
I’m sure the Excel activities used to be a lot easier to use, in more recent versions of UiPath it seems overly complicated 
Hi @Short
If you are using local Excel file then no need of those things, but if you want to edit the OneDrive Excel files then those are required because first you / your bot has to authenticate with the OneDrive then only you have the access to your excel
If you don’t want all these then you can always make available the excel file into a shared drive and then you can use the Excel activities
Hope this may help you
Thanks,
Srini
If you have the excel available locally then don’t use the Microsoft 365 activities you can use the below activities
As I see there is no Range Color in the modern design activities, so you can use classic activity for that, this will enable the classic activities as well
Hope this may help you
Thanks,
Srini
If the excel is in local please use the excel related activitites…you dragged a office 365 excel activity which is different
To be easy…search excel in the activities panel and then search for activity under excel applications and not under office 365 and excel
Cheers
Hi both
Thanks for the responses 
The only reason I went with that is because I want to set the range colour and that’s the only one with that option.
Do you know if there’s a different way to set the range colour with Excel related activities?
You can use format cells activity which has the option to set the color as well
https://docs.uipath.com/activities/other/latest/productivity/format-range-x
Alternately…if you want set range color only then click on activities → filter icon-> classic…then from
The classic excel activities you can see the set range color as well
Both the activities will hep in setting the color
Hope this helps
Cheers
Hey
I changed to the classic Excel activities but nothing changed, so I’ve gone with your first option - thank you so much!
Ohhh, thank you! One last question sorry, what do I put for this?
How do I create an IReadRangeRef ?
Of course, thanks again!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
