Excel file not found

2 Ansichten (letzte 30 Tage)
khalida basheer
khalida basheer am 17 Sep. 2020
Kommentiert: khalida basheer am 17 Sep. 2020
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 Kommentare
Walter Roberson
Walter Roberson am 17 Sep. 2020
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 am 17 Sep. 2020
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????

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by