Actxserver Excel - Manual Zoom Out Question

Question

1 vote

Hello Matlab community,

I have been trying to zoom out on my excel files and save it. Here is a simple example of what I am trying to accomplish. I want to zoom out to 75% the normal view and save that view by using actxserver. When I open the temp.xlsx file it is still at 100% for the zoom level. I assume I am missing a step, but have been unable to find anything when googling for help.

Thank you, -Michael

Matlab version: 2013a

Excel Version: 2010

xlswrite('temp.xlsx',[1])
Excel = actxserver('excel.application');
Workbook = Excel.Workbooks.Open(strcat(pwd,'\','temp.xlsx'));
mySheet = Workbook.ActiveSheet;
mySheet.PageSetup.Zoom=75;
Workbook.Save();
Workbook.Close;
Excel.Quit;