Previous section-----Next section

Excel

• The location identified by id can be a range, shape, or sheet.
• The id can be a name, A1-style address, All, Selection, or an Excel object reference.
• Assigning graphics, typeset equations, or formatted output to a location displays a graphic.
Excel[id] is equivalent to ExcelRead[id].
Excel[id] = expr is equivalent to ExcelWrite[id, expr].
Excel[id] = . is equivalent to ExcelClear[id].
ExcelRange, ExcelShape, or ExcelSheet can be used to create an Excel object reference.
• Excel object references can be used to provide a specific context for id or to specify a different type of id.
• Examples: Excel["A1:C10"], Excel["Sheet1"], and Excel[ExcelSheet[1]].

Further Examples

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