Re: Excel Data in Octave

[Timothy Field]

On Thu, Apr 26, 2012 at 1:24 PM, forkandwait [via Octave] <[hidden email]> wrote:

Timothy Field <timafield <at> gmail.com> writes:

> But more importantly, whats the best way to take excel data and use it in
> octave?

A recent discussion: http://thread.gmane.org/gmane.comp.gnu.octave.general/41081

My $0.02 is that you should convert data to tab delimited text (or real
databases like Postgres / SQLite)  and read it via dlmread.  Furthermore,
LibreOffice is quite mature, if you have to use spreadsheets (which tend to be
unsustainable for big projects).

_______________________________________________
Help-octave mailing list

[hidden email]
https://mailman.cae.wisc.edu/listinfo/help-octave

---

If you reply to this email, your message will be added to the discussion below:

http://octave.1599824.n4.nabble.com/Excel-Data-in-Octave-tp4590377p4590422.html

To unsubscribe from Excel Data in Octave, click here.
NAML

From the thread:

"A very simple way for big data is to save in text format and read them
with load().

Next, as it has been said, is saving in csv and load with csvread().

Next, as it has been said, is loading the io package and using the
functions therein.

You have an array of possibilities, choose one :)  "

As a short term fix, how would I convert the data into the correct text format? I've tried csvread on excel sheets saved as Data.csv, but it never is able to load the file. 

In the longterm I'd like to be able to do this quickly, and it sound like the io is best for that. Another thing I found on that thread was about downloading the java package first, is the io package dependent on the java package? Because I haven't had any luck there either (which may be because I am unsure if I have a Java JDK).

I'm going to try to install the java package again, and will post how that goes.

---

View this message in context: Re: Excel Data in Octave
Sent from the Octave - General mailing list archive at Nabble.com.