Re: [Q:] How to use "xlswrite()" in Octave on Mac OS X Mavericks?

[Philip Nienhuis]

TAISO, Renpoo wrote
> Hi there!
> I'm new to here, and my name is Renpoo.
> 
> I'm a norvice user of Octave for a few months, and want to do some
> signal processing job for a project. In the proj., I've already borrowed
> some programs from my colleague and those codes are using the structured
> data to contain every kind of resulting parameters.
> 
> I want to examine these resulting data in the Excel, since it is too
> much amount and hard to examine in the "Workspace" window.
> 
> But the output command "xlswrite()" cannot work well with Octave 3.8.0
> (GUI) on Mavericks.
> If I want to use it, first of all, I have to install Java package, but I
> can't, even though my Mac had already been installed the Java 1.6.0. as
> Java Virtual Machine.
> 
> So, what should I do?
> Is there any way to use xlswrite() in Octave on my Mac?
> Or, is there another method useful to display/write-to-file those
> resulting (structured) data?

(Disclaimer: I do not have a Mac so I'm not sure if the below will work
*that* easily, so keep fingers crossed)

If you're OK with the newer .xlsx Excel format, you do not need Java.
E.g. LibreOffice can easily read & write .xlsx as well so you can inspect
your data with it. Or with a recent enough Excel, if you insist.

Have you got the io package installed? The newest version is 2.2.3; that
should work with Octave-3.8.x
If not:

more off
pkg install -forge -verbose io        ## Not sure if that'll work on OSX;
maybe other ways are needed

So, if you have the io package installed *and loaded*, you should be able to
write .xlsx files right away. 
Just ignore the various messages the first time you use xlswrite.
Those messages just inform you what options ("interfaces") the io package
has detected for spreadsheet I/O, it only searches the first time you invoke
a function for spreadsheet I/O. (FYI, it should default to the "OCT
interface", the one that doesn't require Java.)

Philip




--
View this message in context: 
http://octave.1599824.n4.nabble.com/Q-How-to-use-xlswrite-in-Octave-on-Mac-OS-X-Mavericks-tp4666271p4666273.html
Sent from the Octave - General mailing list archive at Nabble.com.