Xuất báo cáo bằng Excel

Sử dụng:

using Microsoft.Office.Interop;

using Microsoft.Office.Interop.Excel;

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

        Workbook xlWorkbook;

        Worksheet xlWorkSheet;

        

        private void buttonX1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection(Properties.Settings.Default.ConnectString);

            con.Open();

            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Diem", con);

            System.Data.DataTable dt = new System.Data.DataTable();

            da.Fill(dt);

            xlWorkbook = xlApp.Workbooks.Open("E:\\abc.xlsx");

            xlWorkSheet = xlWorkbook.Sheets.get_Item("GHP");// tên sheet

            xlApp.Visible = true;

            xlWorkSheet.Activate();

            int j = 13;

            for (int i = 0; i < dt.Rows.Count;i++)

                {

                    xlWorkSheet.Range["A" + j].Value = i + 1;// chèn dữ liệu vào Ô Aj trong excel

                    xlWorkSheet.Range["B" + j].Value = dt.Rows[i][1];//

                    xlWorkSheet.Range["C" + j].Value = dt.Rows[i][0];

                    xlWorkSheet.Range["D" + j].Value = dt.Rows[i][2];

                    j++;

                    xlWorkSheet.Range["A" + j].EntireRow.Insert(XlInsertShiftDirection.xlShiftDown);// chèn 1 hàng rỗng vào dưới hàng j

                    xlWorkSheet.Range["A" + j].EntireRow.Select();

                    //xlWorkSheet.HPageBreaks.Add(xlWorkSheet.Range["A" + j]);

                }

          

        }