Hi Team,
I want to perfrom these steps:
Open excel sheet stored at path say “C:\Users\username\Documents\UiPath\excelFolder\abc.xlsm”
Select the required sheet say “Test Data”
Using hot keys clear the sheet except the header
Condition: Excel application scope I cannot use as there are lots of issues coming up due this activity.
If there is any other way to clear the sheet do let me know.
PS : I tried using start process and open application but unable to open the required sheet.
Thanks,
Priyanka Yadav
1 Like
pathrudu
(KLN Sanyasi Pathrudu Chintakayala)
January 15, 2018, 12:15pm
2
Try this it may help you
use start process activity to open your required excel
send hot key F5
TypeInto/settext
A2
send hot key
ctrl+shift+down
send hot key
ctrl+shit+right
send hot key
del
send hot key
ctrl+S
send hot key
alt+F4 or kill process
regards,
Pathrudu Chintakayala
1 Like
@pathrudu ,
Thanks for the reply.
As you are using F5 and A2.
Is there any way I can set the sheet name.
pathrudu
(KLN Sanyasi Pathrudu Chintakayala)
January 15, 2018, 12:25pm
4
sorry i forgot about that requirement.
if you sheet indexes are fixed try sending hot keys to change your sheet ctrl+pagedown and ctrl+pageup
to change your sheets
amitapte2009
(amitapte2009@gmail.com)
January 15, 2018, 12:27pm
5
Simply on desktop, send hotkey Win+R, There give absolute path of excel file… Voila!!! You are there…
1 Like
@pathrudu ,
I think I got the resolution.
Thanks a lot for the quick resolution.
1 Like
pathrudu
(KLN Sanyasi Pathrudu Chintakayala)
January 15, 2018, 12:30pm
8
@priyanka.yadav18 did you got the alternate way if so please share the process
vvaidya
(Vinay Vaidya)
January 15, 2018, 12:31pm
9
This is one more way if you have no other way( but you have)
Try adding below to your xaml file
<AssemblyReference>Microsoft.Office.Interop.Excel</AssemblyReference>
excel_Code.xaml (5.5 KB)
1 Like
pathrudu
(KLN Sanyasi Pathrudu Chintakayala)
January 15, 2018, 12:33pm
10
@vvaidya what activities did you used as i am getting error : Activities could not be loaded as those activities are missing please share me the name so that i will update my studio.
thanks,
pathrudu
pathrudu
(KLN Sanyasi Pathrudu Chintakayala)
January 15, 2018, 12:34pm
12
i cannot update as my version is 2016. cool