English
Summary
This Activity library allows easy integration with Excel. The Activities will mimic human actions. It also works with large excel files.
Overview
This Activity library allows easy integration with Excel. The Activities will mimic human actions like GoTo cell, FindAll, GoRight, Left Below Above Last Row etc. It works well on large excel files as well as it works on the excel and doesnot hold any data in memory.
This activity can be used to style you excel sheet/Cell : Format Cell(Number, Percentage, Currency etc), Bold, Fill Color, Font Color, Column width, Row Height etc.
Package has following activities:
- Excel Extension Scope
- Activate Sheet
- AutoFill
- AutoFit
- ChangeFormat
- ClearContent
- CloseSession
- CopyAsPicture
- DeleteSheet
- FillColor
- FindAll
- FontStyle
- GetActiveCell
- GetLastColumn
- GetLastRow
- GetSheets
- GoTo
- Insert | Delete
- Merge
- ReadCell
- RefreshAll
- SaveWorkbook
- SelectRange
- SetWidthAndHeight
- SetZoom
- WriteCell
- Rename Sheet
Benefits
Published: 27 Feb 2019 | Updated: 18 Dec 2020
License
By clicking download you agree to the following license.
Code Language
Visual Basic
Runtime
.NET Framework
Tags
activate-sheet
change-excel-format
autofit
changefont
changeformat
clearcontent
copyaspicture
deletesheet
excel
excel-extension
fillcolor
findallcells
fontstyle
getlastcolumn
getlastrow
merge
merge-cells
refreshall
renamesheet
setwidthandheight
setzoom
Compatibility
18.1 and above
Dependencies
Microsoft Office Excel
Documentation
Support
UiPath Community SupportSimilar Listings
