Re: Importing Excel File into mathematica
- To: mathgroup at smc.vnet.net
- Subject: [mg104919] Re: Importing Excel File into mathematica
- From: "Sjoerd C. de Vries" <sjoerd.c.devries at gmail.com>
- Date: Fri, 13 Nov 2009 05:55:01 -0500 (EST)
- References: <hdgq3v$iar$1@smc.vnet.net>
As far as I know, Mathematica does not import the Excel 2007 XLSX
format but only the 98-2003 XLS format. So, try converting your file
in Excel to XLS.
Cheers -- Sjoerd
On Nov 12, 1:04 pm, Benfeitas <rui.benfei... at gmail.com> wrote:
> 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