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?
We have a custom component for studio but not yet for studioX
Can this be used in studioX
But we can still open the file and do this hot keys
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.
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
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
Hi @Palaniyappan(Thambi) ,
Yes. You can use it in the UiPath StudioX.
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??
Please let me know. And thank you in advance for your continued help
Hi @ldavis ,
Here I have attached a sample for you.
FreezeColsRows.zip (65.0 KB)
@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!
I will send you a sample.
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.
@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
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)
@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,
Hi @ldavis ,
I have attached the samples in StudioX.
@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.