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."
clear all
close all
mkdir myfolder
dir myfolder
for k = 101 : 105
filename = (k,'*.xlsx');
data = readmatrix(strcat(filename),'Range','BS:BX');

Answers (1)

Jan on 12 Mar 2021
Folder = 'C:\Your\Folder';
for k = 101 : 105
filename = fullfile(Folder, sprintf('%d.xlsx', k));
data = readmatrix(filename, 'Range', 'BS:BX');
Souarv De
Souarv De on 31 May 2023
@Natalie Klueppelberg Make sure whether the file you want to upload having .xlsx or .csv extension. You have to use the appropiate extension accordingly.

Sign in to comment.


Find more on Data Import from MATLAB in Help Center and File Exchange


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!