Articles → UiPath → Read And Write Data In Excel In Uipath

Read And Write Data In Excel In Uipath






Excel Application Scope




  1. Open the excel file.
  2. Specifies the scope of an excel activity.
  3. Close the excel file when the excel activity is completed.
  4. Creates an excel if the file does not exist.

Example




  1. Drag and drop Excel Application Scope.
  2. Inside the Excel Application Scope, add the Read Range Activity.
  3. Picture showing the excel application scope in UiPath

    Click to Enlarge

  4. Assign the value of the Read Range activity to a DataTable variable in the property window.
  5. Picture showing reading the value and assign it to the datatable variable

    Click to Enlarge




  1. Drag and drop the second Excel Application Scope.
  2. Inside the Excel Application Scope, add the Write Range Activity.
  3. Set the data source to the datatable.
  4. Picture showing the excel application scope for writing data into the excel

    Click to Enlarge



Output


Picture showing the output excel file

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Friday, December 25, 2020

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250