复制代码 代码如下:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Microsoft.Office.Interop.Excel;

using System.Reflection;

namespace ListToExcel

{

class Program

{

static List<objtype> objs = new List<objtype>();

static void Main(string[] args)

{

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

objs.Add(new objtype() { name = "allen", val = "aaa" });

ExportDataToExcel("", "", @"c:a.xls", "a");

}

/// <summary>

/// 直接导出数据到excel

/// </summary>

/// <param name="connectionString">连接字符串</param>

/// <param name="sql">查询语句</param>

/// <param name="fileName">文件名</param>

/// <param name="sheetName">表名</param>

static void ExportDataToExcel(string connectionString, string sql, string fileName, string sheetName)

{

Application app = new Application();

Workbook wb = app.Workbooks.Add(Missing.Value);

Worksheet ws = wb.Worksheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value) as Worksheet;

ws.Name = sheetName;

try

{

int n = 0;

for (int i = 1; i < objs.Count; i++)

{

var excelRange = (Range)ws.Cells[i, 1];

excelRange.Value2 = objs[i].val;//Value2?

excelRange = null;

}

}

catch (Exception ex)

{

string str = ex.Message;

}

finally

{

wb.Saved = true;

wb.SaveCopyAs(fileName);//保存

app.Quit();//关闭进程

}

}

}

class objtype

{

public string name { get; set; }

public string val { get; set; }

}

}