Previous section-----Next section

ExcelRange

• The id can be one of the following:

Selection

the currently selected range

All

all cells in the sheet

"Data_Range"

a defined range name

"A1:C10"

an A1-style address

{1, 1}

a {row, col} index pair

{{1, 1},{10, 3}}

a list of two index pairs {{top, left}, {bottom, right}} defining a rectangular range
• See ExcelSheet for a listing of valid id values for sheet.
• See ExcelBook for a listing of valid id values for book.

Further Examples

In[1]:=
In[2]:=
In[3]:=
Out[3]=
In[4]:=
Out[4]=
In[5]:=
Out[5]=
In[6]:=
Out[6]=