Appdesigner: Writing Data To Excel

15 次查看（过去 30 天）

I 2021-3-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/785856-appdesigner-writing-data-to-excel

评论： I 2021-4-1

  % Button pushed function: WriteDataButton
        function WriteDataButtonPushed(app, event)
            w = writetable("Book1.xlsx","Sheet",1);
            app.UITable.Data = w;
        end

I can open an excel sheet with opentable, so I just assumed that writetable would work in the oppose way. I was wrong.

I have the error:

Error using writetable

Too many output arguments.

Is there a way to get this to work?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

dpb 2021-3-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/785856-appdesigner-writing-data-to-excel#answer_660571

编辑：dpb 2021-3-28

在 MATLAB Online 中打开

writetable returns no arguments and needs the data to output as an argument -- read the doc first...

% Button pushed function: WriteDataButton
function WriteDataButtonPushed(app, event)
  writetable(app.UITable.Data,"Book1.xlsx","Sheet",1);
end

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

dpb 2021-3-29

What's wrong with writetable using proper syntax as shown?

I 2021-4-1

Nothing at all. It worked perfectly.

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

MATLAB

版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by