.NET C# 将表格数据导出成Excel文件类型数据

时间:2015/12/2 14:58:00来源:互联网 作者:flyso 点击: 948 次

/// <summary>
        /// 导出文件
        /// </summary>
        private void SaveData()
        {
            if (!System.IO.Directory.Exists(ph + "data"))
            {
                System.IO.Directory.CreateDirectory(ph + "data");
            }

            string ffn = ph + "data\\" + rFileName() + ".csv";
           // System.IO.StreamWriter aa = System.IO.File.AppendText(ffn);
            System.IO.StreamWriter aa = new StreamWriter(ffn, true, System.Text.Encoding.Default);
            aa.WriteLine("邮箱地址");

            for (int i = 0; i < List.Count; i++)
            {
                aa.WriteLine(List[i].Email);
            }
            aa.Close();

            DialogResult Dialog = MessageBox.Show("已经成功导出数据,是否现在就打开导出的数据文件?\n选择'是'打开导出的数据文件\n选择'否'打开文件存放目录", "系统提示", MessageBoxButtons.YesNo);
            if (Dialog == DialogResult.Yes)
            {
                System.Diagnostics.Process.Start(ffn);
            }
            else
            {
                System.Diagnostics.Process.Start(ph+"data");
            }
        }

Copyright © 2005 - 2016 flyso.cn. 飞搜 版权所有 鄂ICP备11002783号-3