Unable to write data in already open .xlsx file

Question

Kuber Dwivedi 2022-9-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1793510-unable-to-write-data-in-already-open-xlsx-file

评论： dpb 2022-9-28

I am writing the data in an .xlsx file , but when the user opens that file its denied to write the data and give an error "Unable to write to file 'D:\Fuel_Cell_Stack_GUI_Final_V.21\Temp_09-02-2022_16-06-08.xlsx'. You may not have write permissions or the file may be open by another application.

here is my code

pgRx_Ecu_Anlog.FC_IO_Status= 1;
pgRx_Ecu_Anlog.FC_Pack_Voltage=2;
pgRx_Ecu_Anlog.Stack_current= 3;
pgRx_Ecu_Anlog.SOC= 4
pgRx_Ecu_Anlog.Average_Temperarture_of_Pack=5;
canLog = struct2table(pgRx_Ecu_Anlog)
FileName = sprintf('Temp_%s.xlsx', datestr(now,'mm-dd-yyyy_HH-MM-SS'));
writetable(canLog,FileName,'WriteMode','append')
% it write the data but when the xlsx file is already open it gives error"

2 个评论
显示无隐藏无

Mathieu NOE 2022-9-2

hello

you cannot write from matlab in a excel file that is opened

Kuber Dwivedi 2022-9-28

Thank you

请先登录，再进行评论。

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

Answer 1

dpb 2022-9-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1793510-unable-to-write-data-in-already-open-xlsx-file#answer_1040585

<microsoft.com Excel/use-shared-workbook> explains how to save a workbook as shared for simultaneous access. I've not tried this with the MATLAB interface functions as to whether it is successful in that scenario or not...

2 个评论
显示无隐藏无

Kuber Dwivedi 2022-9-28

Thank you, but it's not working

dpb 2022-9-28

As noted, I hadn't physically tried with MATLAB high level functions.

It's a requirement, but not sufficient in and of itself -- the other app has to also play by the rule and open with shared permissions instead wanting exclusive as well...your only chance would be with COM then.

请先登录，再进行评论。