フィルターのクリア

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 ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by