I need help exporting data from table in Matlab GUI to excel

Question

Miss B 2020-3-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/512756-i-need-help-exporting-data-from-table-in-matlab-gui-to-excel

评论： Halil AYDIN 2021-11-17

采纳的回答： Ameer Hamza

Hello everyone!

Hope all is well and in good health.

So where do i start?

I want to know if I created a 'Table' in GUI whereby a user inputs data - how will I go about exporting this table in a Excel Spreadsheet?

I read up on using xlswrite(filename,A,sheet) - How would I use this where appropiate?

For instance, for my homework - I need to make a table where 'Students' will input their grades and the 'data' will then export to Excel Spreadsheet for them to keep.

I'm awfully confused.

Any help would be appreciated.

Thank you.

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

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2020-3-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/512756-i-need-help-exporting-data-from-table-in-matlab-gui-to-excel#answer_421874

sample.mlapp

The attached app to see how you can create a GUI table in the app designer and save its content in an MS Excel file.

12 个评论
显示 10更早的评论隐藏 10更早的评论

Ameer Hamza 2020-3-25

在 MATLAB Online 中打开

You can copy the code from the "code view" tab and paste it in a script. You will also need to remove 'app.' from that code. I wouldn't recommend going this route

UIFigure = uifigure('Visible', 'off');
UIFigure.Position = [100 100 640 480];
UIFigure.Name = 'MATLAB App';
% Create UITable
UITable = uitable(UIFigure);
UITable.ColumnName = {'Name'; 'Grade'};
UITable.RowName = {};
UITable.ColumnEditable = [true true];
UITable.Position = [181 198 302 185];
% Create filenameEditFieldLabel
filenameEditFieldLabel = uilabel(UIFigure);
filenameEditFieldLabel.HorizontalAlignment = 'right';
filenameEditFieldLabel.Position = [185 116 51 22];
filenameEditFieldLabel.Text = 'filename';
% Create filenameEditField
filenameEditField = uieditfield(UIFigure, 'text');
filenameEditField.Position = [251 116 100 22];
filenameEditField.Value = 'myExcelFile';
% Create SaveButton
SaveButton = uibutton(UIFigure, 'push');
% SaveButton.ButtonPushedFcn = createCallbackFcn(app, @SaveButtonPushed, true);
SaveButton.Position = [409 116 100 22];
SaveButton.Text = 'Save';
% Show the figure after all components are created
UIFigure.Visible = 'on';

Ameer Hamza 2020-3-25

在 MATLAB Online 中打开

Following code shows an example of how to do it without app designer. To futher modify the layout, read the documentation of uifigure, uitable, uieditfield, etc.

UIFigure = uifigure('Visible', 'off');
UIFigure.Position = [100 100 640 480];
UIFigure.Name = 'MATLAB App';
% Create UITable
UITable = uitable(UIFigure);
UITable.ColumnName = {'Name'; 'Grade'};
UITable.RowName = {};
UITable.ColumnEditable = [true true];
UITable.Position = [181 198 302 185];
% Create filenameEditFieldLabel
filenameEditFieldLabel = uilabel(UIFigure);
filenameEditFieldLabel.HorizontalAlignment = 'right';
filenameEditFieldLabel.Position = [185 116 51 22];
filenameEditFieldLabel.Text = 'filename';
% Create filenameEditField
filenameEditField = uieditfield(UIFigure, 'text');
filenameEditField.Position = [251 116 100 22];
filenameEditField.Value = 'myExcelFile';
% Create SaveButton
SaveButton = uibutton(UIFigure, 'push');
SaveButton.ButtonPushedFcn = {@SaveButtonPushed, UITable, filenameEditField};
SaveButton.Position = [409 116 100 22];
SaveButton.Text = 'Save';
% Show the figure after all components are created
UIFigure.Visible = 'on';
t = table(repmat({''}, 10, 1), zeros(10,1));
UITable.Data = t;
function SaveButtonPushed(~, ~, table, editField)
    filename = [editField.Value '.xlsx'];
    t =  table.Data;
    t.Properties.VariableNames = table.ColumnName;
    writetable(t, filename);
end

Ameer Hamza 2020-3-25

在 MATLAB Online 中打开

How did you create this line

function varargout = save_document_OutputFcn(hObject, eventdata, handles)

Are you using GUIDE?

Halil AYDIN 2021-11-17

How to export colored UITable data to excel? The code above works but I want to colored specific cells and export all data with colored. There must be a way to get colored excel sheet from UI table.

请先登录，再进行评论。

I need help exporting data from table in Matlab GUI to excel

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

采纳的回答

12 个评论
显示 10更早的评论隐藏 10更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

I need help exporting data from table in Matlab GUI to excel

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

采纳的回答

12 个评论 显示 10更早的评论隐藏 10更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

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

12 个评论
显示 10更早的评论隐藏 10更早的评论