Excel - Copy empty string brings up length "2"

[jhtromb]

Hello,

I have a little problem working with AutoIT and Excel:

I need to copy some values from an Excel List and I want the script to loop until it copies an empty cell.

; copy value in cell
Send("{CTRLDOWN}")
Send("{c}")
Send("{CTRLUP}")

$value = ClipGet()

; go down one row
Send("{DOWN}")

; loop through list until reaching an empty cell
while $value <> ""

     ; work with value
     ; ......

    ; copy value in cell
    Send("{CTRLDOWN}")
    Send("{c}")
    Send("{CTRLUP}")
    $value = ClipGet()
    ; go down one row
    Send("{DOWN}")

WEnd

This script does not work, because it does not recognize the content of an empty cell as "", so the comparison with <> does not stop the loop.

I tried to find out the problem: if I make a message box with StringLen($value) it shows me that the length of the empty cell is "2". When I try StringLen("") it gives me the value 0.

Anyone any idea why the length of the empty string is 2 and not 0?

Thank you very much!

[water]

Why don't you use Excel UDF which comes with AutoIt? Use _ExcelReadCell and _ExcelWriteCell to copy a cell.

[Melba23]

jheinze,

At a guess it is a @CRLF character (or 2 characters to be absolutely correct).

Try this and see if it works:

while $value <> @CRLF

But why not use the Excel UDF to do this?

M23

[jhtromb]

Thank you very much, both!

Both ideas work well. I did not think wide enough to use Excel UDF as I'm an AutoIT newbie. Thank you!