Kod:
for (int i = 2; i < dataGridView1.Columns.Count + 1 - 2; i++) // Başlık
{
worksheet.Cells[2, i] = dataGridView1.Columns[i - 1].HeaderText;
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) // Alınan Veriler.
{
for (int j = 1; j < dataGridView1.Columns.Count -2; j++) // Alınan Verilerden, Kayıt Tarihi ve Yetki Durumunu Alma ( -2 )
{
worksheet.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); // j + 2 Sütün Kaydırma
}
}
worksheet.get_Range("A1", "G1").Font.Bold = true;
worksheet.get_Range("A1", "A250").Font.Bold = true;
worksheet.get_Range("C2", "G250").VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
worksheet.get_Range("C2", "G250").HorizontalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
worksheet.get_Range("A1", "G1").VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
worksheet.get_Range("A1", "G1").HorizontalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
worksheet.get_Range("A1", i).Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;
workbook.SaveAs(save.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
}