手机
当前位置:查字典教程网 >编程开发 >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#数据库与TXT导入导出的实例

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

C#中的where泛型约束介绍

c# asp .net 动态创建sql数据库表的方法

解析c#操作excel后关闭excel.exe的方法

C#数据库操作小结

C#将html table 导出成excel实例

C#连接Oracle数据库的实例方法

浅析C# web访问mysql数据库-整理归纳总结

精品推荐
分类导航