How to replace multiple xlsread commands
显示 更早的评论
I have an older matlab code that reads multiple areas of a single excel sheet using multiple xls read commands. For example:
[NUM1 TXT1] = xlsread(myfile.xlsx,'Sheet1','A1:C10')
[NUM2,TXT2]= xlsread(myfile.xlsx,'Sheet1','Z200:AB500');
The data in the spreadsheet can be numerical or text, so having them split out like xlsread is handy for me (I use both the text and numerical data). I want to replace the multiple xls read commands with a single command to speed up the code, because the excel files are large and it takes a while to get all the data. I'm playing with a single readcell command and trying to get the data locations sorted out from the cell array but struggling with the multiple data types.
data=readcell(myfile.xlsx,'Sheet','Sheet1','Range','A1:AB500')
data1 = data(1:10,1:3)
Now data 1 is a cell array that contains A1:C10, but I need to get the numeric data and text data out of it in a way that replicates the [NUM1 TXT1] that I get from xlsread. Any ideas?
采纳的回答
data1 = {'dog',1,3,'cat'; 10 12 'fish' 17}
idx=cellfun(@isnumeric,data1);
NUM1=nan(size(data1));
NUM1(idx)=cell2mat(data1(idx))
TXT1=data1;
TXT1(idx)={''}
5 个评论
But isn't each column of each data block uniformly text or char? If so, I feel like two calls to readtable might be faster,
T1 = readtable('myfile.xlsx','Range','A1:C10')
T2 = readtable('myfile.xlsx','Range','Z200:AB500');
You can also experiment with reading the whole block, as you were planning to do with readcell.
data=readtable('myfile.xlsx','Range','A1:AB500')
data1 = data(1:10,1:3)
ED
2025-4-24
Matt J
2025-4-24
I would do,
nanmap=isnan(NUM1);
I=all(nanmap,2);
J=all(nanmap,1);
NUM1(I,J)=[];
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Translated by 
