Mathematica 9 is now available
Student Support Forum
-----
Student Support Forum: 'Importing Excel into mathematica' topicStudent Support Forum > General > "Importing Excel into mathematica"

Next Comment >Help | Reply To Topic
Author Comment/Response
RuiB
11/11/09 11:50am

Hi!
I'm trying to import a table that I did in Excel into mathematica. It has 2 columns, 15 lines.
For some reason, it doesn't give the output that I wanted in mathematica...

Here's the code I've been trying to use:

"In[21]:= Path1 =
"C:\\blahblahblah\\Book1.xlsx";
Import[Path1, "Elements"]
Out[22]= {"FileNames"}



In[18]:= Import[Path1, "FileNames"]
Out[18]= {"[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", \
"xl\\calcChain.xml", "docProps\\core.xml", "docProps\\app.xml"}



In[24]:= Take[Import[Path1, 15]] // TableForm
Out[24]//TableForm= \!\(\*
TagBox["\<\"docProps\\\\app.xml\"\>",
Function[BoxForm`e$,
TableForm[BoxForm`e$]]]\)""



Could someone please tell me why it is outputting docProps\\\\app.xml instead of a table?
thanks


URL: ,

Subject (listing for 'Importing Excel into mathematica')
Author Date Posted
Importing Excel into mathematica RuiB 11/11/09 11:50am
Re: Importing Excel into mathematica gavin 12/02/09 7:14pm
Next Comment >Help | Reply To Topic