필터 지우기
필터 지우기

Open, Edit and Save Excel file with MATLAB

조회 수: 220 (최근 30일)
Suraj Srivastava
Suraj Srivastava 2015년 2월 18일
댓글: Shashank Rayaprolu 2017년 10월 20일
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에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by