# \#data-massaging **URL:** https://community.automationedge.com/tag/data-massaging/87.md [Latest](https://community.automationedge.com/latest.md) · [Categories](https://community.automationedge.com/categories.md) · [Tags](https://community.automationedge.com/tags.md) --- ## [Keep Cell Highlight as it is from Excel Input to new dynamic Excel file](https://community.automationedge.com/t/keep-cell-highlight-as-it-is-from-excel-input-to-new-dynamic-excel-file/10634)
**Author:** [@SuyogMorankar](https://community.automationedge.com/u/SuyogMorankar)\ **Replies:** 2\ **Last updated:** [September 12, 2023, 9:46am UTC](https://community.automationedge.com/t/keep-cell-highlight-as-it-is-from-excel-input-to-new-dynamic-excel-file/10634 "2023-09-12T09:46:21Z")
Hey AE community, I have an excel file having some highlighted cells (Indicating Invalid Data), I want to generate row-wise new files from previous file having the same cells highlighted dynamically. Can anyone guide me… --- ## [Excel Bot to Read Timesheet Emails](https://community.automationedge.com/t/excel-bot-to-read-timesheet-emails/10301)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 30, 2023, 11:56am UTC](https://community.automationedge.com/t/excel-bot-to-read-timesheet-emails/10301 "2023-07-30T11:56:04Z")
This video showcases an AutomationEdge RPA Bot | Excel Bot and send Mail. In this video, we will send a Salary Statement Mail. The Bor or workflow sends an email with the Mail Plugin step. ========== The … --- ## [Excel Bot and send Mail](https://community.automationedge.com/t/excel-bot-and-send-mail/10294)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 28, 2023, 6:28pm UTC](https://community.automationedge.com/t/excel-bot-and-send-mail/10294 "2023-07-28T18:28:50Z")
This video showcases an AutomationEdge RPA Bot | Excel Bot and send Mail. In this video, we will send a Salary Statement Mail. The Bor or workflow sends an email with the Mail Plugin step. The bot uses the following Aut… --- ## [Excel Bot for Salary Transfer to Bank](https://community.automationedge.com/t/excel-bot-for-salary-transfer-to-bank/10293)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 28, 2023, 6:19pm UTC](https://community.automationedge.com/t/excel-bot-for-salary-transfer-to-bank/10293 "2023-07-28T18:19:47Z")
This video showcases an AutomationEdge RPA Bot | Excel Bot for Salary Transfer to Bank. The bot converts an excel file to an XML file for digital Salary Transfer to a bank. The bot uses the following AutomationEdge Plug… --- ## [Salary Processing and Reports based on an Excel template file](https://community.automationedge.com/t/salary-processing-and-reports-based-on-an-excel-template-file/10308)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 31, 2023, 3:55am UTC](https://community.automationedge.com/t/salary-processing-and-reports-based-on-an-excel-template-file/10308 "2023-07-31T03:55:00Z")
In this post I am sharing a video for - Salary Processing and Reports based on an Excel template file. This video showcases an AutomationEdge RPA Bot | Excel Bot for Salary Processing and Reports based on an Excel templa… --- ## [AutomationEdge RPA Bot | Excel Bot | Salary Processing with formatted output based on a template](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-salary-processing-with-formatted-output-based-on-a-template/10306)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 30, 2023, 12:30pm UTC](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-salary-processing-with-formatted-output-based-on-a-template/10306 "2023-07-30T12:30:15Z")
This video showcases an AutomationEdge RPA Bot | Excel Bot | Salary Processing with formatted output based on a template. The output Salary file is formatted based on an input Excel template file. ========… --- ## [AutomationEdge RPA Bot | Excel Bot to Combine Timesheets](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-to-combine-timesheets/10305)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 30, 2023, 12:24pm UTC](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-to-combine-timesheets/10305 "2023-07-30T12:24:30Z")
This video showcases an AutomationEdge RPA Bot | Excel Bot to Combine Timesheets. We will combine timesheets from different geographical regions for salary processing. ================================= T… --- ## [Manage a Long-Running AutomationEdge RPA Bot | Excel Bot](https://community.automationedge.com/t/manage-a-long-running-automationedge-rpa-bot-excel-bot/10304)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 30, 2023, 12:21pm UTC](https://community.automationedge.com/t/manage-a-long-running-automationedge-rpa-bot-excel-bot/10304 "2023-07-30T12:21:19Z")
This video showcases how to Manage a Long-Running AutomationEdge RPA Bot | Excel Bot. ================= AutomationEdge displays: New, Execution Started, Complete, Failure and Diverted states. In long-run… --- ## [AutomationEdge RPA Bot for Employee Data transformation](https://community.automationedge.com/t/automationedge-rpa-bot-for-employee-data-transformation/10303)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 30, 2023, 12:10pm UTC](https://community.automationedge.com/t/automationedge-rpa-bot-for-employee-data-transformation/10303 "2023-07-30T12:10:17Z")
This video showcases an AutomationEdge Bot for Employee Data Transformation. https://www.youtube.com/watch?v=7NLg0krRYSM ================= We will create an AutomationEdge bot to transform employee data with string tr… --- ## [Bot for Pay Slip Distribution with Mail Merge](https://community.automationedge.com/t/bot-for-pay-slip-distribution-with-mail-merge/10260)
**Author:** [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\ **Replies:** 0\ **Last updated:** [July 27, 2023, 5:04am UTC](https://community.automationedge.com/t/bot-for-pay-slip-distribution-with-mail-merge/10260 "2023-07-27T05:04:51Z")
This video showcases an AutomationEdge RPA Bot | Excel Bot for Pay Slip Distribution using MS Word Mail Merge and Mail steps. The bot reads employee salary details from an excel file. It then uses a Mail Merge step to c… --- ## [AutomationEdge RPA Bot | Excel Bot for Data Massaging](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging/10207)
**Author:** [@nidhi.saraiya](https://community.automationedge.com/u/nidhi.saraiya)\ **Replies:** 0\ **Last updated:** [July 22, 2023, 11:58am UTC](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging/10207 "2023-07-22T11:58:16Z")
"This video showcases an AutomationEdge RPA Bot | Excel Bot for Data Massaging on Employee data. The bot performs data massaging to get Employee Count by designation and Sort Employees by Roll No. This RPA bot/workflow…