MarketplaceListingsCustom ActivityExcel Extension Activities

Excel Extension Activities

Bronze Certified

Custom Activity

3 reviews

83.9k

Excel Extension Activities

Bronze Certified

Custom Activity

3 reviews

83.9k


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: Feb 27, 2019 | Updated: Dec 18, 2020

Trusted Source


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Tags


Compatibility

18.1 and above


Dependencies

Microsoft Office Excel