Open, Edit and Save Excel file with MATLAB

75 次查看(过去 30 天)
Hi,
I want following thing to be done with the help of MATLAB:-
1) Open an Excel file 2) Fill some data in Excel file cells 3) Save that file.
Again I need it through MATLAB.
Kindly help me out.

采纳的回答

Julia
Julia 2015-2-18
Hi,
I did it like this:
1. Write data into the excel file (OutputTest) with xlswrite (it starts in cell F1 in Excel):
xlswrite('OutputTest',data,'Output','F1');
2. Edit the data. Therefore open the excel application (I think you can also use this technique to write your data if you do not want to use xlswrite):
e=actxserver('excel.application');
eW=e.Workbooks;
filename=[pwd '\OutputTest.xls'];
eF=eW.Open(filename); % open OutputTest.xls
eS=eF.ActiveSheet;
% edit sheet
eS.Range('A1:Q1').EntireColumn.AutoFit;
eS.Range('A1').EntireRow.Font.Bold=1;
eF.Save;
eF.Close; % close the file
e.Quit; % close Excel entirely
  4 个评论
Suraj Srivastava
Suraj Srivastava 2015-2-20
Thank you Julia,
I have achieved this task, by implementing macro in excel file.
Again thank you so much.
Shashank Rayaprolu
Shashank Rayaprolu 2017-10-20
Hi, May I know how you did that??
1. I want my MATLAB code to open an excel.
2. then I want to manuall fill the excel sheet.
3. I want MATLAB to read that excel and then do other operations.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

Translated by