Sign In
Create your first automation in just a few minutes.Try Studio Web →
Excel OLEDB Add-on
by Internal Labs
4
Activity
4.5k
Summary
Summary
This package provides activities to automate Excel using OLEDB
Overview
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
Features
Features
Get only the data which is required (No need to read entire table and then apply filter - Execution time reduced & memory also will be used less than other approaches) Multiple conditions can be given for Read/Insert/Update operations Suits your needs if you have simple, uniform structured tables It is fast, and it works even on machines where MS Excel is not installed It is really a good way to insert/update data in Excel
Additional Information
Additional Information
Dependencies
Excel 32 bit version Microsoft OLEDB 32 bit drivers for windows. Available on Microsoft webpage.
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
Technical
Version
1.0.4Updated
March 23, 2020Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Support
UiPath Community Support
Resources
Similar Listings
