Timothy Field wrote
>
> On Thu, Apr 26, 2012 at 1:24 PM, forkandwait [via Octave] <
> ml-node+s1599824n4590422h55@.nabble> 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]
>> <http://user/SendEmail.jtp?type=node&node=4590422&i=0>
>> 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<http://octave.1599824.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4590377&code=dGltYWZpZWxkQGdtYWlsLmNvbXw0NTkwMzc3fDE5NTUwMTMzNzA=>
>> .
>> NAML<http://octave.1599824.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.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?
>
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:
octave-dev@lists.sourceforge.net
(cc'd now)
Philip
______________________________________
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-tp4590377p4590777.html
This email was sent by PhilipNienhuis (via Nabble)
To receive all replies by email, subscribe to this discussion:
http://octave.1599824.n4.nabble.com/template/NamlServlet.jtp?macro=subscribe_by_code&node=4590377&code=b2N0YXZlLWRldkBsaXN0cy5zb3VyY2Vmb3JnZS5uZXR8NDU5MDM3N3wtODQ3MzA3MzI2
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Octave-dev mailing list
Octave-dev@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/octave-dev
