save the the file into excel

2 次查看（过去 30 天）

amjad almaarafawi 2019-12-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/496662-save-the-the-file-into-excel

评论： dpb 2019-12-15

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 个评论
显示 3更早的评论隐藏 3更早的评论

amjad almaarafawi 2019-12-15

在 MATLAB Online 中打开

yes after i checked 2 of the variables 40x1 so I took them off to see if the code will work but i got a different 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_exper,V_exper,V_interpolation,Absuolut_Error,Relative_Error];
xlswrite('filename.xlsx',Results_Values);
winopen('testdata.xls');
here is the Error 
Error using xlswrite (line 224)
The file O:\Research\research\filename.xlsx is not writable.  It might be locked by another process.
Error in ExtractMonitorData (line 129)
xlswrite('filename.xlsx',Results_Values);

so is there anyway I can save them even if the array dimenssion does not agree like 40x1 and 20x1 ?

Sorry for make it this long question. thanks in advance

dpb 2019-12-15

在 MATLAB Online 中打开

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.

请先登录，再进行评论。

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