🏆 Automation Anywhere Java Package for Excel Automation

🚀 Overview

This Java package extends Automation Anywhere by providing powerful Excel automation actions. It allows bots to manipulate Excel files efficiently, including formatting, data transformation, and row management.

✨ Features

This package includes 8 powerful Excel automation actions:

1️⃣ Convert Excel Column Formats

• Change column formats between Text and Number within a specified range (e.g., Columns A:B).

2️⃣ Convert File Formats

• Convert between:
  ✅ XLS ➝ XLSX
  ✅ XLSX ➝ CSV
  ✅ XLS ➝ CSV
  ✅ CSV ➝ XLSX

3️⃣ Remove Special Characters

• Clean specific columns by removing defined special characters (e.g., -, ", ', /, @, etc.).

4️⃣ Concatenate Columns

• Merge two columns and store the result in another column.

5️⃣ Apply Color Formatting

• Set cell background color within a defined range.

6️⃣ Remove Duplicate Rows

• Delete duplicate rows based on a specific column.

7️⃣ Delete Rows with Blank Cells

• Remove rows where certain columns contain empty cells.

8️⃣ Delete Rows Based on a Condition

• Remove rows where a column contains a specific value (e.g., if Column B contains "yes", delete that row).

🛠 Installation

To use this package in Automation Anywhere:

1. Clone this repository:

   git clone https://github.com/malhaq/Excel-Action-Package.git
   cd Excel-Action-Package