Actxserver Excel - Manual Zoom Out Question

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;

Answer 1

[sai kumar]

Excel.ActiveWindow.Zoom = 75;

this might help you