Connect HomeMarketplaceComponentsMastek - Excel - Replace Image

Mastek - Excel - Replace Image

Custom Activity

Custom Activity

Updated: October 26th, 2020

Published: March 23rd, 2020

Downloads: 6

Industry: cross-industry

Language compatibility: Visual Basic

Community Support

Mastek - Excel - Replace Image

Custom Activity

Summary: 

This component can be used in any automation solution to replace an existing image in Excel with another image

It can be used with password protected files.

More information on input:
  • ExcelFilePath (M) - Provide full path of Excel file.
  • ImagePath (M) - Provide full path of image file.
  • Sheetname (M) - Provide Sheet Name on which process is to be executed.
  • Timeout (O) - Process will wait for given time before throwing error/exception. If not passed the default time is 30 seconds (30000 milli seconds).
  • ImageNameinExcel (M) - This will have a name box value, Position: Top left - before formula section and below ribbon in Excel file.
  • ExcelFilePassword (O) - Password to open Excel file.
Note: M stands for mandatory and O stands for Optional.

Details

Benefits

The ability of the component to efficiently replace an existing image in excel with the new one by providing path of the image and also handles password protected files. Structure of the component allows first to validate the incoming arguments and then proceed further so as to avoid unknown exceptions while performing actual task. Various Exceptions, excel and system have been handled. 

Compatibility

Studio version 2020.4.1
Excel 2016

Dependencies

UiPath.Excel.Activities": "2.8.5"
UiPath.Mail.Activities": "1.8.5"
UiPath.System.Activities": "20.4.0"
UiPath.UIAutomation.Activities": "20.4.1"

Resources

- Mastek-Excel-ReplaceImage User Guide.docx

Licensing

By clicking download you agree to the following license.