MathGroup Archive 2005

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

Search the Archive

Re: Mathematica 5.0 and Excel


Using MathLink for Excel makes life easy in this case.

<< Excel`
SomeMatrix=ReadExcel["SomeFile.xls","SomeSheet","A11:Q26"]

will read the range A11:Q26. Of course variable can be used in stead of
literals.

One drawback is that the excel file must be closed to have the link
reading it.
Depending on what you need using Transpose[ReadExcel[......]] must be
used.
Hope it helps,
Janwillem


  • Prev by Date: Re: Beginner: Importing files, maintaining file format.
  • Next by Date: Rotate Frame Label?
  • Previous by thread: Re: Re: Mathematica 5.0 and Excel
  • Next by thread: Mathemaica 5.2 are the 64 Bit an illusion !!!....?