//创建Application对象
Excel.Application xApp = new Excel.ApplicationClass(); xApp.Visible = false;
Excel.Workbook xBook = xApp.Workbooks._Open(@"C:\ceshi.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value); Excel.Worksheet xSheet = (Excel.Worksheet)xApp.Sheets["测试"]; // 冻结窗口A2
if (xApp.ActiveWindow.FreezePanes == false)
{
Excel.Range ran = xSheet.get_Range("A2", "A2");
ran.Select();
xApp.ActiveWindow.FreezePanes = true;
} xBook.Save();
xBook.Close(true, Missing.Value, Missing.Value);
xSheet = null;
xBook = null;
xApp.Quit();
xApp = null;
Excel.Application xApp = new Excel.ApplicationClass(); xApp.Visible = false;
Excel.Workbook xBook = xApp.Workbooks._Open(@"C:\ceshi.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value); Excel.Worksheet xSheet = (Excel.Worksheet)xApp.Sheets["测试"]; // 冻结窗口A2
if (xApp.ActiveWindow.FreezePanes == false)
{
Excel.Range ran = xSheet.get_Range("A2", "A2");
ran.Select();
xApp.ActiveWindow.FreezePanes = true;
} xBook.Save();
xBook.Close(true, Missing.Value, Missing.Value);
xSheet = null;
xBook = null;
xApp.Quit();
xApp = null;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货