Freeze top row in excel

I’m trying to automate my report by freezing the top rows on all the sheets in my report. Has anyone figured out how to do this using StudioX?

Hi

We have a custom component for studio but not yet for studioX
@balupad14
Can this be used in studioX

But we can still open the file and do this hot keys

Alt-W-F-R

Use Type into where On type into activity, press the + sign and choose text bulder. Once open press again the + sign and you will have all the hot keys there.

Cheers @ldavis

1 Like

give a try on sending a series of hot keys to excel
kindly note hot keys are depending on the language settings from your excel

grafik


so check this when manualy send alt to excel and type in the suggested letters

so will not work on a german system as we would use Alt f p o
Also set some delay between typing the letters
grafik
grafik

Hi @Palaniyappan(Thambi) ,

Yes. You can use it in the UiPath StudioX.

Thank you
Balamurugan.S

1 Like

Super na @balupad14

@ldavis give a try with this component

Cheers

1 Like

Thank you both so much! The keyboard shortcut seems a little difficult since you need to add that into an application (as opposed to an excel file). I cant get it to work.

@balupad14 - Im excited to try out your Excel Packages! For some reason, when I select “Freeze row” or any of your activities, it looks like this below. There arent any options for what rows to freeze. Maybe I am doing something wrong??

image

Please let me know. And thank you in advance for your continued help :slight_smile:

1 Like

Hi @ldavis ,

Here I have attached a sample for you.

FreezeColsRows.zip (65.0 KB)

Regards
Balamurugan.S

@balupad14 - Thank you… is this with Studio or StudioX? I’m only using StudioX and dont have access to “Sequence” or selecting “body” to freeze panes. If you have a chance , please let me know if there is a way to freeze panes in StudioX. Thank you for your help. I’m still very new to UIpath and have no coding knowledge. I appreciate all your help!

Hi @ldavis

I will send you a sample.

Thank you
Balamurugan.S

1 Like

Hello,

Another approach is to use UiAutomation to achieve this. With StudioX 21.8 we have enabled the Excel app card to host UiAutomation activities .

I believe this will be much easier to use since it’s built in and also it’s closely resembles what a human does , clicks buttons.

Regards,
Dragos.

@dragos.suma - Thank you so much! I will try and see if this works, and if I have any problems will let you know. Thanks again :slight_smile:

Hi @ldavis ,

Apologies for the delayed reply. Don’t use the excel scope (From BalaReva) inside the Use Excel File. I tested it.it is working well. here is the sample for you.

ExcelFreezeRow.zip (126.9 KB)

Regards
Balamurugan.S

@balupad14 - Im having problems opening this file. It says “studio” … maybe that is why? I only have access to StudioX. Please let me know if this is for Studio or StudioX?

Thank you for your help,
Laura

image

1 Like

Hi @ldavis ,

I have attached the samples in StudioX.

Thank you
Balamurugan.S

@balupad14 - When I open up the project file you sent, the only thing it shows is this (see below). It doesnt show freeze panes at all within the sample you attached. Could it be that I either dont have a newer version of Studio X or I dont have your correct packages installed on my computer? I downloaded the two excel packages. Im not sure why I cant get this to pull up on my StudioX.

Thank you again for your help.

Laura Davis