private void Export()
{
try
{
Microsoft.Office.Interop.Excel.Application excelapp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook excelbook = excelapp.Workbooks.Add(XlSheetType.xlWorksheet);
Microsoft.Office.Interop.Excel.Worksheet excelworksheet = (Worksheet)(excelbook.Worksheets[1]);
excelworksheet.DisplayRightToLeft = true;
for (int j = 0; j < dataGridView1.Columns.Count; j++)
{
Range da= excelworksheet.get_Range("A1", "A1");
rng1.Value2 = "ردیف";
rng1.Font.Bold = true;
}
ProgressBar1.Maximum = dataGridView1.RowCount;
ProgressBar1.Visible = true;
for (int i = 2; i < dataGridView1.RowCount; i++)
{
string s = i.ToString();
Range r1 = excelworksheet.get_Range("A" + s, "A" + s);
r1.Value2 = dataGridView1.Rows[i].Cells[0].Value.ToString();
Range r2 = excelworksheet.get_Range("B" + s, "B" + s);
r2.Value2 = dataGridView1.Rows[i].Cells[1].Value.ToString();
Range r3 = excelworksheet.get_Range("C" + s, "C" + s);
r3.Value2 = dataGridView1.Rows[i].Cells[2].Value.ToString();
Range r4 = excelworksheet.get_Range("D" + s, "D" + s);
r4.Value2 = dataGridView1.Rows[i].Cells[3].Value.ToString();
Range r5 = excelworksheet.get_Range("E" + s, "E" + s);
r5.Value2 = dataGridView1.Rows[i].Cells[4].Value.ToString();
ProgressBar1.Value += 1;
}
ProgressBar1.Visible = false;
excelapp.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}