Re: reading xls file

[James Sherman Jr.]

fopen works similarly to its c counterpart, it returns something akin to a file pointer (if you're familiar with c).  You have to use functions like fscanf and fgetl to read in the data, if you know the format of the file.  I'm not aware of the format of an xls file.

Probably, the easiest way to read data output from excel would probably be to save the data in some simple ascii format, like comma separated values.  Then it will be trivial (assuming its only numbers) to read it in using fscanf or even just load might work.


Hope this helps,
James

On 8/31/07, address@hidden <address@hidden > wrote:

Dear Octave users,

I have installed Octave 2.9.13 for windows. I put a file.xls intitled "kir" in (c:/programfiles/octave). this file contains two columns.the first headed with y, the other with x. I want to read kir.xls from "Octave propmt".I have written this line:

fid=fopen ("kir.xls,"r")

The problem, I obtained always a strictly positif integer but I can't read the two columns x and y. What can I do? Many thanks in advance

_______________________________________________
Help-octave mailing list
address@hidden
https://www.cae.wisc.edu/mailman/listinfo/help-octave