基于matlabMATLAB与Excel交互

% 直接数据交互 data = xlsread('C:\Users\李鹏\Desktop\新建 Microsoft Office Excel 工作表.xlsx'); data1 = [1 2 3; 4 5 6]; xlswrite('data1.xlsx', data1); % MATLAB作为自动化客户端调用Excel服务器 % Open OLE server he = actxserver('Excel.Application'); he.Visible = 1; % Create Workbooks hw = he.Workbooks.Add; % get Worksheets and actived one sheet hs = hw.Worksheets; hs1 = Item(hs, 1); % Write a number to Excel hr = hs1.Range('A1'); hr.Value = 1; % Write numbers hr2 = hs1.Range('A1:A10'); hr2.Value = randint(10, 1); % Plot hshape = hs1.Shapes; hchart = hshape.AddChart(hr2); theChart = hchart.Chart; set(theChart, 'ChartType', 'xlLine'); % Plot 2 plot(randint(10, 1)); hgexport(gcf, '-clipboard'); hs1.Range('C3').PasteSpecial; thefigure = Item(hshape, 2); IncrementLeft(thefigure, 10); IncrementTop(thefigure, 10); % Save and Quit hw.SaveAs('a.xlsx'); he.Quit;