110,538
社区成员
发帖
与我相关
我的任务
分享
DataTable CreateData()
{
DataTable dt = new DataTable();
dt.Columns.Add("consNo", typeof(String));
dt.Columns.Add("consName", typeof(String));
dt.Columns.Add("oweAmt", typeof(Decimal));
for (int i = 0; i < 440001; i++)
{
DataRow dr = dt.NewRow();
dr["consNo"] = i.ToString();
dr["consName"] = "Jimmy" + i.ToString();
dr["oweAmt"] = Convert.ToDecimal(i * 0.32 + 44.26);
dt.Rows.Add(dr);
}
return dt;
}
void ExportExcel()
{
DataTable dt = CreateData();
using (StreamWriter sw = new StreamWriter(AppDomain.CurrentDomain.BaseDirectory + "test.xls", false, Encoding.GetEncoding("gb2312")))
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Columns.Count; i++)
{
sb.Append(dt.Columns[i].ColumnName.ToString() + "\t");
}
sb.Append(Environment.NewLine);
for (int r = 0; r < dt.Rows.Count; r++)
{
System.Windows.Forms.Application.DoEvents();
for (int c = 0; c < dt.Columns.Count; c++)
{
sb.Append(dt.Rows[r][c].ToString() + "\t");
}
sb.Append(Environment.NewLine);
}
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
MessageBox.Show("导出成功");
}
}
DataTable CreateData()
{
DataTable dt = new DataTable();
dt.Columns.Add("consNo", typeof(String));
dt.Columns.Add("consName", typeof(String));
dt.Columns.Add("oweAmt", typeof(Decimal));
for (int i = 0; i < 440001; i++)
{
DataRow dr = dt.NewRow();
dr["consNo"] = i.ToString();
dr["consName"] = "Jimmy" + i.ToString();
dr["oweAmt"] = Convert.ToDecimal(i * 0.32 + 44.26);
dt.Rows.Add(dr);
}
return dt;
}
//datagridview绑定数据源
datagridview1.DataSource = CreateData();
2、导出的时候,把datagridview的数据源转换成DataTable
DataTable dt = datagridview1.DataSource as DataTable;
3、导出excel
void ExportExcel()
{
DataTable dt = datagridview1.DataSource as DataTable;
using (StreamWriter sw = new StreamWriter(AppDomain.CurrentDomain.BaseDirectory + "test.xls", false, Encoding.GetEncoding("gb2312")))
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Columns.Count; i++)
{
sb.Append(dt.Columns[i].ColumnName.ToString() + "\t");
}
sb.Append(Environment.NewLine);
for (int r = 0; r < dt.Rows.Count; r++)
{
System.Windows.Forms.Application.DoEvents();
for (int c = 0; c < dt.Columns.Count; c++)
{
sb.Append(dt.Rows[r][c].ToString() + "\t");
}
sb.Append(Environment.NewLine);
}
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
MessageBox.Show("导出成功");
}
}
using (StreamWriter sw = new StreamWriter(AppDomain.CurrentDomain.BaseDirectory + "test.xls", false, Encoding.GetEncoding("gb2312")))
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Columns.Count; i++)
{
sb.Append(dt.Columns[i].ColumnName.ToString() + "\t");
}
sb.Append(Environment.NewLine);
for (int r = 0; r < dt.Rows.Count; r++)
{
System.Windows.Forms.Application.DoEvents();
for (int c = 0; c < dt.Columns.Count; c++)
{
sb.Append(dt.Rows[r][c].ToString() + "\t");
}
sb.Append(Environment.NewLine);
}
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
MessageBox.Show("导出成功");
}