DataGridView导出数据到excel中去

#region 导出工作
        /// <summary>
        /// 导出工作
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnExport_Click(object sender, EventArgs e)
        {
            using (SaveFileDialog saveFileDialog = new SaveFileDialog())
            {
                saveFileDialog.Filter = "Execl  files  (*.xls)|*.xls";
                saveFileDialog.FilterIndex = 0;
                saveFileDialog.RestoreDirectory = true;
                saveFileDialog.CreatePrompt = true;
                saveFileDialog.Title = "导出Excel文件到";
                DateTime now = DateTime.Now;
                saveFileDialog.FileName = now.Year.ToString().PadLeft(2) + now.Month.ToString().PadLeft(2, '0') + now.Day.ToString().PadLeft(2, '0') + "-" + now.Hour.ToString().PadLeft(2, '0') + now.Minute.ToString().PadLeft(2, '0') + now.Second.ToString().PadLeft(2, '0');
                saveFileDialog.ShowDialog();
                Stream myStream;
                myStream = saveFileDialog.OpenFile();
                using (StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312")))
                {
                    string str = "";
                    try
                    {
                        //写标题    
                        for (int i = 1; i < dgvWork.ColumnCount; i++)
                        {
                            if (i > 1)
                            {
                                str += "\t";
                            }
                            str += dgvWork.Columns[i].HeaderText;
                        }
                        sw.WriteLine(str);
                        //写内容 
                        for (int j = 0; j < dgvWork.Rows.Count; j++)
                        {
                            string tempStr = "";
                            for (int k = 1; k < dgvWork.Columns.Count; k++)
                            {
                                if (k > 1)
                                {
                                    tempStr += "\t";
                                }
                                if (dgvWork.Rows[j].Cells[k].OwningColumn.HeaderText == "姓名")
                                {
                                    tempStr += new UserBLL().GetModel(Convert.ToInt16(dgvWork.Rows[j].Cells[k].Value)).UserName;
                                }
                                else
                                {
                                    tempStr += dgvWork.Rows[j].Cells[k].Value.ToString();
                                }
                            }
                            sw.WriteLine(tempStr);
                        }
                        MessageBox.Show("导出成功");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }
        #endregion

 

转载于:https://www.cnblogs.com/LoVeSW/articles/3420407.html