C#下面调用 Excel 打印代码

2022-07-15 80酷酷网 80kuku.com

　　excel|打印

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 + 1] = "：";
            xlsSheet.Cells[17, intCols + 1] = "验";
            xlsSheet.Cells[18, intCols + 1] = "收";
            xlsSheet.Cells[19, intCols + 1] = "：";
            xlsSheet.Cells[1, 3] = "施测日期：" + dtpS3.Text;
            xlsSheet.Cells[1, 7] = "测探工具：" + txtCtgongju.Text;
            xlsSheet.Cells[1, 10] = "水位：" + txtS4.Text + "m";
            // xlsSheet.Cells[1, intCols] = "制表：";

            for (int j = 0; j < intCols; j++)
            {
                xlsSheet.Cells[2, j + 1] = strColName[j];
            }

            for (int i = 0; i < intRows; i++)
            {
                for (int j = 0; j < intCols; j++)
                {
                    if (i == temprows2 && j == tempcols2)
                    {
                    myDT1.Rows[i][j]=myDT1.Rows[i][j].ToString()+"▲";
                    }

                    if (i == temprows1 && j == tempcols1)
                    {
                        myDT1.Rows[i][j] = myDT1.Rows[i][j].ToString() + "▼";
                    }

//myDT1.Rows[temprows3 + 3][tempcols3] = myDT1.Rows[temprows3 + 3][tempcols3] + " ";
// myDT1.Rows[temprows3 + 3][tempcols3 + 1] = myDT1.Rows[temprows3 + 3][tempcols3 + 1] + " ";

                 xlsApp.Cells[i + 3, j + 1] = myDT1.Rows[i][j];
                }
            }
            xlsSheet.Cells[intRows + 3, 9] = "附注：" + txtFuzhu.Text;
            xlsSheet.Columns.ColumnWidth = 9;
            xlsSheet.get_Range(xlsSheet.Cells[2, intCols + 1], xlsSheet.Cells[intRows + 2, intCols + 1]).ColumnWidth = 3;

xlsSheet.Rows.RowHeight = 18;
xlsSheet.get_Range(xlsSheet.Cells[2, 1], xlsSheet.Cells[2, intCols]).RowHeight = 15;

            xlsSheet.Cells.Font.Name = "宋体";
            xlsSheet.Cells.Font.Size = 10;
            xlsSheet.Cells.Font.Bold = false;
            xlsSheet.Cells.WrapText = false;
            xlsSheet.get_Range(xlsSheet.Cells[2, 1], xlsSheet.Cells[2, intCols]).Font.Name = "宋体";
            xlsSheet.get_Range(xlsSheet.Cells[2, 1], xlsSheet.Cells[2, intCols]).Font.Size = 10;
            xlsSheet.get_Range(xlsSheet.Cells[2, 1], xlsSheet.Cells[2, intCols]).Font.Bold = true;
            xlsSheet.get_Range(xlsSheet.Cells[2, 1], xlsSheet.Cells[2, intCols]).WrapText = false;

xlsSheet.get_Range(xlsSheet.Cells[temprows3 + 3, tempcols3 ], xlsSheet.Cells[temprows3 + 3, tempcols3+1]).Font.Underline = true;

            for (int i = 0; i < myDT2.Rows.Count; i++)
            {
                for (int j = 0; j < myDT2.Columns.Count; j++)
                {
                    double temp1;
                    if (myDT2.Rows[i][j].ToString() == "")
                    {
                        temp1 = 0.123456;
                    }
                    else
                    {
                        temp1 = Convert.ToDouble(myDT2.Rows[i][j].ToString());
                    }

                    if (j % 2 == 0)
                    {
                        if (temp1 == 0)
                        {
                            xlsSheet.Cells[i + 3, j + 1] = 0;
                        }
                        else if (temp1 == 0.123456)
                        {
                            xlsSheet.Cells[i + 3, j + 1] = "";
                        }
                        else
                        {
                            xlsSheet.get_Range(xlsSheet.Cells[i + 3, j + 1], xlsSheet.Cells[i + 3, j + 1]).NumberFormatLocal = "#####";
                        }
                    }
                    else
                    {
                        if (temp1 > 9)
                        {
                            xlsSheet.get_Range(xlsSheet.Cells[i + 3, j + 1], xlsSheet.Cells[i + 3, j + 1]).NumberFormatLocal = "#####.0";
                        }
                    }
                }
            }
            xlsSheet.Columns.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
            xlsSheet.Columns.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight;
            xlsSheet.get_Range(xlsSheet.Cells[1, intCols], xlsSheet.Cells[1, intCols]).HorizontalAlignment = Excel.XlHAlign.xlHAlignRight;

xlsSheet.get_Range(xlsSheet.Cells[2, 1], xlsSheet.Cells[intRows + 2, intCols]).Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
xlsSheet.get_Range(xlsSheet.Cells[2, 1], xlsSheet.Cells[intRows + 2, intCols]).Borders.Weight = Excel.XlBorderWeight.xlThin;

            //DGV.Columns["高程6"].DefaultCellStyle.Format = "####0.0";
            xlsSheet.PageSetup.CenterHeader = "&\"黑体\"&18" + lblDMMC.Text + " 断面实测成果表";
            //xlsSheet.PageSetup.CenterFooter = "&9----- 第 &P 页 -----";

            xlsSheet.PageSetup.PrintGridlines = false;
            //xlsSheet.get_Range(xlsSheet.Cells[1,1],xlsSheet.Cells[1,intCols]).Borders.LineStyle
            xlsSheet.PageSetup.LeftMargin = xlsApp.InchesToPoints(0.5);
            xlsSheet.PageSetup.RightMargin = xlsApp.InchesToPoints(0.5);
            xlsSheet.PageSetup.TopMargin = xlsApp.InchesToPoints(1.3);
            xlsSheet.PageSetup.BottomMargin = xlsApp.InchesToPoints(1.0);
            xlsSheet.PageSetup.HeaderMargin = xlsApp.InchesToPoints(0.9);
            xlsSheet.PageSetup.FooterMargin = xlsApp.InchesToPoints(0.6);
            xlsSheet.PageSetup.CenterHorizontally = true;
            xlsSheet.PageSetup.PaperSize = Excel.XlPaperSize.xlPaperA4;
            xlsSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape;
            Excel.Range getRange = xlsSheet.get_Range(xlsSheet.Cells[1, 1], xlsSheet.Cells[2, intCols]);
            xlsSheet.PageSetup.PrintTitleRows = getRange.get_Address(getRange.Row, getRange.Column, Excel.XlReferenceStyle.xlA1, 1, 1);

            xlsApp.Visible = true;
            xlsSheet.PrintPreview(true);
            xlsBook.Saved = true;
            xlsApp.Workbooks.Close();
            xlsApp.Visible = false;
            xlsApp.Quit();
        }