How to cut the specific column in excel and paste it to the starting column of the excel and freeze the only particular column

Help
1

Hi guys.I have excel data.In that I need to cut(ctrl+x)the particular column and have to add that column to the starting column of the excel and also i need to freeze that particular column.can anybody help me with this?

2

Hi @sandhyak9,

I have excel data.In that I need to cut(ctrl+x)the particular column and have to add that column to the starting column of the excel
You can use set ordinal in invoke method activity to achieve this.

image
image791Ă—437 11.4 KB

freeze that particular column
What you want to achieve by freezeing?

Thanks,

3

@Gouda_6 Actually the first column should be freezed in the output file.But I couldn’t understand your suggested method.can you please share xaml file.

4

Hi @sandhyak9,

Please find the sample workflowdataScrapping (1).xaml (5.6 KB)

Thanks,

1 Like
5

Amazing…buddy…!

But a kind suggestion is…the parameter must of value 0 as @sandhyak9 mentioned as starting column…thats all, you are doing great with the remaining,

Cheers…

1 Like
6

Hi @Palaniyappan

Yeah yes forgot to change it.

Thanks

7

@Gouda_6 Thank you so much.It is working now.And also can you help me in freezing the first column?

8

Hi @sandhyak9,

For Freezing you use short cut keys
Step1:use Excel application scope
Step2:use Ctrl+g
Step3:then specify A:A,this Will select entire column
Let me know if you have any queries…

Thanks

1 Like
9

@Gouda_6 Actually send hot keys are not working for excel as i have passed the hot key’ALT+WFC’ to freeze the panes.But this key is perfoming the operation on uipath studio.Can you please give me the detail

10

@sandhyak9
To avoid opening excel, Buddy kindly record a macro in excel in such a way that it freezes the first column and copy that paste in a txt file. Then you can use execute macros activity to execute that macro by just mentioning the macro name alone in input property of execute macros…

But you need to place this activity inside the excel application scope…

Hope this would help you

Cheers…!

11

@PalaniyappanThank you for the nsolution.But,we should not use the macros in our project.

12

Hi @sandhyak9,

what issue your facing with hot key ALT+WFC ?

Thanks,

13

@Gouda_6.Sorry for the late response.Actually i’m passing the sendkeys in different ways like
ALT+WFC
ALT+W+F+C
ALT+W
F
C
And these keys are not working on the excel.If indicate the elements only,It is working.But I couldn’t indicate the elements here.Can you please provide the solution for this with out indicating the elements.

14

Hi @sandhyak9,

Can you use start process activity, and provide your Excel file and use send hot key with Alt+w first and second hot key with FC.

Refer the below workflow for reference

Main.xaml (9.6 KB)