代码如下:
//按钮
private void button1_Click(object sender, EventArgs e)
{
TurntoExel(listView1,"sheet_1");
}
//导出的方法
public void TurntoExel(ListView listview,string name)
{
if(listView1.Items.Count<0)
{
return;
}
Excel.Application myexcel = new Excel.Application();
myexcel.Visible = true;
myexcel.Caption = "第一章";//excel标题
if(myexcel==null)
{
return;
}
Excel.Workbooks workbooks = (Excel.Workbooks)myexcel.Workbooks;
Excel.Workbook workbook = workbooks.Add(Missing.Value);
Excel.Worksheet sheet = (Excel.Worksheet)workbook.Worksheets[1];