[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel spreadsheet matrix into Octave using clipboard?

From: Mike Miller
Subject: Re: Excel spreadsheet matrix into Octave using clipboard?
Date: Wed, 25 Dec 2002 10:31:46 -0600 (CST)

On Tue, 24 Dec 2002, Dmitri A. Sergatskov wrote:

> On Tue, 24 Dec 2002, Henry F. Mollet wrote:
> > I may lack certain basics. When in Excel, I don't see a menu option called
> > "export". And where would I export to? I don't know what a CSV file is. I
>   ^^^^^^^
> It may be in "File -> Save As..."

That's correct.  I have used that Excel feature many times and saved files
as tab-delimited text.  After I've moved the file to my unix machine, I
can use

awk -F'\t'

to grab needed columns of the file, or I can use

tr '\t' ','

or to change from tab-delimited to column-delimited format.

Depending on your data structure, you might just save the file as plain
text and bring it straight into Octave.

Merry Christmas!


> or something like that -- I do not have Excel handy to check it myself.
> CSV is a "Comma Separated Values" -- it is an ASCII file format, where
> columns values separated by a comma.

Octave is freely available under the terms of the GNU GPL.

Octave's home on the web:
How to fund new projects:
Subscription information:

reply via email to

[Prev in Thread] Current Thread [Next in Thread]