Export Data to Excel Error:

2022 6 30
3 个回答
回答已采纳
更新时间：2022 7 4
3 次查看（30 天）

0 个投票

I have three different output arrays as low voltage, med voltage and high voltage. Three arrays have different number of rows. I want to export three arrays as three different columns of same excel sheet.I tried to use the writetable, but after one writetable command, it is giving error
"Unable to write to file 'FlowDistinction_Yearly.xlsx'. You may not have write permissions or the file may be open by another
application."
Code:
filename = 'FlowDistinction_Yearly.xlsx'
writetable(array2table(High),filename,'sheet',1,'Range','A1:')
writetable(array2table(Med),filename,'sheet',1,'Range','A2:')
I checked few other options but most of them require same number of rows but in my case, number of rows will be different for each column.

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

 采纳的回答

Clayton Coonrod
Clayton Coonrod 2022-6-30

0 个投票

A = [1,2,3,4];
B = [5,6,7];
C = [8,9,10,11,12];
ncol=max([length(A),length(B),length(C)]);
ndatasets=3;
T=cell(ndatasets,ncol);
T(1,1:length(A))=table2cell(array2table(A));
T(2,1:length(B))=table2cell(array2table(B));
T(3,1:length(C))=table2cell(array2table(C));
filename='FlowData2.xls';
T=cell2table(T');
writetable(T,filename)

更多回答（2 个）

Cris LaPierre
Cris LaPierre 2022-6-30
编辑：Cris LaPierre 2022-6-30

1 个投票

I am able to reproduce the error in R2018b. This appears to be an issue that has been fixed in newer versions of MATLAB. Any chance you can update your MATLAB version?
Note that, to write your data , I think you want the following Range syntax
writetable(array2table(High),filename,'sheet',1,'Range','A:A')
writetable(array2table(Med),filename,'sheet',1,'Range','B:B')

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Harjas
Harjas 2022-6-30
Yes. But it still gives same error. Right now, it is not possible to update the MATLAB version. But, answer given by Clayton worked for me. Thanks for looking into my question.
Cris LaPierre
Cris LaPierre 2022-7-1
编辑：Cris LaPierre 2022-7-1
Ok, I asked internally and the recommendation was to add the 'UseExcel',false name-value pair, which fixed the error for me. In R2018 the default is true. In R2019 and on, the default is now false.
writetable(array2table(High),filename,'sheet',1,'Range','A:A','UseExcel',false)
writetable(array2table(Med),filename,'sheet',1,'Range','B:B','UseExcel',false)
Harjas
Harjas 2022-7-4
Okay, I tried to use but it is now giving me invalid parameter name: UseExcel. I have attached the error image for your reference.
Image Analyst
Image Analyst 2022-7-4
@Harjas then just use @Clayton Coonrod's solution which you said already worked.
Otherwise take out the 'UseExcel' parameter. If you still want an .xlsx format workbook created but for some reason do not want Excel to be used, then call tech support and ask them why UseExcel is not working. The UseExcel = false should work for these formats: .xls, .xlsx, .xlsm, .xltx, .xltm

请先登录，再进行评论。

Image Analyst
Image Analyst 2022-6-30

1 个投票

Maybe the workbook is still locked because the first call to writetable() has not finished 100%. If you put
pause(2); % Wait 2 seconds for writetable to finish.
in between the calls to writetable, does it work then?

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Cris LaPierre
Cris LaPierre 2022-6-30
编辑：Cris LaPierre 2022-6-30
It didn't help me. I had to kill the process and delete the workbook, and even then, it wasn't behaving as I would expect.
Harjas
Harjas 2022-6-30
编辑：Harjas 2022-6-30
No,it still gives same error. But, answer given by Clayton worked for me. Thanks for looking into my question.
Image Analyst
Image Analyst 2022-7-1
No problem. Please click "Accept this answer" on his answer below to award him reputation points.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2018a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by