C#前期绑定和后期绑定操作Excel-------实现简单打印功能

来源：互联网发布：淘宝店装修模板下载编辑：程序博客网时间：2024/05/22 03:19

1，前期绑定

前期绑定需要引用Microsoft.Office.Interop.Excel.dll，代码有提示功能，编写方便，且代码量小。但是和具体的office版本密切相关，不同版本的Excel可能会出现不兼容。

using System;using System.Collections.Generic;using System.Text;using Excel = Microsoft.Office.Interop.Excel;namespace ExcelCsharpTest{    class ExcelPrintNomal    {        public void PrintOut(string excelFileName)        {            object Missing = System.Reflection.Missing.Value;            Excel.Application objExcel = null;            Excel.Workbooks objWorkbooks = null;            Excel.Workbook objWorkbook = null;            Excel.Worksheet objWorkSheet = null;            try            {                objExcel = new Microsoft.Office.Interop.Excel.Application();            }            catch            {                throw new Exception("没有安装Microsoft Office Excel。");            }            if (!System.IO.File.Exists(excelFileName))            {                throw new Exception("Excle文件不存在。");            }            try            {                objExcel.DisplayAlerts = false;                objExcel.WindowState = Microsoft.Office.Interop.Excel.XlWindowState.xlMinimized;                objExcel.Visible = false;                objWorkbooks = objExcel.Workbooks;                objWorkbook = objExcel.Workbooks.Open(excelFileName, Missing, Missing, Missing, Missing, Missing, Missing, Missing,                                                      Missing, Missing, Missing, Missing, Missing, Missing, Missing);                objWorkSheet = (Excel.Worksheet)objWorkbook.Worksheets[1];                SetValue(objWorkSheet, 1, 1, "Cell_11");                SetValue(objWorkSheet, 1, 2, "Cell_12");                SetValue(objWorkSheet, 1, 3, "Cell_13");                objWorkSheet.PrintOut(Missing, Missing, 1, Missing, Missing, Missing, true, Missing);            }            catch (Exception ex)            {                throw ex;            }            finally            {                ReleaseComObj(objWorkSheet);                if (objWorkbook != null)                {                    objWorkbook.Close(false, Missing, Missing);                    ReleaseComObj(objWorkbook);                }                if (objWorkbooks != null)                {                    objWorkbooks.Close();                    ReleaseComObj(objWorkbooks);                }                if (objExcel != null)                {                    objExcel.Quit();                    ReleaseComObj(objExcel);                }                System.GC.Collect();            }        }        public void SetValue(Excel.Worksheet sheet, int row, int col, object value)        {            object cell;            Excel.Range range;            cell = sheet.Cells[row, col];            range = sheet.get_Range(cell, cell);            range.Value2 = value;            ReleaseComObj(cell);            ReleaseComObj(range);        }        public void ReleaseComObj(object objCom)        {            if (objCom != null)            {                System.Runtime.InteropServices.Marshal.ReleaseComObject(objCom);                objCom = null;            }        }    }}

2，后期绑定

后期绑定，利用反射实现。不需引用dll，也和机器上安装的office版本无关，excel2003，excel2007都能正常运行。灵活性很强，但是可以看出代码不够方便，编写量也比前期绑定稍大。

using System;using System.Collections.Generic;using System.Text;using Excel = Microsoft.Office.Interop.Excel;namespace ExcelCsharpTest{    class ExcelPrint    {        public  void PrintOut(string excelFileName)        {            object Missing = System.Reflection.Missing.Value;            object objExcel = null;            object objWorkbooks = null;            object objWorkbook = null;            object objWorkSheet = null;            object[] parameters = null;            try            {                objExcel = Activator.CreateInstance(Type.GetTypeFromProgID("Excel.Application"));            }            catch            {                throw new Exception("没有安装Microsoft Office Excel。");            }            if (!System.IO.File.Exists(excelFileName))            {                throw new Exception("Excle文件不存在。");            }            try            {                const int xlMinimized = -4140;                parameters = new object[1];                parameters[0] = false;                objExcel.GetType().InvokeMember("DisplayAlerts", System.Reflection.BindingFlags.SetProperty, null, objExcel, parameters);                parameters = new object[1];                parameters[0] = xlMinimized;                objExcel.GetType().InvokeMember("WindowState", System.Reflection.BindingFlags.SetProperty, null, objExcel, parameters);                parameters = new object[1];                parameters[0] = false;                objExcel.GetType().InvokeMember("Visible", System.Reflection.BindingFlags.SetProperty, null, objExcel, parameters);                objWorkbooks = objExcel.GetType().InvokeMember("WorkBooks", System.Reflection.BindingFlags.GetProperty, null, objExcel, null);                parameters = new object[1];                parameters[0] = excelFileName;                objWorkbook = objWorkbooks.GetType().InvokeMember("Open", System.Reflection.BindingFlags.InvokeMethod, null, objWorkbooks, parameters);                parameters = new object[1];                parameters[0] = 1;                objWorkSheet = objWorkbook.GetType().InvokeMember("Worksheets", System.Reflection.BindingFlags.GetProperty, null, objWorkbook, parameters);                SetValue(objWorkSheet, 1, 1, "Cell_11");                SetValue(objWorkSheet, 1, 2, "Cell_12");                SetValue(objWorkSheet, 1, 3, "Cell_13");                parameters = new object[8];                parameters[0] = Missing;                parameters[1] = Missing;                parameters[2] = 1;                parameters[3] = Missing;                parameters[4] = Missing;                parameters[5] = Missing;                parameters[6] = true;                parameters[7] = Missing;                objWorkSheet.GetType().InvokeMember("PrintOut", System.Reflection.BindingFlags.InvokeMethod, null, objWorkSheet, parameters);            }            catch(Exception ex)            {                throw ex;            }            finally            {                ReleaseComObj(objWorkSheet);                if (objWorkbook != null)                {                    objWorkbook.GetType().InvokeMember("Close", System.Reflection.BindingFlags.InvokeMethod, null, objWorkbook, null);                    ReleaseComObj(objWorkbook);                }                if (objWorkbooks != null)                {                    objWorkbooks.GetType().InvokeMember("Close", System.Reflection.BindingFlags.InvokeMethod, null, objWorkbooks, null);                    ReleaseComObj(objWorkbooks);                }                if (objExcel != null)                {                    objExcel.GetType().InvokeMember("Quit", System.Reflection.BindingFlags.InvokeMethod, null, objExcel, null);                    ReleaseComObj(objExcel);                }                System.GC.Collect();            }        }        public void SetValue(object sheet, int row, int col, object value)        {            object[] parms = null;            parms = new object[2];            parms[0] = row;            parms[1] = col;            object cell = sheet.GetType().InvokeMember("Cells", System.Reflection.BindingFlags.GetProperty, null,sheet, parms);            parms = new object[1];            parms[0] = value;            cell.GetType().InvokeMember("Value", System.Reflection.BindingFlags.SetProperty, null, cell, parms);            ReleaseComObj(cell);        }        public void ReleaseComObj(object objCom)        {            if (objCom != null)            {                System.Runtime.InteropServices.Marshal.ReleaseComObject(objCom);                objCom = null;            }        }    }}

调用代码：

            ExcelPrint excelPrint = new ExcelPrint();            excelPrint.PrintOut("C:\\Book1.xls");            ExcelPrintNomal excelPrintNomal = new ExcelPrintNomal();            excelPrintNomal.PrintOut("C:\\Book1.xls");