필터 지우기
필터 지우기

ActiveX -- Saving Excel File

조회 수: 5 (최근 30일)
Jonathan Roy
Jonathan Roy 2015년 7월 8일
Hi!
I have an excell sheet who auto refresh data from web when I open it. I want to open the file, save it and close.
I can open, and close but not able to save it...
this is my code
% Create object.
ExcelApp = actxserver('Excel.Application');
ExcelApp.Visible = 0;
% Open file located in the current folder.
ExcelApp.Workbooks.Open(fullfile(pwd,'\Niveaux.xlsx'));
% Make the first sheet active.
eSheets = ExcelApp.ActiveWorkbook.Sheets;
eSheet1 = eSheets.get('Item', 1);
eSheet1.Activate;
ExcelApp.Saved=1;
ExcelApp.Quit;
ExcelApp.release;
I try many things but dont find a good solution... Thank guys for your help
Matlab R2013a,

답변 (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