Excel Range: Difference between revisions
Jump to navigation
Jump to search
Created page with "On this page you will find some special ranges and how to define them in AutoIt.<br /> As input file I will use the following Excel workbook. All cells which have a value now ..." |
mNo edit summary |
||
| Line 3: | Line 3: | ||
[[File:Range.jpg]]<br /> | [[File:Range.jpg]]<br /> | ||
All examples show cells of the selected range in yellow. | All examples show cells of the selected range in yellow. | ||
= Used Range = | == Used Range == | ||
<syntaxhighlight lang="autoit">$oRange = $oWorkBook.Activesheet.UsedRange</syntaxhighlight> | <syntaxhighlight lang="autoit">$oRange = $oWorkBook.Activesheet.UsedRange</syntaxhighlight> | ||
Selects all cells which have a value now or had a value before (means: all cells which had been touched by the user or a script).<br /> | Selects all cells which have a value now or had a value before (means: all cells which had been touched by the user or a script).<br /> | ||
Revision as of 15:33, 31 October 2014
On this page you will find some special ranges and how to define them in AutoIt.
As input file I will use the following Excel workbook. All cells which have a value now or had a value before (means: all cells which had been touched by the user or a script) are displayed in grey.
All examples show cells of the selected range in yellow.
Used Range
$oRange = $oWorkBook.Activesheet.UsedRange
Selects all cells which have a value now or had a value before (means: all cells which had been touched by the user or a script).
Note that the range does not contain row 1 and column 1!
