DataGridView快速导出为Excel.doc

调用实例：在Winforms的“导出excel”按钮的Click事件填写如下代码：List list = new List();list.Add(员工编号);list.Add(身份证号);list.Add(打卡时间);XPri.Export(dgvData, progressBar1, list);/list为泛型对象, dgvData是DataGridView控件, progressBar1是progressBar控件。/设置progressBar1.Visible=false;/员工编号, 身份证号, 打卡时间为dgvData的列的文本HeadText/员工编号, 身份证号, 打卡时间为需要强制导出为文本的列源代码如下:(方法重载 文件名：XPri.cs)using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.Common;using DataAccess.Data;using System.Data.OleDb;using System.Windows.Forms;using System.IO;namespace HrManager public class XPri / / 普?通快速导?出? / / / public static void Export(DataGridView dataGridView1, ProgressBar pb) #region SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = Execl files (*.xls)|*.xls; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; /saveFileDialog.CreatePrompt = true; saveFileDialog.Title = 导?出?为aExcel文?件t; saveFileDialog.FileName = string.Format(0.xls, DateTime.Now.ToString(yyyyMMddHHmmss); if (saveFileDialog.ShowDialog() != DialogResult.OK) return; if (saveFileDialog.FileName = ) return; Stream myStream; myStream = saveFileDialog.OpenFile(); StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0); string str = ; try for (int i = 0; i 0) str += t; str += dataGridView1.Columnsi.HeaderText; sw.WriteLine(str); pb.Visible = true; pb.Maximum = dataGridView1.Rows.Count; for (int j = 0; j dataGridView1.Rows.Count; j+) string tempStr = ; for (int k = 0; k 0) tempStr += t; DataGridViewComboBoxCell cb = dataGridView1.Rowsj.Cellsk as DataGridViewComboBoxCell; if (cb = null) tempStr += Convert.ToString(dataGridView1.Rowsj.Cellsk.Value); else tempStr += Convert.ToString(cb.FormattedValue); sw.WriteLine(tempStr); pb.Value = j + 1; sw.Close(); myStream.Close(); pb.Visible = false; catch (Exception ex) MessageBox.Show(ex.Message, 出?错信?息); finally sw.Close(); myStream.Close(); #endregion MessageBox.Show(导?出?成功|, 提示?); / / 特?殊a情况?时的?导?出? 工号?、身份Y证号?、电?话等 需要a转a义?为a字?符?串? / / / / 前面?要a+的?列D(需要a强?制?文?本?列D的?HeadText),如?身份Y证号?,工号?,电?话等 public static void Export(DataGridView dataGridView1, ProgressBar pb, List list) #region SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = Execl files (*.xls)|*.xls; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; /saveFileDialog.CreatePrompt = true; saveFileDialog.Title = 导?出?为aExcel文?件t; saveFileDialog.FileName = string.Format(0.xls, DateTime.Now.ToString(yyyyMMddHHmmss); if (saveFileDialog.ShowDialog() != DialogResult.OK) return; if (saveFileDialog.FileName = ) return; Stream myStream; myStream = saveFileDialog.OpenFile(); StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0); string str = ; try for (int i = 0; i 0) str += t; str += dataGridView1.Columnsi.HeaderText; sw.WriteLine(str); pb.Visible = true; pb.Maximum = dataGridView1.Rows.Count; for (int j = 0; j dataGridView1.Rows.Count; j+) string tempStr = ; for (int k = 0; k 0) tempStr += t; if (list.Contains(dataGridView1.Columnsk.HeaderText) tempStr += ;/加强?制?转a义?为a文?本? DataGridViewComboBoxCell cb = dataGridView1.Rowsj.Cellsk as DataGridViewComboBoxCell; if (cb = null) tempStr += Convert.ToString(dataGridView1.Rowsj.Cellsk.Value); else tempStr += Convert.ToString(cb.FormattedValue); sw.WriteLine(tempStr); pb.Value = j + 1; sw.Close();