winform简单代码导出Execl

最新推荐文章于 2023-12-07 10:26:05 发布

yangliangbin

最新推荐文章于 2023-12-07 10:26:05 发布

阅读量165

点赞数

文章标签： winform stream exception string

本文链接：https://blog.csdn.net/yangliangbin/article/details/7024736

版权

private void DataToExecl()
        {
            if ( this.dgTemp.Rows.Count > 0) // dgTemp为DataGridView控件
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = " 导出到Execl ";
                sfd.DefaultExt = " xls ";
                sfd.Filter = " Execl文件(*.xls)|.xls ";
                sfd.FilterIndex = 0;
                sfd.RestoreDirectory = true;
                sfd.CreatePrompt = true;
                sfd.FileName = " XXXX.xls ";//导出xls的文件名
                sfd.ShowDialog();
                if (sfd.FileName == "")
                {
                    return;
                }
                Stream stream = sfd.OpenFile();
                StreamWriter sw = new StreamWriter(stream, System.Text.Encoding.GetEncoding(- 0));
                try
                {
                    string str1 = "";
                    for ( int i = 0; i < this.dgTemp.ColumnCount; i++)
                    {
                        if (str1 != "")
                        {
                            str1 += " \t ";
                        }
                        str1 += dgTemp.Columns[i].HeaderText;
                    }
                    sw.WriteLine(str1);

                    for ( int j = 0; j < dgTemp.Rows.Count; j++)
                    {
                        string str2 = "";
                        for ( int k = 0; k < dgTemp.Columns.Count; k++)
                        {
                            if (str2 != "")
                            {
                                str2 += " \t ";
                            }
                            str2 += dgTemp.Rows[j].Cells[k].Value.ToString();
                        }
                        sw.WriteLine(str2);
                    }
                    sw.Close();
                    stream.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
                finally
                {
                    sw.Close();
                    stream.Close();
                }
            }
        }