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]);
}
}
