read multiple columns from an excel spreadsheet by using xlsread

Hi,

I have an Excel sheet with 300 columns, from which I just need several ranges. In a normal case I use the "import data" app. But this time it is not possible, because some of the strings are double. I just want to read in the first row and from this, several columns (all strings).

Just as an example:

I have a first row with strings like this:

  x= ["'[23Na]+'" ,  "'[24Mg]+'" ,  "'[25Mg]+'" ,  "'[26Mg]+'" , "'[26Mg]++'" ,  "'[27Al]+'" , "'C2H3+'" , "'[28Si]+'"] 

And now I just want to have A1:B1 and E1:F1. How do I use here xlsread with several ranges to end with a string like this:

  x= ["'[23Na]+'" ,  "'[24Mg]+'" , "'[26Mg]++'" ,  "'[27Al]+'"] 

I am grateful for every hint.

Answer 1

[Arif Hoq]

I guess you can not export multiple ranges data in Matlab.

Range must be of the form 'A1' (cell), 'A:B' (column-select), '1:5' (row-select), 'A1:B5' (rectangle-select), or a valid named range in the sheet.

Either you can export your data in multiple variable with range

A=readtable('example.xlsx','ReadVariableName',false,'Range','A1:B1');
B=readtable('example.xlsx','ReadVariableName',false,'Range','E1:F1');

or use readtable then process your data

[Tatjana Mü]

@Arif Hoq Thank you for your help. I never used readtable, because if I want to have just the first row with strings, I am not sure how I can use it. How can I use it, to get back just a 1x182 string array in the end?

[Arif Hoq]

if you want to export first row from 1 to 182

A=readtable('example.xlsx','ReadVariableName',false,'Range','A:FZ');

[Tatjana Mü]

@Arif Hoq Thank you so much. You seem to be quite familiar with matlab. Can I ask you another question? I have this line:

[num,txt,raw] = xlsread(filename{xy},'B1:KR1'); 

Do you know how I can add the delimiters here? And is it possible to have multiple delimiters? Because sometimes I have .csv files and sometimes .xlsx files.

[Arif Hoq]

maybe you are talking about file extension(.csv / .xlsx / .txt) not delimiters. As per i know you can define delimiters in text file (.txt). For excel or csv file readtable works efficiently as xlsread is not recommended. And i guess you can export either csv file or excel file once.

if you have further query please attach your code and data.It's better to suggest after that.