Excel OLEDB Add-on

Bronze Certified

Custom Activity

4 reviews

3.8k

Excel OLEDB Add-on

Bronze Certified

Custom Activity

4 reviews

3.8k


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: 01 Mar 2019 | Updated: 18 Dec 2020


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Runtime

.NET Framework


Tags

excel
filter
filter-excel
large-excel
oledb
quick-excel-operation
sort-excel
timeout

Compatibility

2016.2 or > versions of UiPath


Dependencies

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



Similar Listings