English
Summary
This component contains all activities required for Excel
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
Support
UiPath Community SupportSimilar Listings
