Open, Edit and Save Excel file with MATLAB
221 次查看(过去 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.
0 个评论
采纳的回答
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 个评论
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 Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!