Please Help. Excel, write a line and take a screenshot

Hello Guys,

I Have these four string variables.

Now all i want to do is to open this excel file located within the project files:

The Excel File Looks Like this:

Now All I want to Do is to type these four variables accordingly on the first row like this:

Ant then to take a screenshot of the table with only the first row like this:

Much Appreciated
Hurmet Noka

I think the Take screen shot activity has an added attribute to set the image width and height with reference to the top-left area of the screen. Here is the info from the documentation page:

  • 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.

Based on screen resolution you can arrive at the width and height you want to clip.

In case the Target Clipping Region doesn’t work, you can still use the Screen Resolution to compute the proportionate clipping area of your Excel sheet.

You can compute the screen resolution at runtime as shown in this thread:

I hope this helps.

1 Like

Solved using excel extension activities. Capture Range and Save as Picture.

Thank You

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.