方法壹:matlab控件:結果圖,符合妳的要求:而且能直接在圖上改數據,也能保存。
代碼如下:
clear?
close
clc
%%
h_figure?=?figure('units','normalized','position',[0.05?0.05?0.8?0.8],'tag','Table');
idata?=?guihandles(gcf);
[data,dataTitle]?=?xlsread('template.xlsx');
columnName?= dataTitle;
columnFormat?=?{'numeric',?'numeric',?'numeric','numeric','numeric','numeric'};?
columnEditable?=?[true?true?true?true?true?true];?
tableData?=?uitable('Units','normalized','Position',...
[0.1?0.1?0.9?0.7],?'Data',?data,'tag','table',...?
'ColumnName',?columnName,...
'ColumnFormat',?columnFormat,...
'ColumnEditable',?columnEditable);
%%
uicontrol('style','pushbutton','string','Save',...
'parent',idata.Table,'units','normalized',...
'position',[0.55?0.8?0.1?0.1],'tag','button',...
'callback',@button_callback);
%%
newData?=?get(tableData,'Data');
另外定義了壹個函數
function?button_callback(obj,event)
data?=?guidata(gcbf);
guidata(gcbf,data);
end
方法二:matlab代碼
h?=?uitable('data',?[86?4?3.7?14.8;
65?4?1.5?6;
94?5.5?4?22;
60.5?4?1?4;
84?4?3.3?13.2;
70?4?2?8],?'Position',?[200?100?400?200]);
直接copy運行,即可出圖