About online excel

Badge +7

Hi team

i have an online excel need to automate, the excel can only edit in web site, can not download and upload.

i need to insert a row to the last row and to see if repeated data exists.

i can not use Recorder to capture the excel, how can i implement using AA2019?


2 replies

Badge +3

If you are working on online excel you can use Office365excel package to automate

to get last row you can use >>>Office 365 Excel: Get row count

>>>Office 365 Excel: Go to cell ........... go to last cell

Badge +7

hi Anurag

the office365 connect command shows parameters as below:

but i just need to setup a url, in manually mode, i type the url to chrome, then the online excel opened! how to use office365 connect the url?