Selectors for cells in Excel?

Hi there,

Does anyone know if there’s a way to apply Selectors to Excel workbooks? And by this I mean more in a way of specifying a certain column/cell/etc. in the Selector Editor?

I need to fill a spreadsheet with values extracted from a PDF. One of the fields is something along these lines:

FROM (cells can’t be added to the sheet unfortunately, otherwise this would be easy):

A1
1 NAME:
2 NAME:
3 NAME:

TO (strikethrough only on ‘NAME’):

A1
1 NAME: SOME TEXT
2 NAME:
3 NAME:

I can think of only one option, and that is using the Excel Application Scope, selecting part the word within the cell that I want, and using i.e. hotkeys to strike through the word I need. But I need something more stable, as the “some text” part changes with every PDF.

Anyone ideas as to how I can tackle this?

Hi @COS,
Each of Excel cells have it’s coordinates which are easily achievable using selectors:
image
So you can set click activity on particular cell before you will write a text into it.

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