Appdesigner: Writing Data To Excel

  % 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?

Answer 1

[dpb]

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

[I]

How should I go about saving an imported excel table after editing?

[dpb]

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

[I]

Nothing at all. It worked perfectly.