C#调取打印机打印DataTable

一、新建一个PrintService类,将打印的方法封装起来

public class PrintService
    {
        public PrintService()
        {

        }

        #region Members //成员
        public String printName = String.Empty;
        public Font prtTextFont = new Font("Verdana", 16);
        public Font prtTitleFont = new Font("宋体", 16);
        private String[] titles = new String[0];
        public String[] Titles
        {
            set
            {
                titles = value as String[];
                if (null == titles)
                {
                    titles = new String[0];
                }
            }
            get
            {
                return titles;
            }
        }
        private Int32 left = 20;
        private Int32 top = 20;
        public Int32 Top { set { top = value; } get { return top; } }
        public Int32 Left { set { left = value; } get { return left; } }
        private DataTable printedTable;
        private Int32 pheight;
        private Int32 pWidth;
        private Int32 pindex;
        private Int32 curdgi;
        private Int32[] width;
        private Int32 rowOfDownDistance = 3;
        private Int32 rowOfUpDistance = 2;

        Int32 startColumnControls = 0;
        Int32 endColumnControls = 0;

        #endregion

        #region Method for PrintDataTable //打印数据集
        /// <summary>
        /// 打印数据集
        /// </summary>
        /// <param name="table">数据集</param>
        /// <returns></returns>
        public Boolean PrintDataTable(DataTable table)
        {
            PrintDocument prtDocument = new PrintDocument();
            try
            {
                if (printName != String.Empty)
                {
                    prtDocument.PrinterSettings.PrinterName = printName;
                }
                //prtDocument.DefaultPageSettings.Landscape = true;//设置打印方向为横向
                prtDocument.OriginAtMargins = false;
                PrintDialog prtDialog = new PrintDialog();
                prtDialog.AllowSomePages = true;
                prtDialog.ShowHelp = false;
                prtDialog.Document = prtDocument;
                if (DialogResult.OK != prtDialog.ShowDialog())
                {
                    return false;
                }
                printedTable = table;
                pindex = 0;
                curdgi = 0;
                width = new Int32[printedTable.Columns.Count];
                pheight = prtDocument.PrinterSettings.DefaultPageSettings.Bounds.Bottom + 400;
                //pheight = prtDocument.PrinterSettings.DefaultPageSettings.Bounds.Bottom;
                pWidth = prtDocument.PrinterSettings.DefaultPageSettings.Bounds.Right;
                prtDocument.PrintPage += new PrintPageEventHandler(docToPrint_PrintPage);
                prtDocument.Print();
            }
            catch (InvalidPrinterException ex)
            {
                MessageBox.Show("没有安装打印机");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            prtDocument.Dispose();
            return true;
        }
        #endregion

        #region Handler for docToPrint_PrintPage //设置打印机开始打印的事件处理函数
        /// <summary>
        /// 设置打印机开始打印的事件处理函数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ev"></param>
        private void docToPrint_PrintPage(object sender,
         System.Drawing.Printing.PrintPageEventArgs ev)//设置打印机开始打印的事件处理函数
        {
            Int32 x = left;
            Int32 y = top;
            Int32 rowOfTop = top;
            Int32 i;
            Pen pen = new Pen(Brushes.Black, 1);
            if (0 == pindex)
            {
                for (i = 0; i < titles.Length; i++)
                {
                    ev.Graphics.DrawString(titles[i], prtTitleFont, Brushes.Black, left, y + rowOfUpDistance);
                    y += prtTextFont.Height + rowOfDownDistance;
                }
                rowOfTop = y;
                foreach (DataRow dr in printedTable.Rows)
                {
                    for (i = 0; i < printedTable.Columns.Count; i++)
                    {
                        Int32 colwidth = Convert.ToInt16(ev.Graphics.MeasureString(dr[i].ToString().Trim(), prtTextFont).Width);
                        if (colwidth > width[i])
                        {
                            width[i] = colwidth;
                        }
                    }
                }
            }
            for (i = endColumnControls; i < printedTable.Columns.Count; i++)
            {
                String headtext = printedTable.Columns[i].ColumnName.Trim();
                if (pindex == 0)
                {
                    int colwidth = Convert.ToInt16(ev.Graphics.MeasureString(headtext, prtTextFont).Width);
                    if (colwidth > width[i])
                    {
                        width[i] = colwidth;
                    }
                }
                //判断宽是否越界
                if (x + width[i] > pheight)
                {
                    break;
                }
                ev.Graphics.DrawString(headtext, prtTextFont, Brushes.Black, x, y + rowOfUpDistance);
                x += width[i];
            }
            startColumnControls = endColumnControls;
            if (i < printedTable.Columns.Count)
            {
                endColumnControls = i;
                ev.HasMorePages = true;
            }
            else
            {
                endColumnControls = printedTable.Columns.Count;
            }
            ev.Graphics.DrawLine(pen, left, rowOfTop, x, rowOfTop);
            y += rowOfUpDistance + prtTextFont.Height + rowOfDownDistance;
            ev.Graphics.DrawLine(pen, left, y, x, y);
            //打印数据
            for (i = curdgi; i < printedTable.Rows.Count; i++)
            {
                x = left;
                for (Int32 j = startColumnControls; j < endColumnControls; j++)
                {
                    ev.Graphics.DrawString(printedTable.Rows[i][j].ToString().Trim(), prtTextFont, Brushes.Black, x, y + rowOfUpDistance);
                    x += width[j];
                }
                y += rowOfUpDistance + prtTextFont.Height + rowOfDownDistance;
                ev.Graphics.DrawLine(pen, left, y, x, y);
                //判断高是否越界
                if (y > pWidth - prtTextFont.Height - 400) //if (y > pWidth - prtTextFont.Height - 30)
                {
                    break;
                }
            }
            ev.Graphics.DrawLine(pen, left, rowOfTop, left, y);
            x = left;
            for (Int32 k = startColumnControls; k < endColumnControls; k++)
            {
                x += width[k];
                ev.Graphics.DrawLine(pen, x, rowOfTop, x, y);
            }
            //判断高是否越界
            if (y > pWidth - prtTextFont.Height - 400) //if (y > pWidth - prtTextFont.Height - 30) 
            {
                pindex++; if (0 == startColumnControls)
                {
                    curdgi = i + 1;
                }
                if (!ev.HasMorePages)
                {
                    endColumnControls = 0;
                }
                ev.HasMorePages = true;
            }
        }
        #endregion
    }

二、调用PrintService打印表格

 private void btnPrint_Click(object sender, EventArgs e)
        {
            PrintService ps = new PrintService();
            String name = "打印示例";
            ps.Titles = new string[] { name };//给打印的表格赋值名字
            
            DataTable dt=new DataTable(); 
            dt.Columns.Add("姓名",typeof(string));   //新建第一列
            dt.Columns.Add("年龄",typeof(int));      //新建第二列
            dt.Rows.Add("张三",23);                 //新建第一行,并赋值
            dt.Rows.Add("李四",25);                 //新建第二行,并赋值
            ps.PrintDataTable(dt);
        }
C#中,要让程序通过指定的打印机打印Excel文件(.xls或.xlsx),你需要使用`System.Printing`命名空间中的功能,结合第三方库如EPPlus (for .xlsx) 或 NPOI (for .xls) 来读取和操作Excel文件。以下是一个简单的步骤: 1. **添加依赖**: - 对于`.xlsx`文件,你需要安装EPPlus库:`Install-Package EPPlus` - 对于`.xls`文件,可以使用NPOI:`Install-Package NPOI` 2. **读取并转换Excel内容**: 使用EPPlus或NPOI打开Excel文件,选择需要打印的工作表,并将其数据读取到内存中的DataTable或其他适合的数据结构。 ```csharp using OfficeOpenXml; // 或者 using NPOI.SS.UserModel; // 示例1 (EPPlus) FileInfo fileInfo = new FileInfo("path_to_your_excel_file.xlsx"); using (var package = new ExcelPackage(fileInfo)) { ExcelWorksheet worksheet = package.Workbook.Worksheets[0]; DataTable data = worksheet.Cells.Cast<Range>().Select(cell => cell.Value).ToList(); } // 示例2 (NPOI) FileInfo fileInfo = new FileInfo("path_to_your_excel_file.xls"); IXLSWorkbook workbook = new HSSFWorkbook(fileInfo); IXLSWorksheet sheet = workbook.GetSheetAt(0); ``` 3. **创建PrintDocument或PrinterSettings**: 创建一个`PrintDocument`实例,或者设置`PrinterSettings`对象,指定你想使用的打印机。 ```csharp PrintDocument printDoc = new PrintDocument(); // 设置打印机 printDoc.DefaultPageSettings.PrinterName = "Your Printer Name"; ``` 4. **处理PrintPage事件**: 实现`PrintDocument`的`OnPrintPage`方法,在这里将Excel数据画到页面上。 ```csharp private void printDoc_PrintPage(object sender, PrintPageEventArgs e) { // 将数据渲染到e.Graphics对象上 // 使用EPPlus: foreach (var row in data.Rows) { var x = e.MarginBounds.Left; var y = e.MarginBounds.Top + e.YOffset; // 确保每次开始绘制在新的一行 for (int i = 0; i < row.Count; i++) { e.Graphics.DrawString(row[i].ToString(), font, Brushes.Black, x, y); y += font.Height; } } // 使用NPOI: // ... 类似地遍历sheet并绘制数据 } ``` 5. **打印**: 添加打印事件处理器并开始打印。 ```csharp printDoc.Print(); ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值