冠霖的部落格

      private void button1_Click(object sender, EventArgs e)
        ...{
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            ...{
                Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
                Microsoft.Office.Interop.Excel.Worksheet excelWs;
                Microsoft.Office.Interop.Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(openFileDialog1.FileName,
                Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing);
 
                excelWs = (Microsoft.Office.Interop.Excel.Worksheet)excelWorkbook.Worksheets.get_Item(1);//取得第一個sheet
 
                設定小大位置#region 設定小大位置
                excelWs.Cells.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignTop; //垂直調準
                excelWs.Cells.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;//水平調準
                excelWs.Cells.EntireRow.AutoFit(); //自動調整列高
                excelWs.Cells.EntireColumn.AutoFit(); //自動調整欄寬
                #endregion
 
                設定顏色#region 設定顏色
                excelWs.get_Range("B:B", Type.Missing).Font.Color = 255;
                excelWs.get_Range("D:D", Type.Missing).Font.Color = 255;
                excelWs.get_Range("E:J", Type.Missing).Font.Color = 255;
                #endregion
 
                調整儲存格格式#region 調整儲存格格式
                excelWs.get_Range("B:B", Type.Missing).NumberFormatLocal = "@";
                excelWs.get_Range("E:F", Type.Missing).NumberFormatLocal = "@";
                excelWs.get_Range("I:J", Type.Missing).NumberFormatLocal = "@";
                #endregion
 
                ClearCom(excelWs);
                excelWorkbook.Close(true, Type.Missing, Type.Missing);
 
                ClearCom(excelWorkbook);
                excelApp.Workbooks.Close();
                excelApp.Quit();
                ClearCom(excelApp);
 
                excelWs = null;
                excelWorkbook = null;
                excelApp = null;
                MessageBox.Show("設定完成");
            }
        }
 
        static void ClearCom(object o)
        ...{
            try
            ...{
                System.Runtime.InteropServices.Marshal.ReleaseComObject(o);
            }
            catch ...{ }
            finally
            ...{
                o = null;
            }
        }