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

Help Studio
, , , ,
1

Hello Guys,

I Have these four string variables.
image

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

The Excel File Looks Like this:
image

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

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

PLEASE HELP.
Much Appreciated
Regards
Hurmet Noka

2

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
3

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

Thank You

1 Like
4

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