MathGroup Archive 2005

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

Search the Archive

Re: Mathematica & Excel

  • To: mathgroup at smc.vnet.net
  • Subject: [mg59985] Re: Mathematica & Excel
  • From: "news1.sympatico.ca" <atulksharma at yahoo.com>
  • Date: Sat, 27 Aug 2005 04:11:17 -0400 (EDT)
  • References: <demmi8$rff$1@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

Excel is capable of exporting a worksheet in a plain text format, using 
spaces, tabs, or commas as delimiters. For easiest transfer, it is best to 
use tab delimitation. Then all you need to do from Mathematica is to invoke 
the Import command:


Import["file.txt", "Table"]Or, for .csv format text filesImport["file.csv",
  "Table",
  ConversionOptions -> {
    "TableSeparators" -> {
       {"\n", "\r"}, (* record delimiters *)
       {",", " "}    (* field delimiters  *)
    }
  }
]The Mathematica Link for Excel add-on package has a ReadExcel function, for 
reading native Excel workbooks. It is a useful package in general, but 
probably not worth purchasing for just this one function. A.  Sharma
"Steeve Brechmann (schumi)" <steevebrechmann at yahoo.ca> wrote in message 
news:demmi8$rff$1 at smc.vnet.net...
>
> Hi,
>
> I want to take some data (a matrix) in excel and bring it to Mathematica 
> for some calculations.
>
> How can i do this ?
>
> Thanks for the help
>
> Steeve Brechmann
>
> 


  • Prev by Date: Re: Mathematica & Excel
  • Next by Date: Re: ListDensityPlot and transparency
  • Previous by thread: Re: Mathematica & Excel
  • Next by thread: Re: Mathematica & Excel