a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

5c9d5821-93f0-48ba-9aca-4e75c6088a22.jpeg

9676a30a-2986-44b4-bb52-4231881a0880.nupkg

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

This package provides activities to automate Excel using OLEDB

Excel OLEDB Add-on