Retrieve zip file from Sharepoint server and unzip it


#1

Hi,
I have just started working with UiPATH. In my current requirement

  1. I have to connect to sharepoint location using url. User credential is required to open this folder. So as a input I have to provide credential information.
  2. There will be a zip file which I have to copy to some other location where the UiPath robot is running
  3. Extract the file in working folder, which is basically an excel file
  4. Read excel file and need to find some specific cell data [Name from D:6; Salary from F:6]
  5. Copy those data to another excel file to some specific cell [Name to N:10; Salary to AA:10]

Please help me.

Thanks,
Suman