English
Summary
This package provides activities to automate Excel using OLEDB
Overview
- This activity is a container for all other activities in this package
- 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
- Using this activity we can insert a row in the targeted Excel sheet
- Update your Excel sheet based on the condition or update all rows
- This activity returns an array of all the Excel sheets in the targeted Excel file
- 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
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
FPT Software - Remove Auto Filter
This component is used to remove the filters from an Excel file
223
Bronze Certified
Autogenerated Password Protected Excel
Package that provides different functionalities for generating protected Excel sheets with randomly generated password.
109
Bronze Certified
BalaReva Excel Activities
This package consists of multiple activities that simplify processes in Excel.
10 reviews
122.3k
Bronze Certified
File Activities
This package contains a variety of activities that will help you easily manage files
2 reviews
2.2k
Bronze Certified
