Download User`s Manual and Reference Guide

ExcelLink
69
ExcelLink Functions
ExcelActivate
ExcelActivate[book]
makes book the active book.
ExcelActivate[sheet]
makes sheet the active sheet.
Examples
In[1]:=
<<ExcelLink`
In[2]:=
ExcelActivate[ExcelSheet["Book1","Sheet1"]]
In[3]:=
ExcelContext[]
Out[3]=
{Book1, Sheet1}
In[4]:=
ExcelActivate["Sheet3"]
In[5]:=
ExcelContext[]
Out[5]=
{Book1, Sheet3}
In[6]:=
ExcelActivate["Sheet1"]
In[7]:=
ExcelContext[]
Out[7]=
{Book1, Sheet1}
ExcelAddress
ExcelAddress[range]
returns the A1-−style address of the specified range.
Examples
In[1]:=
<<ExcelLink`
In[2]:=
ExcelAddress[{{1, 1}, {10, 3}}]
Out[2]=
A1:C10