datagridview序号左对齐_winform DataGridView数据导出到excel中

winform DataGridView数据导出到excel中

实例一

private void button5_Click_1(object sender, EventArgs e)

{

//建立Excel对象

Excel.Application excel = new Excel.Application();

excel.Application.Workbooks.Add(true);

//生成字段名称

for (int i = 0; i < dataGridView2.ColumnCount; i++)

{

excel.Cells[1,i + 1] = dataGridView2.Columns[i].HeaderText;

if (y == 0)

{

y = 1;

toolStripStatusLabel6.Text = "数据导入中，请等待!";

}

}

//填充数据

for (int i = 0; i < dataGridView2.Row_count- 1; i++)

{

for (int j = 0; j < dataGridView2.ColumnCount; j++)

{

if (dataGridView2[j, i].Value == typeof(string))

{

excel.Cells[i + 2, j + 1] = ""