问题提出:
在我的WINFORM中有一个查询页面需要将DATAGRIDVIEW中的数据导出到EXCEL,由于有时数据量比较大,程序假死很长时间,所以想到需要增加进度条来实时显示导出过程,到在同是主线程中使用进度条一样没有效果,程序依然假死状态,这时我想到了用委托和线程,到底应该把进度条放到单独线程还是把导出操作放到单独进程呢,还是两个都放到单独进程,应该怎么操作,请大家给下详细代码。以下是我现在的代码部分,应该如何改良呢,谢谢大家1.查询窗体中的导出按钮,点击此按钮调用一个公共基础类BaseClass.BaseOprate的导出方法datagridviewToExcel123
BaseClass.BaseOprate bs = new BaseClass.BaseOprate();
bs.datagridviewToExcel123(dataGridView1,saveFileDialog1);2,BaseOprate的导出方法datagridviewToExcel123 public void datagridviewToExcel123(DataGridView gridView, SaveFileDialog saveFileDialog)
{
if (gridView.Rows.Count == 0)
{
MessageBox.Show("没有数据可供导出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = "导出文件保存路径";
saveFileDialog.ShowDialog();
string strName = saveFileDialog.FileName;
if (strName.Length != 0)
{
System.Reflection.Missing miss = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
excel.Application.Workbooks.Add(true); ;
excel.Visible = false;//若是true,则在导出的时候会显示EXcel界面。
if (excel == null)
{
MessageBox.Show("EXCEL无法启动!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Microsoft.Office.Interop.Excel.Workbooks books = (Microsoft.Office.Interop.Excel.Workbooks)excel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook book = (Microsoft.Office.Interop.Excel.Workbook)(books.Add(miss));
Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.ActiveSheet;
sheet.Name = "test"; //生成字段名称
for (int i = 0; i < gridView.ColumnCount; i++)
{
excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText.ToString();
}
//填充数据
for (int i = 0; i < gridView.RowCount - 1; i++)
{
for (int j = 0; j < gridView.ColumnCount; j++)
{
if (gridView[j, i].Value == typeof(string))
{
excel.Cells[i + 2, j + 1] = "" + gridView[i, j].Value.ToString();
}
else
{
excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
}
}
}
sheet.SaveAs(strName, miss, miss, miss, miss, miss, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss);
book.Close(false, miss, miss);
books.Close();
excel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(book);
System.Runtime.InteropServices.Marshal.ReleaseComObject(books);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
GC.Collect();
MessageBox.Show("数据已经成功导出到:" + saveFileDialog.FileName.ToString(), "导出完成", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
在我的WINFORM中有一个查询页面需要将DATAGRIDVIEW中的数据导出到EXCEL,由于有时数据量比较大,程序假死很长时间,所以想到需要增加进度条来实时显示导出过程,到在同是主线程中使用进度条一样没有效果,程序依然假死状态,这时我想到了用委托和线程,到底应该把进度条放到单独线程还是把导出操作放到单独进程呢,还是两个都放到单独进程,应该怎么操作,请大家给下详细代码。以下是我现在的代码部分,应该如何改良呢,谢谢大家1.查询窗体中的导出按钮,点击此按钮调用一个公共基础类BaseClass.BaseOprate的导出方法datagridviewToExcel123
BaseClass.BaseOprate bs = new BaseClass.BaseOprate();
bs.datagridviewToExcel123(dataGridView1,saveFileDialog1);2,BaseOprate的导出方法datagridviewToExcel123 public void datagridviewToExcel123(DataGridView gridView, SaveFileDialog saveFileDialog)
{
if (gridView.Rows.Count == 0)
{
MessageBox.Show("没有数据可供导出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = "导出文件保存路径";
saveFileDialog.ShowDialog();
string strName = saveFileDialog.FileName;
if (strName.Length != 0)
{
System.Reflection.Missing miss = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
excel.Application.Workbooks.Add(true); ;
excel.Visible = false;//若是true,则在导出的时候会显示EXcel界面。
if (excel == null)
{
MessageBox.Show("EXCEL无法启动!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Microsoft.Office.Interop.Excel.Workbooks books = (Microsoft.Office.Interop.Excel.Workbooks)excel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook book = (Microsoft.Office.Interop.Excel.Workbook)(books.Add(miss));
Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.ActiveSheet;
sheet.Name = "test"; //生成字段名称
for (int i = 0; i < gridView.ColumnCount; i++)
{
excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText.ToString();
}
//填充数据
for (int i = 0; i < gridView.RowCount - 1; i++)
{
for (int j = 0; j < gridView.ColumnCount; j++)
{
if (gridView[j, i].Value == typeof(string))
{
excel.Cells[i + 2, j + 1] = "" + gridView[i, j].Value.ToString();
}
else
{
excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
}
}
}
sheet.SaveAs(strName, miss, miss, miss, miss, miss, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss);
book.Close(false, miss, miss);
books.Close();
excel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(book);
System.Runtime.InteropServices.Marshal.ReleaseComObject(books);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
GC.Collect();
MessageBox.Show("数据已经成功导出到:" + saveFileDialog.FileName.ToString(), "导出完成", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
解决方案 »
- 哪位大哥帮忙看看<关于VS2010所出现的问题>
- c# udp通信中用结构体序列化后报文大小取不到,请教
- discuz 论坛POST数据的时候 来路不正确
- 关于更新数据库使用多个insert更新和使用dataadapter.update的差别在哪里?
- windows窗体启动顺序
- 超时时间已到。超时时间已到,但是尚未从池中获取连接。出现这种情况可能是因为所有池连接均在使用,并且达到了最大池大小。
- C# winform combobox 动态添加 item,item要有value与text两个属性
- 急急急!!!查询上网记录
- 如何判断对指定网站的连接是否成功?
- 做邮件发送时
- DateTimePicker控件设置
- ASP.NET 传值问题,大家探讨下!!!!!!
{
Thread Export = new Thread(new ThreadStart(Pross)); Export.IsBackground = true; Export.Start();
}private void Pross()
{
//.....导出的操作
Progr(i); //更改进度条的显示
}
private void Progr(int i) //更改进度条的显示
{
if (this.progressBar1.InvokeRequired)//等待异步
{
Client cl = new Client(Progr);
this.Invoke(cl, new object[] { i });//通过代理调用刷新方法
}
else
{
progressBar1.Value = i;
}
}大概就是这样了
//填充数据
for (int i = 0; i < gridView.RowCount - 1; i++)
{
for (int j = 0; j < gridView.ColumnCount; j++)
{
if (gridView[j, i].Value == typeof(string))
{
excel.Cells[i + 2, j + 1] = "" + gridView[i, j].Value.ToString();
}
else
{
excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
}
} this.progressBar1.Value = i;
Application.DoEvents();
}