問題自己解決了.方法如下(順便增加一個凍結窗口的寫法)
//鎖定某一行,即凍結窗口
Application.get_Range ("A2",Type.Missing ).Select ();
Application.ActiveWindow .FreezePanes = true;
// //分頁預覽
Application.ActiveWindow .View = Excel.XlWindowView .xlPageBreakPreview ;
Application.ActiveWindow .Zoom = 100;
转载于:https://www.cnblogs.com/kingjiong/archive/2008/12/30/1365189.html