Re: Excel Data in Octave

[PhilipNienhuis]

Timothy Field wrote
> 
> On Thu, Apr 26, 2012 at 1:24 PM, forkandwait [via Octave] <
> address@hidden> 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]
>> &lt;http://user/SendEmail.jtp?type=node&amp;node=4590422&amp;i=0&gt;
>> 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&lt;http://octave.1599824.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&amp;node=4590377&amp;code=dGltYWZpZWxkQGdtYWlsLmNvbXw0NTkwMzc3fDE5NTUwMTMzNzA=&gt;
>> .
>> NAML&lt;http://octave.1599824.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&amp;id=instant_html%21nabble%3Aemail.naml&amp;base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml&gt;
>>
> 
> 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? 
> 

Yes, and (AFAIK) on a development framework (compiler, header files, ...).



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

Yes, please keep us informed on that.

I do not know what is needed to get the java package installed on Mac OSX. 
There are some comments in the source files (notably ./src/__java__.cc)
indicating some OSX support, but AFAIK none of the people recently working
on the Java package have ever been able to test it on OSX.

If you succeed you could help me add the relevant info to the Octave wiki /
Java package section.

As to .csv:
The latest io package release has csv2cell, which seems to be able to read
mixed numeric/text info in .csv files (a known stumbling block for many
other .csv reading functions). In addition it is *much* faster then many
other text read functions.
While csv2cell doesn't depend on Java, it is a compiled function, so I think
you'd need some sort of development framework anyway.
Hopefully the OSX gurus jump in to explain how to proceed.

BTW It would be wise to move this thread to the Octave-Forge mailing list as
this doesn't concern core octave:
address@hidden
(cc'd now)

Philip



--
View this message in context: 
http://octave.1599824.n4.nabble.com/Excel-Data-in-Octave-tp4590377p4590777.html
Sent from the Octave - General mailing list archive at Nabble.com.