Excel Select Range in Modern Excel Package

[vasanth8891 (Vasanth S)]

Hi Team,
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.

[Sanjit_Pal]

Hey @vasanth8891,

You can use the activity caleed Format Cell in the you can pass the range of cell and format it.

Thanks,
Sanjit

[vasanth8891 (Vasanth S)]

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.

[THIRU_NANI (NaNi)]

Hey! Welcome back to community!

we can achieve that using read range for that we have to write the query like this…

Excel.Sheet("SheetName").Range("A1:Z100")

References:

Regards,
NaNi

[vasanth8891 (Vasanth S)]

Hi Thiru, I wanted to select the range so that I can apply send hotkeys, not to read the range.

[THIRU_NANI (NaNi)]

Hey!

Try this:

We can use classic activities in modern as well… The select range will work in both the scenarios…

Reference:

Output:

Regards,
NaNi

[vasanth8891 (Vasanth S)]

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.

[THIRU_NANI (NaNi)]

@vasanth8891

Write Cell: COM object that has been separated from its underlying RCW cannot be used

Hey!

What excel version are we using?

kindly, check this thread and do some research

Com object has been separated from its underlying RCW

Hey @Palaniyappan I am using Studio Pro 2021.4.4. I need to format cells to date and time and change the textcolor. Both activities are only available within an use excel activity. A manual workaround would be possible but if there is a more reliable alternative, I would like to avoid using it. Also worth noting, there are two use excel activities in my workflow. The error only ever occurs on the second one. Kind regards Adrian

Are we using write cell from classic?

Regards,
NaNi

[vasanth8891 (Vasanth S)]

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.

[Alex_Gherghe (Alexandru Gherghe)]

Hi @vasanth8891 we have added it as feedback in our product ideas. It will be addressed on a future release.