110,545
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 打开EXCEL 写入DataGridView中的数据
/// </summary>
/// <param name="dg"></param>
public static void input_excel(DataGridView dg)
{
Excel.Application excel = new Excel.Application();
excel.Application.Workbooks.Add(true);
excel.Visible = true;
///写入列名到EXCEL
for (int i = 1; i <= dg.ColumnCount; i++)
{
excel.Cells[1, i] = dg.Columns[i-1].HeaderText;
}
///写入数据到EXCEL
if (dg.AllowUserToAddRows == true)
{
for (int hang = 0; hang < dg.Rows.Count - 1; hang++)
{
for (int lie = 0; lie < dg.ColumnCount; lie++)
{
excel.Cells[hang + 2, lie + 1] = Convert.ToString(dg[lie, hang].Value);
}
}
}
else
{
for (int hang = 0; hang < dg.Rows.Count ; hang++)
{
for (int lie = 0; lie < dg.ColumnCount; lie++)
{
excel.Cells[hang + 2, lie + 1] = Convert.ToString(dg[lie, hang].Value);
}
}
}
}