1

I am having a simple problem while reading excel data which contains strings, long string, and numbers. Now I need to make each column (I have 11 here) to define separate variables of 1 column vector so that I can plot in MATLAB against each other or combination.

But the problem is the reading the file and creating 11 column vector. When I assign variable the header also comes.

Code:

%fid = fopen('Data_Link.xlsx');
[num,txt,raw] = xlsread('Data_Link.xlsx');
%fclose(fid);

% Extract data from readData
A = raw(:,1);
B = raw(:,2);
C = raw(:,6);

So I need the variables without header

Data file is truncated and given here.

Can anyone help me?

aguntuk
  • 127
  • 9

2 Answers2

2

You can use readtable as ThP suggested. But if you want to use xlsread and you want your data without the header, you just need to remove the first row as in the below example:

%fid = fopen('Data_Link.xlsx');
[num,txt,raw] = xlsread('Data_Link.xlsx');
%fclose(fid);

% Extract data from readData
A = raw(2:end,1);
B = raw(2:end,2);
C = raw(2:end,6);

Note that each array will receive data from row 2 to last row.

Paolo
  • 21,270
  • 6
  • 38
  • 69
A. Renteria
  • 86
  • 2
  • Thanks a lot for your help. – aguntuk Sep 18 '18 at 21:57
  • can you check [this ques](https://stackoverflow.com/questions/52395163/matlab-plotting-only-ponts-with-colorbar-based-on-another-variable) as well, if you are free...as no one is answering.. – aguntuk Sep 19 '18 at 08:29
1

You can use readtable instead of xlsread.
Using 

T = readtable(‘Data_Link.xlsx’)

will result in a table with a variable for each column. For example T.Year would hold the values from the ‘Year’ column and T.Title would hold the values from the ‘Title’ column, etc.

ThP
  • 2,312
  • 4
  • 19
  • 25
  • can you check [this ques](https://stackoverflow.com/questions/52395163/matlab-plotting-only-ponts-with-colorbar-based-on-another-variable) as well, if you are free...as no one is answering.. – aguntuk Sep 19 '18 at 08:29