MarketplaceListingsCustom ActivityHexaware - Excel Activities

Hexaware - Excel Activities

Bronze Certified

Custom Activity

0 reviews

438

Hexaware - Excel Activities

Bronze Certified

Custom Activity

0 reviews

438


Summary

This component contains all activities required for Excel

carouselImage0

Overview

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.

Benefits


Published: 18 Nov 2020 | Updated: 18 Dec 2020

Trusted Source


License

MIT


Code Language

Visual Basic


Runtime

.NET Framework


Tags

autofit
clear
delete
excel
excel application
formula
horizontal align
merged data
row
used range
vertical align
workbook
worksheet
wrap text

Compatibility

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


Dependencies

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


Documentation


Similar Listings