필터 지우기
필터 지우기

Problem on acessing excel by activeX command in Matlab

조회 수: 2 (최근 30일)
Bibi
Bibi 2014년 6월 24일
댓글: Bibi 2014년 7월 8일
I tested code below
Excel = actxserver('Excel.Application');
set(Excel,'Visible',1);
Workbooks = Excel.Workbooks.Open('C:\Users\Bibi\Documents\MATLAB\New Microsoft Excel Worksheet.xlsx');
Excel.Worksheets.Add
Then I found I successfully added a new sheet "sheet2" before "sheet1"
Actually, one can arrange the order of the sheet by adding count and before just as below,
Worksheets.Add *Count:=2, Before:=Sheets(1)
But how to add "Count" and "Before" in matlab language, I tried many times but all failed.

채택된 답변

Tejas M U
Tejas M U 2014년 6월 30일

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