Excel file not found

8 visualizaciones (últimos 30 días)
khalida basheer
khalida basheer el 17 de Sept. de 2020
Comentada: khalida basheer el 17 de Sept. de 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 comentarios
Walter Roberson
Walter Roberson el 17 de Sept. de 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 el 17 de Sept. de 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????

Iniciar sesión para comentar.

Respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by