我是有这种方法导出的,列名是数据库里的列名,不知道要如何修改掉 myExcel.Cells[1, 1] = "本月帐单表";//取得第一行第一列
//Object Date[ds.Tables["CurrentTable"].Rows.Count][ds.Tables["CurrentTable"].Columns.Count];
//生成标题
for (int i = 0; i < ds.Tables["CurrentTable"].Columns.Count; i++)
{
myExcel.Cells[2, i + 1] = ds.Tables["CurrentTable"].Columns[i].Caption;
}
//填充数据
for (int i = 0; i < ds.Tables["CurrentTable"].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables["CurrentTable"].Columns.Count; j++)
{
if (ds.Tables["CurrentTable"].Rows[i][j].GetType() == typeof(System.String))
{ myExcel.Cells[i + 3, j + 1] = "aa" + ds.Tables["CurrentTable"].Rows[i][j].ToString();
}
else
{
myExcel.Cells[i + 3, j + 1] = ds.Tables["CurrentTable"].Rows[i][j].ToString();
}
}
} this.Cursor = Cursors.Default;
MessageBox.Show("导出成功", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information);
//Object Date[ds.Tables["CurrentTable"].Rows.Count][ds.Tables["CurrentTable"].Columns.Count];
//生成标题
for (int i = 0; i < ds.Tables["CurrentTable"].Columns.Count; i++)
{
myExcel.Cells[2, i + 1] = ds.Tables["CurrentTable"].Columns[i].Caption;
}
//填充数据
for (int i = 0; i < ds.Tables["CurrentTable"].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables["CurrentTable"].Columns.Count; j++)
{
if (ds.Tables["CurrentTable"].Rows[i][j].GetType() == typeof(System.String))
{ myExcel.Cells[i + 3, j + 1] = "aa" + ds.Tables["CurrentTable"].Rows[i][j].ToString();
}
else
{
myExcel.Cells[i + 3, j + 1] = ds.Tables["CurrentTable"].Rows[i][j].ToString();
}
}
} this.Cursor = Cursors.Default;
MessageBox.Show("导出成功", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information);
//生成标题
for (int i = 0; i < ds.Tables["CurrentTable"].Columns.Count; i++)
{
myExcel.Cells[2, i + 1] = ds.Tables["CurrentTable"].Columns[i].Caption;
}
或者在dt中更改:datatable1.columns[x].caption=xx