Excel OLEDB Add-on

Bronze Certified

Custom Activity

4 reviews

3.3k

Excel OLEDB Add-on

Bronze Certified

Custom Activity

4 reviews

3.3k


Summary

This package provides activities to automate Excel using OLEDB

carouselImage0

Overview

This Activity Pack contains the Activities mentioned below:
Scope
  • This activity is a container for all other activities in this package
Read With Filter
  • Select all or particular columns in output datatable
  • Can use conditions with multiple operators to get only filtered data
  • Can retrieve data after sorting on columns
  • Get Top rows from the table
Insert Row
  • Using this activity we can insert a row in the targeted Excel sheet
Update Rows
  • Update your Excel sheet based on the condition or update all rows
Get Sheet Names
  • This activity returns an array of all the Excel sheets in the targeted Excel file
Get Column Names
  • This activity returns an array of all the column in the targeted Excel sheet

Benefits


Published: Mar 1, 2019 | Updated: Dec 18, 2020

Trusted Source


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Tags


Compatibility

2016.2 or > versions of UiPath


Dependencies

Excel 32 bit version Microsoft OLEDB 32 bit drivers for windows. Available on Microsoft webpage.