In the Studio, Modern Excel packages which uses Use Excel file, Excel Process scope. “Select Range” activity is missing. Though it is available in classic excel package. It would be useful to select few cells and perform some operations using Send hot key. It would be great to have.
You can use the activity caleed Format Cell in the you can pass the range of cell and format it.
I wanted to Underline cell. But this is not available in Format Cell. Also thought it would be useful in many other cases which uipath activities can’t cover.
Hey! Welcome back to community!
we can achieve that using read range for that we have to write the query like this…
Hi Thiru, I wanted to select the range so that I can apply send hotkeys, not to read the range.
We can use classic activities in modern as well… The select range will work in both the scenarios…
Hi Thiru, When I use like this, I am getting error “Write Cell: COM object that has been separated from its underlying RCW cannot be used.”. I suspect Select Range inside Use Excel file is creating a separate thread to access excel. This creates conflict and studio throws this error intermittently.
What excel version are we using?
kindly, check this thread and do some research
Are we using write cell from classic?
I had some thing like this inside Use excel file. Had it for 2 times for 2 columns. I got this error 2nd time write cell.
Hi @vasanth8891 we have added it as feedback in our product ideas. It will be addressed on a future release.