Dear Oleg,
I have found copying excel fields into Robotask challenging.
When i use 'copy' in robotask when a particular excel field is highlighted, and then use 'get text' to assign the clipboard information to a variable, not only does the text / number that's visible in the excel field get copied into the variable, but so do the <CR> & <LF> that sit (invisibly) after the number/text. (I've discovered this by copying the variable into MS Word where I can see the otherwise invisible characters.
Is there some easy way of extracting JUST the visible text/number?
Cheers, Bert
interacting with Excel
interacting with Excel
I too seem to be having an issue similar to this.
interacting with Excel
Excel puts into clopboard text as a table in following format:
- each row of cells is a line in text of clopboard
- each value is separated by tab characters from other value in the line.
If you will copy only one cell from excell, you will get the table with 1 row and 1 column, i.e. the value and <LF> (line feed) symbol.
See the following example. This task can process any range of cells and shows you how to retrieve any value of cell from copied group of cells.
You have to copy some range of cells from excell sheet into clipboard and run this task
- each row of cells is a line in text of clopboard
- each value is separated by tab characters from other value in the line.
If you will copy only one cell from excell, you will get the table with 1 row and 1 column, i.e. the value and <LF> (line feed) symbol.
See the following example. This task can process any range of cells and shows you how to retrieve any value of cell from copied group of cells.
You have to copy some range of cells from excell sheet into clipboard and run this task