I have Google sheets I want to read and paste data from xlsx
Without uipath.gsuite.activities
Is it possible? @Palaniyappan or any other please help me on this
Thanks
Ashwin.S
I have Google sheets I want to read and paste data from xlsx
Without uipath.gsuite.activities
Is it possible? @Palaniyappan or any other please help me on this
Thanks
Ashwin.S
Hi
Yeah it is possible with the below set of activities
https://docs.uipath.com/activities/docs/google-sheets
Cheers @AshwinS2
Hi,
How about the following steps?
Open your google sheet
Click File - Download - Microsoft Excel(.xlsx) using Click activity, then save the file to your machine.
We can handle it easily using excel activties such as ReadRange,Write Range etc.
Regards,
Hi @Yoichi
Shouldn’t download the Google sheets
When Launching the Google sheets need to do manipulation
Thanks
Ashwin.S
Ofcourse it will
You can first read the data from excel using normal excel activities and get the output as datatable
That datatable can be passed as input to write range in GSUITE package
It’s as simple as that
Cheers @AshwinS2
Hi,
Alright, how about send hotkey Ctrl+a - Ctrl-c to your google sheet, then send Ctrl+v to youe excel sheet?
Regards,
Please give me your contact number
Need to talk to you
Thanks
Ashwin.S