public bool ExportDataGridview(DataGridView gridView, bool isShowExcle)
{
if (gridView.Rows.Count == 0)
{
return false;
}
//创建Excel对象
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
excel.Application.Workbooks.Add(true);
//生成字段名称
for (int i = 0; i < gridView.ColumnCount; i++)
{
if (gridView.Columns[i].Visible)
{
excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText;
}
}
//填充数据
for (int i = 0; i < gridView.RowCount; i++) //循环行
{
for (int j = 0; j < gridView.ColumnCount; j++) //循环列
{
if (gridView[j, i].ValueType == typeof(string))
{
if (gridView.Rows[i].Cells[j].Visible)
{
excel.Cells[i + 2, j + 1] = "'" + Convert.ToString(gridView.Rows[i].Cells[j].Value);
}
}
else
{
if (gridView.Rows[i].Cells[j].Visible)
{
excel.Cells[i + 2, j + 1] = Convert.ToString(gridView.Rows[i].Cells[j].Value);
}
}
}
}
//设置禁止弹出保存和覆盖的询问提示框
excel.Visible = false;
excel.DisplayAlerts = false;
excel.AlertBeforeOverwriting = false;
//保存到临时工作簿
//excel.Application.Workbooks.Add(true).Save();
//保存文件
excel.Save("D:" + "\\234.xls");
excel.Quit();
return true;
}
{
if (gridView.Rows.Count == 0)
{
return false;
}
//创建Excel对象
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
excel.Application.Workbooks.Add(true);
//生成字段名称
for (int i = 0; i < gridView.ColumnCount; i++)
{
if (gridView.Columns[i].Visible)
{
excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText;
}
}
//填充数据
for (int i = 0; i < gridView.RowCount; i++) //循环行
{
for (int j = 0; j < gridView.ColumnCount; j++) //循环列
{
if (gridView[j, i].ValueType == typeof(string))
{
if (gridView.Rows[i].Cells[j].Visible)
{
excel.Cells[i + 2, j + 1] = "'" + Convert.ToString(gridView.Rows[i].Cells[j].Value);
}
}
else
{
if (gridView.Rows[i].Cells[j].Visible)
{
excel.Cells[i + 2, j + 1] = Convert.ToString(gridView.Rows[i].Cells[j].Value);
}
}
}
}
//设置禁止弹出保存和覆盖的询问提示框
excel.Visible = false;
excel.DisplayAlerts = false;
excel.AlertBeforeOverwriting = false;
//保存到临时工作簿
//excel.Application.Workbooks.Add(true).Save();
//保存文件
excel.Save("D:" + "\\234.xls");
excel.Quit();
return true;
}