Loading in Multiple Excel Files using readmatrix
17 views (last 30 days)
Hi, I have this short code below but I am trying to import 5 excel files, names 101, 102, 103, 104 and 105.xlsx into matlab's workspace as separate cells so i can later make figures by calling on a column in each cell array.
They have the same number of columns (BS:BX) 6 columns is all I need but will have various rows. I'm new to MATLAB so maybe I am missing something easy here, it doesn't like the line "filename = (k,'%dtrf.xlsx');". "Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for mismatched delimiters."
for k = 101 : 105
filename = (k,'*.xlsx');
data = readmatrix(strcat(filename),'Range','BS:BX');