Download Mathematica Link for Excel

Transcript
72
Mathematica Reference
In[7]:=
ExcelClose
In[8]:=
s  ToFileNameExcelDirectory"Link", "Templates", "Report.xls"
Out[8]= C:\Documents and Settings\Anton\Application Data\Mathematica\Applications\ExcelLink\Templates\Report.xls
In[9]:=
ExcelNews
Out[9]= Book: Report1
In[10]:= ExcelClose[]
ExcelObject Function
ExcelObject
 ExcelObject["type", id] represents an object of the specified type identified by id in the active context.
 ExcelObject["type", context] @ ExcelObject["type", id] provides a context for the object id.
 All Excel objects are represented internally in this form.
 See also: ExcelCheck, ExcelName, ExcelContext, ExcelBook, ExcelSheet, ExcelRange, ExcelShape.
Examples
In[1]:= <<ExcelLink`
In[2]:= object=ExcelRange["Sheet1", "A1"]
Out[2]= Range: A1
In[3]:= InputForm[object]
Out[3]//InputForm=
ExcelObject["Sheet", "Sheet1"][ExcelObject["Range", "A1"]]
In[4]:= object=ExcelRange["Book1", "Sheet1", "A1"]
Out[4]= Range: A1
In[5]:= InputForm[object]
Out[5]//InputForm=
ExcelObject["Book", "Book1"][ExcelObject["Sheet", "Sheet1"][
ExcelObject["Range", "A1"]]]