Excel导出

漫彧明柒

于 2015-11-20 15:05:33 发布

阅读量385

点赞数

分类专栏： C# Excel 导入导出文章标签：数据 excel 导出

本文链接：https://blog.csdn.net/qq_31971935/article/details/49946935

版权

C# 同时被 2 个专栏收录

39 篇文章 0 订阅

订阅专栏

Excel 导入导出

5 篇文章 0 订阅

订阅专栏

   #region 将数据导出至Excel
        public void ExportToExcel(System.Data.DataTable dtTemp)
        {

            System.Windows.Forms.SaveFileDialog dlg = new System.Windows.Forms.SaveFileDialog();
            dlg.Filter = "Excel files (*.xls)|*.xls";
            dlg.FilterIndex = 0;
            dlg.RestoreDirectory = true;
            dlg.CreatePrompt = true;
            dlg.Title = "保存为Excel文件";
            if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                Stream myStream;
                myStream = dlg.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.ASCIIEncoding.GetEncoding(-0));
                string columnTitle = "";
                //string columnTitle = "序号";
                try
                {
                    //for (int i = 0; i < dtTemp.Columns.Count; i++)
                    //{
                    //    columnTitle += "\t";
                    //    columnTitle += dtTemp.Columns[i].ColumnName.ToString();
                    //}
                    //sw.WriteLine(columnTitle);
                    for (int i = 0; i < dtTemp.Columns.Count; i++)
                    {
                       // columnTitle += "\t";
                        columnTitle += dtTemp.Columns[i].ColumnName.ToString();
                        columnTitle += "\t";
                    }
                    sw.WriteLine(columnTitle);

                    for (int j = 0; j < dtTemp.Rows.Count; j++)
                    {
                        string columnValue = "";
                    //    string columnValue = (j + 1).ToString();

                        for (int k = 0; k < dtTemp.Columns.Count; k++)
                        {
                          //  columnValue += "\t";

                            if (dtTemp.Rows[j][k].ToString() == "")
                            {

                                columnValue += "";
                            }
                            else
                            {
                                columnValue += dtTemp.Rows[j][k].ToString();
                            }
                            columnValue += "\t";
                        }
                        sw.WriteLine(columnValue);
                    }
                    sw.Close();
                    myStream.Close();
                    System.Windows.Forms.MessageBox.Show("导出成功！", "提示");

                }
                catch (Exception e)
                {
                    System.Windows.Forms.MessageBox.Show(e.ToString());
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }
        #endregion