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
objs = new List();
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");
}
///
/// 直接导出数据到excel
///
/// 连接字符串
/// 查询语句
/// 文件名
/// 表名
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 {
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; }
}
}
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有