How do I change the save file format in excel using activeX in Matlab
조회 수: 7 (최근 30일)
이전 댓글 표시
I currently have the following code.
file = 'C:\example\somefile.xlsx';
sheet = 'Sheet1'; %can be name or numeric index
row = 1;
excel = actxserver('Excel.Application');
workbook = excel.Workbooks.Open(file);
worksheet = workbook.Worksheets.Item(sheet);
worksheet.Rows.Item(row).Delete;
workbook.Save;
excel.Quit;
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
I want to change the default
"Save files in this format" : Excel Workbook (*.xlsx)
to
"Save files in this format" : CSV (Comma delimited)(*.csv)
댓글 수: 0
답변 (3개)
Fangjun Jiang
2019년 1월 16일
편집: Fangjun Jiang
2019년 1월 16일
Worked like a charm, in R2018b, MS Office 2016.
file = 'Book1.xlsx';
sheet = 'Sheet1';
excel = actxserver('Excel.Application');
workbook = excel.Workbooks.Open(fullfile(pwd,file));
worksheet = workbook.Worksheets.Item(sheet);
xlCSV=6; %this constant is defined by MS Excel
ExcelApp.DisplayAlerts=false;% ignore prompt
workbook.SaveAs(fullfile(pwd,'Book2'),xlCSV);
excel.Quit;
댓글 수: 3
Fangjun Jiang
2019년 1월 16일
I don't know if you can change the default save option. But the statement ExcelApp.DisplayAlerts=false will get rid of that pop dialog.
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!