Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2005
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2005

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

Search the Archive

Re: Mathematica 5.0 and Excel

  • To: mathgroup at smc.vnet.net
  • Subject: [mg60644] Re: Mathematica 5.0 and Excel
  • From: "janwillem van dijk" <j.vandijk at nrg-nl.com>
  • Date: Fri, 23 Sep 2005 04:19:47 -0400 (EDT)
  • References: <dgtjk1$2e7$1@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

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 !!!....?