Connect HomeMarketplaceComponentsExcel Extension Activities

Excel Extension Activities

Custom Activity

Excel Extension Activities

Custom Activity

Summary: 

This Activity library allows easy integration with Excel. The Activities will mimic human actions. It also works with large excel files.

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

Details

Benefits

It can work in large Excel files.
It is very easy to use.
Developer with no technical knowledge can use it.
Can easily mimic user actions in Excel.
You can apply style and format to your sheet/cell.

Compatibility

18.1 and above

Dependencies

Microsoft Office Excel

Resources

- Excel_Extended_Activities_User_Guide.pdf

Licensing

By clicking download you agree to the following license.