接上文NPOI大数据分批写入同个Excel,这次是利用task多任务同时写入到多个Excel。
Form2.cs
private void btnExport_Click(object sender, EventArgs e)
{
try
{
txtSql.SafeCall(() =>
{
txtSql.AppendText("开始处理...\r\n");
});
string sqlCount = Sql.GetRecordSql(GetBusinessType(), "");
recordCount = db.ExecuteScalar(sqlCount);
rowIndex = 0;
string[] sqlWhereArray = Sql.SqlWhereArray;
TaskFactory taskFactory = new TaskFactory();
Task[] tasks = new Task[sqlWhereArray.Length];
for (int k = 0; k < sqlWhereArray.Length; k++)
{