Importing Excel File into mathematica
- To: mathgroup at smc.vnet.net
- Subject: [mg104871] Importing Excel File into mathematica
- From: Benfeitas <rui.benfeitas at gmail.com>
- Date: Thu, 12 Nov 2009 06:03:58 -0500 (EST)
Hi!
I'm trying to import a small table (2 columns and 15 lines) into
mathematica, but for some reason I'm not able to do it...
Here's the code Im trying:
In[1]:= Path1 =
"C:\\Documents and Settings\\Ankit\\Desktop\\Book1.xlsx";
Import[Path1, "Elements"]
Out[2]= {"FileNames"}
In[5]:= Import[Path1]
Out[5]= {"[Content_Types].xml", "_rels\\.rels", \
"xl\\_rels\\workbook.xml.rels", "xl\\workbook.xml", \
"xl\\theme\\theme1.xml", "xl\\worksheets\\_rels\\sheet1.xml.rels", \
"xl\\worksheets\\sheet2.xml", "xl\\worksheets\\sheet3.xml", \
"xl\\worksheets\\sheet1.xml", "xl\\sharedStrings.xml", \
"xl\\styles.xml", "xl\\printerSettings\\printerSettings1.bin", \
"docProps\\core.xml", "docProps\\app.xml"}
In[6]:= Take[Import[Path1, 15]] // TableForm
During evaluation of In[6]:= Import::noelem: The Import element "15"
is not present when importing as ZIP. >>
Out[6]//TableForm= \!\(\*
TagBox["$Failed",
Function[BoxForm`e$,
TableForm[BoxForm`e$]]]\)
Why isn't it outputting the table that i had in excel?
Thanks a lot for all the help