Re: Importing data from excel file.

[PhilipNienhuis]

NJank wrote
> On Fri, Oct 23, 2015 at 1:39 PM, Dark Ruler <

> darkguard88@

> > wrote:
>>
>>
>> On Wednesday, October 14, 2015 2:51 PM, Nicholas Jankowski <

> jankowskin@

> > wrote:
>>
>>
>> On Wed, Oct 14, 2015 at 1:54 PM, CodeOctave <

> darkguard88@

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

(Assuming you run Windows (you didn't answer the pertinent question in my
Oct. 14 reply:)

If you want MS-Excel to be used for spreadsheet I/O (like Matlab does) you
also need the "windows" package.
Do not install that from the Octave-Forge website (using the -forge flag);
rather, install it from the Octave installation directory:
cd ( [ OCTAVE_HOME  filesep  "src"])
pkg  install  -auto  windows-1.2.1.tar.gz

Philip




--
View this message in context: 
http://octave.1599824.n4.nabble.com/Importing-data-from-excel-file-tp4672917p4673091.html
Sent from the Octave - General mailing list archive at Nabble.com.