C# 如何将listview的内容输入到一个excel文件中

Answer 1

你说的是导出吧，找一个Excel.dll文件，然后在“解决方案资源管理器”的“引用”里添加这个文件，在一个按钮的触发事件里写：
try
{
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;

Excel.Application objApp = new Excel.Application();
Excel.Workbooks objBooks = objApp.Workbooks;
Excel._Workbook objBook = objBooks.Add(Missing.Value);
Excel.Sheets objSheets = objBook.Worksheets;
Excel._Worksheet objSheet = (Excel._Worksheet)objSheets.get_Item(1);
//objSheet.Name = this.strCaption;
objSheet.Name = "sheet1";
Excel.Range range = null;
try
{
objApp.Cells.Font.Size = 10;
range = objSheet.get_Range("A1", Missing.Value);

range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;

//************************ 导出所有数据列 ************************************************

//导出列标题
for (int i = 0; i < this.dSCompare.Tables["dt"].Columns.Count; i++)
{
range.Cells[1, i + 1] = this.dSCompare.Tables["dt"].Columns[i].ColumnName;
}

//导出数据
for (int m = 1; m <= this.dSCompare.Tables["dt"].Rows.Count; m++)
{
for (int j = 0; j < this.dSCompare.Tables["dt"].Columns.Count; j++)
{
range.Cells[m + 1, j + 1] = "'" + this.dSCompare.Tables["dt"].Rows[m - 1][j].ToString();
}
}

objApp.Visible = true;
objApp.UserControl = true;

MessageBox.Show("数据导出成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(range);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objSheets);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objBooks);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objApp);

range = null;
objSheet = null;
objSheets = null;
objBook = null;
objBooks = null;
objApp = null;

GC.Collect();

this.Cursor = System.Windows.Forms.Cursors.Default;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + '\r' + '\n' + ex.StackTrace);
}

Answer 2

用NPOI组件

Answer 3

请问一下 this.dSCompare.Tables["dt"].Columns.Count中的那个tables["dt"],是怎么弄得？求解，谢谢