C# win form 中 将数据导出为简单Excel文件

说明：所谓简单Excel是指不能设定字体，颜色等的格式。

 

代码如下：

 

代码说明：下列代码是将ListView里的数据保存成Excel文件

 

            //弹出保存文件对话框。
            SaveFileDialog saveFileExcel = new SaveFileDialog();

            saveFileExcel.Filter = "Excel 文档(*.xls)|*.xls|所有文件(*.*)|*.*";

            saveFileExcel.ShowDialog();

            //如果用户选择了路径则生成excel
            if (saveFileExcel.FileName != "")
            {
                FileStream filestreamExcel = new FileStream(saveFileExcel.FileName, FileMode.Create, FileAccess.Write);//生成文件

                StreamWriter streamwriterExcel = new StreamWriter(filestreamExcel, System.Text.Encoding.GetEncoding("gb2312"));//生成可以向刚刚生成的文件里写内容的可写流

                foreach (ColumnHeader col in lstvIdentifyResult.Columns)
                {
                    streamwriterExcel.Write(col.Text+"/t");
                }

                streamwriterExcel.Write("车牌图片/t");

                streamwriterExcel.Write("车辆图片/t");

                streamwriterExcel.WriteLine();

                if (lstvIdentifyResult.Items.Count > 0)
                {
                    foreach (ListViewItem lstvItem in lstvIdentifyResult.Items)
                    {
                        for (int i = 0; i < lstvItem.SubItems.Count; i++)
                        {
                            ListViewItem.ListViewSubItem lstvsub = lstvItem.SubItems[i];

                            streamwriterExcel.Write(lstvsub.Text + "/t");
                        }

                        streamwriterExcel.WriteLine();
                    }
                }

                streamwriterExcel.Close();

                streamwriterExcel.Dispose();

                filestreamExcel.Close();

                filestreamExcel.Dispose();

            }