Re: Importing data from excel file.

[Nicholas Jankowski]

On Fri, Oct 23, 2015 at 1:39 PM, Dark Ruler <address@hidden> wrote:
>
>
> On Wednesday, October 14, 2015 2:51 PM, Nicholas Jankowski <address@hidden> 
> wrote:
>
>
> On Wed, Oct 14, 2015 at 1:54 PM, CodeOctave <address@hidden> wrote:
>
> Hi,
> I just started using Octave as an alternative to Matlab.
> I have been trying to import data for the last hour or so with no success.
> Can someone clearly explain and show me how it is done?
> Also where the file should be located.
> In addition, I was able to open the excel file through Octave. Is there a
> purpose for this?
>
> This is one example of my attempts.
> >> A = xlsread('Lithium_Cell_#3_July8, 2015', 'Sheet1', 'A1:A2')
> warning: Functions for spreadsheet style I/O (.xls .xlsx .sxc .ods .dbf .wk1
> etc.) are provided in the io package. See `http://octave.sf.net/io/'.
>
> Please read `http://www.octave.org/missing.html' to learn how you can
> contribute missing functionality.
>
> error: 'xlsread' undefined near line 1 column 5
>
>
> as the warning message says, you need to enable the io package to use 
> spreadsheet functions.  I believe the io package should be installed by 
> default.
>
> try:
>
> pkg load io
>
> then retry your function with the xlsread command.
>
> if you want the package loaded by default when you start octave, use the 
> command:
>
> pkg rebuild -auto io
>
>
> to see what other packages you have, you can type:
>
> pkg list
>
> Finally, to make sure all the installed packages are up to date, you can use 
> the command (you need internet connectivity and it often takes a few minutes 
> to finish, be patient):
>
> pkg update
>
>
>Hi,
>Turns out I did not have the io package.
>What are the installation steps?
>The homepage of Octave-Forge was not detail in the process.

pkg install -forge io

should fetch the latest version from website and install it. you may want

pkg install -forge -auto io

so that it automatically loads when you start Octave

you can also download and save the package file from the Octave Forge
website and use

pkg install <filename>