English
Summary
This package provides activities to automate Excel using OLEDB
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.
Documentation
Support
UiPath Community SupportSimilar Listings
