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
>
>