MarketplaceListingsCustom ActivityHexaware - Excel Activities

Hexaware - Excel Activities

Bronze Certified

Custom Activity

0 reviews

372

Hexaware - Excel Activities

Bronze Certified

Custom Activity

0 reviews

372


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: 2020-11-18T07:27:32+00:00 | Updated: 2020-12-18T00:00:09+00:00

Trusted Source


License

MIT


Code Language

Visual Basic


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