讲listViewData 数据写入到文件

private void exportToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Stream myStream;
            if (saveFileDialog.ShowDialog() == DialogResult.OK)
            {
                if ((myStream = saveFileDialog.OpenFile()) != null)
                {                                     
                    int i = 0;
                    try
                    {
                        StringBuilder strColu = new StringBuilder();   
                        StreamWriter sw = new StreamWriter(myStream);

                        for (i = 0; i <= listViewData.Columns.Count - 1; i++)
                        {
                            strColu.Append(listViewData.Columns[i].Text);
                            strColu.Append(",");  
                        }
                        strColu.Remove(strColu.Length - 1, 1);

                        sw.WriteLine(strColu);

                        foreach (ListViewItem dr in listViewData.Items)
                        {
                            StringBuilder strValue = new StringBuilder();
                            foreach (ListViewItem.ListViewSubItem subItem in dr.SubItems)
                            {
                                strValue.Append(subItem.Text);
                                strValue.Append(",");
                            }
                            strValue.Remove(strValue.Length - 1, 1);
                            sw.WriteLine(strValue);
                        }

                        sw.Close();
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }

                    myStream.Close();
                }
            }
        }

注意标题所用的方法和实际数据是不同的。Excel单元格之间分割使用逗号（,）