save the the file into excel
1 回表示 (過去 30 日間)
古いコメントを表示
Hi, I have a lone code with about 7 variables Im trying to save into excel sheet with the variables names as headline and the data into the column of that headline. all the varables are matrix 20x1 and the names are listed below.
r_coords
extracted_data
r_exper
V_exper
V_interpolation
Absuolut_Error
Relative_Error
filename = (sprintf('monitor_line_%d_ degree %.1fCA_%s', Monitor_line, CrankAngle, upper(variable)));
Results_Names={'r_coords','extracted_data','r_exper','V_exper','V_interpolation','Absuolut_Error','Relative_Error'};
Results_Values=[r_coords,extracted_data,r_exper,V_exper,V_interpolation,Absuolut_Error,Relative_Error];
sheet=1;
xlswrite('filename.xlsx',Results_Values,sheet);
5 件のコメント
dpb
2019 年 12 月 15 日
The file O:\Research\research\filename.xlsx is not writable.
It might be locked by another process.
That has nothing to do with the data; the file is locked...already opened by Excel. You either have it open for edit or possibly there's a zombie process left after a previous try w/ xlswrite that didn't manage to clean up gracefully.
Close all instances you can see (if any) manually, then open the Task Manager and kill any Excel process that show up (kill the tree).
If all else fails, restart your system.
回答 (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!