MarketplaceStudioActivityExcel OLEDB Add-on

Create your first automation in just a few minutes.Try Studio Web

Excel OLEDB Add-on

Excel OLEDB Add-on

by Internal Labs

StarStar

4

Activity

Downloads

4.5k

back button
back button
carouselImage0
next button
next button

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)

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.4

Updated

March 23, 2020

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Support

UiPath Community Support

Resources