Clear Filters
Clear Filters

Import and Read data with several sheets

7 views (last 30 days)
Oluwasogo
Oluwasogo on 16 Jul 2024
Edited: dpb on 16 Jul 2024
Hello Everyone,
I am trying to use the line of code below to read my matrix data from an excel file. However, I get stuck from the the 2nd line of code, which takes forever to run and not complete. I am wondering if I am doing something wrong. Can some help with advice?
[~,sheet_name]=xlsfinfo('Gas.xlsx');
for k=1:numel(sheet_name)
data{k}=readmatrix('Gas.xlsx','Sheet',sheet_name{k},'Range','A2:IP176');
end

Accepted Answer

dpb
dpb on 16 Jul 2024
Edited: dpb on 16 Jul 2024
Hard to diagnose w/o the file, but try
sheets=sheetnames('Gas.xlsx');
for k=1:numel(sheets)
data{k}=readmatrix('Gas.xlsx','Sheet',sheets(k),'NumHeaderLines',1);
end

More Answers (2)

Amith
Amith on 16 Jul 2024
Hi Oluwasogo,
The following code snippet will assist you in reading data from multiple Excel sheets:
Assumptions:
  • The desired data is stacked vertically.
  • The number of columns is consistent across all sheets.
% Importing Data from excel across multiple sheets and filenames.
filename = 'file.xlsx';
[~,sheet_name]=xlsfinfo(filename)
data_all = [];
for k=1:numel(sheet_name)
[data,TXT,RAW]=xlsread(filename,sheet_name{k})
% stack data vertically
data_all = [data_all ; data];
end
Hope this helps!
  1 Comment
Stephen23
Stephen23 on 16 Jul 2024
"Using 'readtable' can be more efficient for reading data from Excel files."
Really? Do you have a reference for this claim?

Sign in to comment.


Ashutosh Thakur
Ashutosh Thakur on 16 Jul 2024
Hello Oluwasogo,
I understand that you are trying to read an Excel sheet and the performance issue might be due to the xlsinfo and readmatrix functions. Additionally, to get the names of the sheets in an Excel file, the sheetnames function is recommended instead of xlsinfo.
You can refer to the following documentation link for more information on sheetnames:
Please note that the sheetnames function will return a string array instead of a cell array. Additionally, you can preallocate the cell array such as data for better performance. The following lines of code can be used as a reference:
sheet_names = sheetnames('Filename.xlsx');
numSheets = numel(sheet_names)
data = cell(1, numSheets); % Preallocate cell array
for k = 1:numSheets
data{k} = readmatrix('Filename.xlsx', 'Sheet', sheet_names(k), 'Range', 'A2:IP176');
end
I hope this helps you!

Community Treasure Hunt

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

Start Hunting!