Give details about excel activity

[Bg_bot (Bot)]

Hii all
Give details about excel activity and workbook activities. Please give suggestions
Thank you

[Krishna_Raj]

@Bg_bot

Activities - About the Excel activity package

check this document its give details about excel activities

Difference between Excel and Workbook activities

Hey @richarddenton Adding some more points To use “Excel Application Scope” , Excel should be Install on the system. To use Excel services even Excel is not installed then you can use "Workbook related separate activities. And the other things is with Excel Activities you will not be able to access the chart and diagram realted data with Excel Related activities, You will get an error. For more info: https://forum.uipath.com/t/excel-file-with-chart-sheet-as-first-sheet-except…

[ashokkarale]

@Bg_bot,

In UiPath, Excel activities and Workbook activities are two different sets of actions designed to interact with Excel files. While both serve the purpose of working with Excel, they differ in how they interact with the file and whether they require Microsoft Excel to be installed.

1. Excel Activities

These activities are part of the UiPath.Excel.Activities package and require Microsoft Excel to be installed on the machine where the automation is running.

• Excel Application Scope: This is a container where all activities inside it interact with a specified Excel file. It launches Excel in the background, providing more powerful features, including support for macros and formatted data.
• Common Excel Activities:
  • Read Range: Reads a specified range from an Excel sheet or the entire sheet.
  • Write Range: Writes data from a DataTable to a specified range in an Excel sheet.
  • Read Cell/Write Cell: Reads or writes a single cell value.
  • Append Range: Appends data to the next available row in a sheet.
  • Sort Range: Sorts the data in the specified range.
  • Filter Table: Filters data within an Excel table based on specific conditions.
  • Get Workbook Sheets: Retrieves all the sheet names in the workbook.
  • Execute Macro: Executes a macro present in the Excel file.

Since these activities use the Excel application, they are slower but support Excel features like formatting, charts, and formulas.

2. Workbook Activities

These activities belong to the UiPath.System.Activities package and do not require Microsoft Excel to be installed. Instead, they work directly with the Excel file by interacting with the .xlsx file format.

• Common Workbook Activities:
  • Read Range (Workbook): Reads a specified range from an Excel workbook (without opening Excel).
  • Write Range (Workbook): Writes data to an Excel workbook without opening the Excel application.
  • Read Cell/Write Cell (Workbook): Reads or writes data from/to a specific cell in a workbook.
  • Append Range (Workbook): Appends data to the next available row in a workbook.

Workbook activities are faster and more lightweight, but they do not support advanced Excel features like charts or macros. They are ideal when Excel features are not necessary, and the file processing is the main concern.

Key Differences:

• Excel Activities:
  • Require Excel to be installed.
  • Support advanced Excel features (e.g., macros, charts, formatting).
  • Slower but more feature-rich.
• Workbook Activities:
  • Do not require Excel to be installed.
  • Limited to basic Excel operations (e.g., read/write cells, ranges).
  • Faster and more lightweight.

Use Excel activities if your automation needs to work with advanced Excel features; use Workbook activities if speed and basic operations are your focus.

LLM Helped me to write this but it’s verified by me.

Thanks,
Ashok