C#下面调用 Excel 打印代码

最新推荐文章于 2023-01-12 22:01:06 发布

游陆

最新推荐文章于 2023-01-12 22:01:06 发布

阅读量4.1k

点赞数

本文链接：https://blog.csdn.net/hanghwp/article/details/1587723

版权

这篇博客展示了如何在C#中使用Excel应用程序对象来创建一个新的工作簿，填充数据并设置格式，最后进行打印预览。代码涉及到表格标题设置、数据填入、单元格格式调整、页边距和打印设置等。

摘要由CSDN通过智能技术生成

private void btnPrintData_Click(object sender, EventArgs e)
        {
            Excel.Application xlsApp = new Excel.Application();
            Excel._Workbook xlsBook = xlsApp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
            Excel._Worksheet xlsSheet = (Excel._Worksheet)xlsBook.Worksheets[1];
            xlsSheet.Activate();

            xlsApp.Caption = lblDMMC.Text + "断面实测成果表 - 打印预览 ";
            DataTable myDT1,myDT2;

            myDT1 = datatable(a,a1);
            myDT2 = datatable(a,a1);

            string[] strColName = new string[] { "起点距m", "河底高程m", "起点距m", "河底高程m", "起点距m", "河底高程m", "起点距m", "河底高程m", "起点距m", "河底高程m", "起点距m", "河底高程m", "" };
            int intCols = strColName.Length - 1;
            int intRows = myDT1.Rows.Count;

           // int[] intRows1 = new int[myDT1.Rows.Count];
          // int[] intcols1 = new int[myDT1.Columns.Count];

            int minrow=0;
            int mincol=0;
            xlsSheet.Cells[2, intCols + 1] = "制";
            xlsSheet.Cells[3, intCols + 1] = "表";
            xlsSheet.Cells[4, intCols + 1] = "：";
            xlsSheet.Cells[7, intCols + 1] = "一";
            xlsSheet.Cells[8, intCols + 1] = "校";
            xlsSheet.Cells[9, intCols + 1] = "：";
            xlsSheet.Cells[12, intCols + 1] = "二";
            xlsSheet.Cells[13, intCols + 1] = "校";
            xlsSheet.Cells[14, intCols +