MarketplaceListingsCustom ActivityExcel Extension Activities

Excel Extension Activities

Bronze Certified

Custom Activity

3 reviews

89.1k

Excel Extension Activities

Bronze Certified

Custom Activity

3 reviews

89.1k


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:
  1. Excel Extension Scope
  2. Activate Sheet
  3. AutoFill
  4. AutoFit
  5. ChangeFormat
  6. ClearContent
  7. CloseSession
  8. CopyAsPicture
  9. DeleteSheet
  10. FillColor
  11. FindAll
  12. FontStyle
  13. GetActiveCell
  14. GetLastColumn
  15. GetLastRow
  16. GetSheets
  17. GoTo
  18. Insert | Delete
  19. Merge
  20. ReadCell
  21. RefreshAll
  22. SaveWorkbook
  23. SelectRange
  24. SetWidthAndHeight
  25. SetZoom
  26. WriteCell
  27. Rename Sheet

Benefits


Published: 2019-02-27T06:48:16+00:00 | Updated: 2020-12-18T09:35:46+00:00

Trusted Source


License

By clicking download you agree to the following license.


Code Language

Visual Basic


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



Similar Listings