MarketplaceListingsCustom ActivityHexaware - Excel Activities

Hexaware - Excel Activities

Bronze Certified

Custom Activity

0 reviews

277

Hexaware - Excel Activities

Bronze Certified

Custom Activity

0 reviews

277


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: Nov 18, 2020 | Updated: Dec 18, 2020

Trusted Source


License

MIT


Code Language

Visual Basic


Tags


Compatibility

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


Dependencies

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


Documentation