Connect HomeMarketplaceComponentsHexaware - Excel Activities

Hexaware - Excel Activities

Custom Activity

Custom Activity

Updated: October 2nd, 2020

Published: April 11th, 2020

Downloads: 19

Language compatibility: Visual Basic

Community Support

Hexaware - Excel Activities

Custom Activity

Summary: 

This component contains all activities required for Excel

1. Apply Formula OnSheet - Applies given formula on given sheet, but does not save the sheet, neither closes sheet.
2. Auto Fit Excel Sheet - Auto fit all Excel data as per given range, applies vertical align, horizontal align and wrap text property as per inputs, but does not save the sheet, neither closes sheet.
3. Clear Data From Excel - As per inputs, clears data of entire row from Excel, but does not save the sheet, neither closes sheet.
4. Clear Data From Excel Cell - As per inputs, clears data from Excel for given range of cells, but does not save the sheet, neither closes sheet.
5. Close Macro Based Excel - Closes Excel without saving.
6. Delete Cell Data From Excel - As per inputs, Deletes data for given range of cells from Excel, but does not save the sheet, neither closes sheet.

Details

Benefits

Time saving and useful for doing many more functionalities.
All components parameters have proper annotations.

Compatibility

UiPath 2018. and above. Code is in .NET.

Dependencies

Microsoft.Office.Interop.Excel;
System.Data.OleDb;
System.Runtime.InteropServices;

Resources

- ExcelActivity.docx

Licensing

By clicking download you agree to the following license.