How can I call some line in an excell file ?

Hello

In a program Matlab I called this excell file but I want the file from line 19

without delating the other lines.

The attached file is the excell file.

Please help me.

[Matt Dickson]

You should just be able to

num = xlsread(path/to/file)

since that returns a matrix of the numeric data. You'll just have to manually offset your counter to 19. See more about xlsread here.

[Mallouli Marwa]

I have found this error:

 syntax error

And the program is:

cd Z:\

load 'DATA.CSV';

num = xlsread(Z:\/to/DATA.CSV)

Answer 1

[Bob Thompson]

"I want the file from line 19" -- What does this mean? Is there a file name on line 19? (Sorry but I can't open files on this device to look myself.) Either way you can specify how much of the file you want to read by using offsets or range specification.

rowoffset = 18;
coloffset = 0;
file = csvread(filename,rowoffset,coloffset,[19 0 19 end]);

I'm not sure if end will technically work there for the column range definition, and I'm also fairly sure that you don't want to specify a row offset and start at range 19 (pretty sure that will put you at row 37), but using it as an example of how you can do things.

If you are trying to read some data other than a numeric value you can use a similar range definition in xlsread, as csvread only interprets numeric data.

[Mallouli Marwa]

The program is :

cd Z:\

load 'DATA.CSV';

rowoffset = 18;

coloffset = 0;

file = csvread(DATA.CSV,rowoffset,coloffset,[19 0 19 end]);

I have found this error:

error: load: unable to determine file format of 'DATA.CSV'

[Matt Dickson]

The call to load is unnecessary, since csvread is already loading the file into the work space as a matrix. Additionally, make sure the argument passed to csvread is a string, in your code you're missing the string quotes.

[Mallouli Marwa]

error: invalid use of end

[Mallouli Marwa]

In my program just I need the file from line 19 but I shouldn't delate

the other lines.

That's what I want and thanks

[Bob Thompson]

How large is line 19? How many pieces of data are there in it? Just replace the 'end' with the number of pieces of data.

[Jan]

@Mallouli Marwa: You have accepted the answer. This marks the problem as solved. Is it solved?

[Mallouli Marwa]

No

[Bob Thompson]

If you only want one value then just set [19 0 19 1] as your range.

Answer 2

[Mallouli Marwa]

Line 19 contain one numerical data.

[Mallouli Marwa]

error: called from print_usage at line 91 column 5 csvread at line 39 column 5 Call_Line_Excell at line 7 column 6