MATLAB Answers

Hello, I'd like to extracts a cell range from an excel file, but I'm running into trouble.

2 views (last 30 days)
Francisco Loera
Francisco Loera on 18 May 2018
Edited: Greg on 18 May 2018
This is the code and the error: >> testprim = csvread('ejemplo_4.csv',1,9,[1,9,734,9]);
Error using dlmread (line 147)
Number of HeaderColumns is greater than number of columns in file.
Error in csvread (line 50)
m=dlmread(filename, ',', r, c, rng);

  0 Comments

Sign in to comment.

Answers (1)

Greg
Greg on 18 May 2018
Edited: Greg on 18 May 2018
Have you read the documentation for the inputs to csvread? You've told it to skip 9 columns, and it's giving you a very clear error message that there aren't that many columns in the entire file.
My guess is you're either having 0- vs. 1- based indexing troubles, or you actually meant to read all 9 columns, but told it to skip all 9 columns.
Try either:
testprim = csvread('ejemplo_4.csv',1,8,[1,8,734,8]); % Read the 9th column only
or
testprim = csvread('ejemplo_4.csv',1,0,[1,0,734,8]); % Read all 9 columns

  0 Comments

Sign in to comment.

Sign in to answer this question.