MATLAB: Reading data with Strcat and alternative

stringstrings

variable = xlsread('data.xlsx','Sheet', strcat('B', i_cell, ':G', f_cell));

In the above example I undestand that I am reading a specific sheet of the excel file but I dont get what " strcat('B', i_cell, ':G', f_cell)); " actually does.

Is there another way of writing the above code in a more easy way, by using another function instead of strcat?

Thanks in advance!

Best Answer

range = sprintf('B%d:G%d', start_row, end_row);  %where start_row and end_row are numeric
variable = xlsread('Data.xlsx', 'Sheet', range);

However it is confusing that you have something that looks like a range as a sheet name.

Related Solutions

MATLAB: How to load in a matrix and get means of certain cells

There are several functions available to read your data, depending on the file format. See the documentation on load, textscan (link), xlsread, and others (linked to in the documentation) to import your matrix file.

To calculate the mean of a 20-row section of column 2, this works:

M = rand(40, 4);                                            % Create Data
start_row = 1;
end_row = start_row + 20;
M_mean = mean(M(start_row : end_row, 2));

MATLAB: How to read dynamic range with xlsread function

Just compute the range based on your variables,

startrow = 5; endrow = 100;
startcol = 11; endcol = 35;
data = xlsread('somefile', GetExcelRange(startrow, endrow, startcol, endcol);

With:

function xlsrange = GetExcelRange(startrow, endrow, startcol, endcol)
   xlsrange = sprintf('%s%d:%s%d', GetExcelColumn(startcol), startrow, GetExcelColumn(endcol), endrow);
end
function colstring = GetExcelColumn(colindex)
   colstring = dec2base(colindex-1, 26);
   digit = colstring < 'A';
   colstring(digit) = colstring(digit) + 'A' - '1';
   colstring(~digit) = colstring(~digit) + 9;
   colstring(end) = colstring(end) + 1;
end

Best Answer

Related Solutions

MATLAB: How to load in a matrix and get means of certain cells

MATLAB: How to read dynamic range with xlsread function

Related Question