Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2009

[Date Index] [Thread Index] [Author Index]

Search the Archive

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


  • Prev by Date: Re: Re: How to Calculatelength of an Spline
  • Next by Date: Re: How to Calculatelength of an Spline curve between two points?
  • Previous by thread: Re: Re: Re: Non-Linear pendulum
  • Next by thread: Re: Importing Excel File into mathematica