将listview表格中的数据导出到.csv文件当中
“,”逗号分隔为格,“\r\n”代表的是换行
public void Write(string filePath,ListView listview)
{
string path = filePath;
int rowNum = listview.Items.Count;
int column = listview.Items[0].SubItems.Count;
int rowIndex = 1;
int columnIndex = 0;
if (!File.Exists(path))
File.Create(path).Close();
StreamWriter sw=new StreamWriter(path,true,Encoding.UTF8);
if (rowNum != 0)
{
//将ListView的列名导入Excel表的第一行
foreach (ColumnHeader dc in listview.Columns)
{
columnIndex++;
sw.Write(dc.Text+",");
}
for (rowIndex = 2; rowIndex < listview.Items.Count + 2; rowIndex++)
{
sw.Write("\r\n"+listview.Items[rowIndex - 2].Text +",");
for (columnIndex = 2; columnIndex <= listview.Columns.Count; columnIndex++)
{
sw.Write(listview.Items[rowIndex - 2].SubItems[columnIndex - 1].Text+",");
}
}
}
sw.Flush();
sw.Close();
}