手机
当前位置:查字典教程网 >编程开发 >C#教程 >c#生成excel示例sql数据库导出excel
c#生成excel示例sql数据库导出excel
摘要:复制代码代码如下:usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;...

复制代码 代码如下:

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; }

}

}

【c#生成excel示例sql数据库导出excel】相关文章:

c#数据类型基础

C#自动创建数据库实现代码

C#实现任意数据类型转成json格式输出

C#生成sitemap站点地图的方法

C#连接db2数据库的实现方法

C#中将ListView中数据导出到Excel的实例方法

C#中的where泛型约束介绍

c#数据库与TXT导入导出的实例

C#操作数据库总结(vs2005+sql2005)

c#生成缩略图的实现方法

精品推荐
分类导航