清空筛选条件
清空筛选条件

Excel file not found

5 次查看（过去 30 天）
khalida basheer
khalida basheer 2020-9-17
评论： khalida basheer 2020-9-17
How can I make sure that the Excel file is in the current location of Matlab, and in the absence of it I create it from Matlab, the problem arises when I write for the first time . when I read the Excel file for the purpose of determining the current location of the writing, the error appears that the file does not exist (File 'C:\Users\kh\Documents\MATLAB\testall.xlsx' not found.)
for i=1:4
[complete2] = xlsread('testall.xlsx');
lr = size(complete2,1);
range = ['A',num2str(lr+1)];
xlswrite('testall.xlsx',ROIRmom(i).mom,1,range);
end
  2 个评论
Walter Roberson
Walter Roberson 2020-9-17
filename = 'testall.xlsx';
if ~exist(filename, 'file')
file does not exist yet, do something
end
[...]
complete2 = xlsread(filename);
[...]
xlswrite(filename, and so on)
khalida basheer
khalida basheer 2020-9-17
filename = 'ccl.xlsx';
if ~exist(filename, 'file')
% % file does not exist yet, do something
xlswrite('ccl.xlsx',ROIlmom(1).mom,1,'A1');
for i=2:4
[complete2] = xlsread('ccl.xlsx');
lr = size(complete2,1);
range = ['A',num2str(lr+1)];
xlswrite('ccl.xlsx',ROIlmom(i).mom,1,range);
end
else
for i=1:4
[complete2] = xlsread('ccl.xlsx');
lr = size(complete2,1);
range = ['A',num2str(lr+1)];
xlswrite('ccl.xlsx',ROIlmom(i).mom,1,range);
end
end
The code worked by this way. I selected the storage method based on the presence and absence of the Excel file. Is this a good way????

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by