I have Google sheets I want to read and paste data from xlsx

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

1 Like

Hi

Yeah it is possible with the below set of activities

Cheers @AshwinS2

Hi @Palaniyappan

U mean to say it will support with normal activities

Thanks
Ashwin.S

Hi,

How about the following steps?

  1. Open your google sheet

  2. Click File - Download - Microsoft Excel(.xlsx) using Click activity, then save the file to your machine.

  3. 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,

Hi @Palaniyappan

Please give me your contact number
Need to talk to you
Thanks
Ashwin.S