How to capture specific field of excel file and save it image file?

Help Activities
, , ,
1

Hello !

I’d like to get some helps for capturing some specific field of excel file.
Is it possible?

  1. Capture screen shot of specific field like below
  1. Save the image to .png file or pdf.

Thank you for your help in advance !!

2

Although there isn’t a direct method available in UiPath Studio (to the best of my knowledge :slight_smile: ) to achieve this, you may try one of the two following ways:

  1. Use Take Screenshot UiPath activity
    You can utilise the Misc options such as Target.Selector and/or Target.ClippingRegion to narrow down the area of screenshot.
  2. Use Excel feature to Copy As Picture
    Build a UI automation to implement this. Although Excel works much better in integrated automation setting, this requirement is not your usual Excel user case.

I hope this helps.
Happy Automation!

3

You might want to research the Screenshot activity in a bit more detail.

It has an option named Clipping Region.

You maybe able to come up with the rectangular area you want to clip based on your screen resolution.

Target.ClippingRegion - Defines the clipping rectangle, in pixels, relative to the UiElement, in the following directions: left, top, right, bottom. It supports both positive and negative numbers.

Also, the Marketplace has a Clipping Component created by UiPath for this purpose. You might want to search market place . But this might help you if your automation is attended.

Hope this helps.

Thanks

4

Hi @Dorothy_lee

You can try Excel sheet to image activity.

image
image1112×653 30.2 KB

Regards

5

Hi @Dorothy_lee

Please refer the xaml below.

Main.xaml (6.7 KB)
project.json (1.5 KB)

Rergards

6

Thanks for your kind reply !!
I’ll try it!

7

Thanks for your kind reply !!
I’ll try it:)

8

Thanks for your helps!