打印Excel表

最新推荐文章于 2020-01-15 15:37:49 发布

MasDn

最新推荐文章于 2020-01-15 15:37:49 发布

阅读量1k

点赞数 1

文章标签： excel application system string class 工具

本文链接：https://blog.csdn.net/MasDn/article/details/975976

版权

using System;
using System.Collections.Generic;
using System.Text;
using Excel;

//在引用中添加Excel组件的引用，Excel2003的好象需要先用VS.NET命令工具

//将Excel2003安装目录下的Excel.exe转化为Excel.dll 命令是：tlbimp Excel.exe 的路径

//生成的Excel.dll在VS.NET的安装目录下找不到就用搜索的去找吧，具体路径因安装不同而不同

namespace PrintExcel
{
    class PrintClass
    {
        Excel.Application App = new Application();
        /// <summary>
        /// 打印方法
        /// </summary>
        /// <param name="filepath">文件路径</param>
        /// <param name="Number">要打印的份数</param>
        public void Print(string filepath,int Number)
        {
            try
            {
                App.Workbooks.Open(filepath,
                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);
            }
            catch
            {
                App.Workbooks.Open(filepath,
                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);
            }
            Excel.Sheets sheets = App.Worksheets;

            int   SheetsCount=sheets.Count;     //sheets数量
            Excel._Worksheet   objSheet;

            for(int   i=1;i<SheetsCount+1;++i)
            {
                objSheet = (Excel._Worksheet)sheets.get_Item(i);
                //objSheet.PrintPreview(false);
                objSheet.PrintOut(Type.Missing, Type.Missing, Number, false, Type.Missing, false, false, Type.Missing);
            }

}
}
}