From help-octave-request at bevo dot che dot wisc dot edu Tue Dec 24 20:37:30 2002
Subject: Re: Excel spreadsheet matrix into Octave using clipboard?
From: "Henry F. Mollet" <mollet at pacbell dot net>
To: Octave_post <help-octave at bevo dot che dot wisc dot edu>
Date: Tue, 24 Dec 2002 18:39:07 -0800

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
did cut and paste the Excel 3x3 matrix into TextEdit but as noted before it
eliminates the white spaces and the linebrakes I see in the clipboard. If I
add the white spaces and the line brakes in TextEdit, then I can paste it
into Octave using "clip =[", then paste, then "]":
octave:23> clip = [0.00000 0.00000 1.37374
> 0.92612 0.90232 0.0000
> 0.00000 0.023800 0.92600]
clip =
  0.00000  0.00000  1.37374
  0.92612  0.90232  0.00000
  0.00000  0.02380  0.92600
Henry

on 12/24/02 4:02 PM, Dmitri A. Sergatskov at dima at coffee dot phys dot unm dot edu wrote:
> I do not know how to do this cut-n-paste thing, but you can export
> spreadsheet into text, CSV file and read this file with octave...
> 
> Regards,
> 
> Dmitri.
> 



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

Octave's home on the web:  http://www.octave.org
How to fund new projects:  http://www.octave.org/funding.html
Subscription information:  http://www.octave.org/archive.html
-------------------------------------------------------------