int sutun = 1;
int satir = 1;
Excel.Application ExcelApp = new Excel.Application();
ExcelApp.Workbooks.Add();
ExcelApp.Visible = true;
ExcelApp.Worksheets[1].Activate();
for (int j = 0; j < dataGridView3.Columns.Count; j++)
{
ExcelApp.Cells[satir, sutun + j].Value = dataGridView3.Columns[j].HeaderText;
ExcelApp.Cells[satir, sutun + j].Font.Color = System.Drawing.Color.Black; //Yazı Rengi
ExcelApp.Cells[satir, sutun + j].Interior.Color = System.Drawing.Color.LightGoldenrodYellow; //Arka Plan Rengi
ExcelApp.Cells[satir, sutun + j].Font.Bold = true; //Yazı Bold
ExcelApp.Cells[satir, sutun + j].Font.Size = 9; //Yazı Size
ExcelApp.Cells[satir, sutun + j].ColumnWidth = 18; //Colon Genişliği
ExcelApp.Cells[satir, sutun + j].Font.Name = "Arial Black";
}
for (int i = 0; i < dataGridView3.Rows.Count; i++)
{
for (int j = 0; j < dataGridView3.Columns.Count; j++)
{
ExcelApp.Cells[satir + i, sutun + j].Value = dataGridView3[j, i].Value;
}
for (int j = 0; j < dataGridView3.Columns.Count; j++)
{
ExcelApp.Cells[satir + i, sutun + j].Value = dataGridView3[j, i].Value;
try
{
if (dataGridView3[j, i].Value.ToString() == "DEPREM BÖLGESİ")
{
for (int k = 1; k <= dataGridView3.Columns.Count; k++)
{
ExcelApp.Cells[satir + i, k].Interior.Color = System.Drawing.Color.FromArgb(255, 0, 0);
}
}
}
catch (Exception)
{
this.Text = "Sorun ";
}
try
{
if (dataGridView3[j, i].Value.ToString() == "GÜVENLİ BÖLGE")
{
for (int k = 1; k <= dataGridView3.Columns.Count; k++)
{
ExcelApp.Cells[satir + i, k].Interior.Color = System.Drawing.Color.FromArgb(31, 255, 42);
}
}
}
catch (Exception)
{
this.Text += "Çözülüyor";
}
}
}
Kolonlarıda Aktarmısını İstiyorum Olmuyor.Nerde Hata Yapıyorum
