using System;
![](http://blog.51cto.com/images/editer/InBlock.gif)
using System.Collections.Generic;
![](http://blog.51cto.com/images/editer/InBlock.gif)
using System.Linq;
![](http://blog.51cto.com/images/editer/InBlock.gif)
using System.Web;
![](http://blog.51cto.com/images/editer/InBlock.gif)
using System.IO;
![](http://blog.51cto.com/images/editer/InBlock.gif)
using System.Data;
![](http://blog.51cto.com/images/editer/InBlock.gif)
using Aspose.Cells;
![](http://blog.51cto.com/images/editer/InBlock.gif)
///
///OutFileDao 的摘要说明
/// ![](http://blog.51cto.com/images/editer/InBlock.gif)
publicclass OutFileDao
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
public OutFileDao()
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
//
![](http://blog.51cto.com/images/editer/InBlock.gif)
//TODO: 在此处添加构造函数逻辑
![](http://blog.51cto.com/images/editer/InBlock.gif)
//
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
///
/// 测试程序
/// ![](http://blog.51cto.com/images/editer/InBlock.gif)
publicstaticvoid testOut()
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
DataTable dt = new DataTable();
![](http://blog.51cto.com/images/editer/InBlock.gif)
dt.Columns.Add("name");
![](http://blog.51cto.com/images/editer/InBlock.gif)
dt.Columns.Add("***");
![](http://blog.51cto.com/images/editer/InBlock.gif)
DataRow dr = dt.NewRow();
![](http://blog.51cto.com/images/editer/InBlock.gif)
dr["name"] = "名称1";
![](http://blog.51cto.com/images/editer/InBlock.gif)
dr["***"] = "性别1";
![](http://blog.51cto.com/images/editer/InBlock.gif)
dt.Rows.Add(dr);
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
DataRow dr1 = dt.NewRow();
![](http://blog.51cto.com/images/editer/InBlock.gif)
dr1["name"] = "名称2";
![](http://blog.51cto.com/images/editer/InBlock.gif)
dr1["***"] = "性别2";
![](http://blog.51cto.com/images/editer/InBlock.gif)
dt.Rows.Add(dr1);
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
OutFileToDisk(dt, "测试标题", @"d:\测试.xls");
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
///
/// 导出数据到本地
/// ![](http://blog.51cto.com/images/editer/InBlock.gif)
///
要导出的数据
![](http://blog.51cto.com/images/editer/InBlock.gif)
///
表格标题
![](http://blog.51cto.com/images/editer/InBlock.gif)
///
保存路径
![](http://blog.51cto.com/images/editer/InBlock.gif)
publicstaticvoid OutFileToDisk(DataTable dt,string tableName,string path)
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
Workbook workbook = new Workbook(); //工作簿
![](http://blog.51cto.com/images/editer/InBlock.gif)
Worksheet sheet = workbook.Worksheets[0]; //工作表
![](http://blog.51cto.com/images/editer/InBlock.gif)
Cells cells = sheet.Cells;//单元格
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//为标题设置样式
![](http://blog.51cto.com/images/editer/InBlock.gif)
Style styleTitle = workbook.Styles[workbook.Styles.Add()];//新增样式
![](http://blog.51cto.com/images/editer/InBlock.gif)
styleTitle.HorizontalAlignment = TextAlignmentType.Center;//文字居中
![](http://blog.51cto.com/images/editer/InBlock.gif)
styleTitle.Font.Name = "宋体";//文字字体
![](http://blog.51cto.com/images/editer/InBlock.gif)
styleTitle.Font.Size = 18;//文字大小
![](http://blog.51cto.com/images/editer/InBlock.gif)
styleTitle.Font.IsBold = true;//粗体
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//样式2
![](http://blog.51cto.com/images/editer/InBlock.gif)
Style style2 = workbook.Styles[workbook.Styles.Add()];//新增样式
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.HorizontalAlignment = TextAlignmentType.Center;//文字居中
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Font.Name = "宋体";//文字字体
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Font.Size = 14;//文字大小
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Font.IsBold = true;//粗体
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.IsTextWrapped = true;//单元格内容自动换行
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//样式3
![](http://blog.51cto.com/images/editer/InBlock.gif)
Style style3 = workbook.Styles[workbook.Styles.Add()];//新增样式
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.HorizontalAlignment = TextAlignmentType.Center;//文字居中
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Font.Name = "宋体";//文字字体
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Font.Size = 12;//文字大小
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
int Colnum = dt.Columns.Count;//表格列数
![](http://blog.51cto.com/images/editer/InBlock.gif)
int Rownum=dt.Rows.Count;//表格行数
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//生成行1 标题行
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells.Merge(0, 0, 1, Colnum);//合并单元格
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[0, 0].PutValue(tableName);//填写内容
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[0, 0].SetStyle(styleTitle);
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells.SetRowHeight(0, 38);
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//生成行2 列名行
![](http://blog.51cto.com/images/editer/InBlock.gif)
for (int i = 0; i < Colnum; i++)
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[1, i].PutValue(dt.Columns[i].ColumnName);
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[1, i].SetStyle(style2);
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells.SetRowHeight(1, 25);
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//生成数据行
![](http://blog.51cto.com/images/editer/InBlock.gif)
for (int i = 0; i < Rownum; i++)
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
for (int k = 0; k < Colnum; k++)
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[2 + i, k].PutValue(dt.Rows[i][k].ToString());
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[2 + i, k].SetStyle(style3);
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells.SetRowHeight(2+i, 24);
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
workbook.Save(path);
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
public MemoryStream OutFileToStream(DataTable dt, string tableName)
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
Workbook workbook = new Workbook(); //工作簿
![](http://blog.51cto.com/images/editer/InBlock.gif)
Worksheet sheet = workbook.Worksheets[0]; //工作表
![](http://blog.51cto.com/images/editer/InBlock.gif)
Cells cells = sheet.Cells;//单元格
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//为标题设置样式
![](http://blog.51cto.com/images/editer/InBlock.gif)
Style styleTitle = workbook.Styles[workbook.Styles.Add()];//新增样式
![](http://blog.51cto.com/images/editer/InBlock.gif)
styleTitle.HorizontalAlignment = TextAlignmentType.Center;//文字居中
![](http://blog.51cto.com/images/editer/InBlock.gif)
styleTitle.Font.Name = "宋体";//文字字体
![](http://blog.51cto.com/images/editer/InBlock.gif)
styleTitle.Font.Size = 18;//文字大小
![](http://blog.51cto.com/images/editer/InBlock.gif)
styleTitle.Font.IsBold = true;//粗体
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//样式2
![](http://blog.51cto.com/images/editer/InBlock.gif)
Style style2 = workbook.Styles[workbook.Styles.Add()];//新增样式
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.HorizontalAlignment = TextAlignmentType.Center;//文字居中
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Font.Name = "宋体";//文字字体
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Font.Size = 14;//文字大小
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Font.IsBold = true;//粗体
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.IsTextWrapped = true;//单元格内容自动换行
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style2.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//样式3
![](http://blog.51cto.com/images/editer/InBlock.gif)
Style style3 = workbook.Styles[workbook.Styles.Add()];//新增样式
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.HorizontalAlignment = TextAlignmentType.Center;//文字居中
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Font.Name = "宋体";//文字字体
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Font.Size = 12;//文字大小
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
style3.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
int Colnum = dt.Columns.Count;//表格列数
![](http://blog.51cto.com/images/editer/InBlock.gif)
int Rownum = dt.Rows.Count;//表格行数
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//生成行1 标题行
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells.Merge(0, 0, 1, Colnum);//合并单元格
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[0, 0].PutValue(tableName);//填写内容
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[0, 0].SetStyle(styleTitle);
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells.SetRowHeight(0, 38);
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//生成行2 列名行
![](http://blog.51cto.com/images/editer/InBlock.gif)
for (int i = 0; i < Colnum; i++)
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[1, i].PutValue(dt.Columns[i].ColumnName);
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[1, i].SetStyle(style2);
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells.SetRowHeight(1, 25);
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
//生成数据行
![](http://blog.51cto.com/images/editer/InBlock.gif)
for (int i = 0; i < Rownum; i++)
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
for (int k = 0; k < Colnum; k++)
![](http://blog.51cto.com/images/editer/InBlock.gif)
{
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[2 + i, k].PutValue(dt.Rows[i][k].ToString());
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells[2 + i, k].SetStyle(style3);
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
cells.SetRowHeight(2 + i, 24);
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
MemoryStream ms = workbook.SaveToStream();
![](http://blog.51cto.com/images/editer/InBlock.gif)
return ms;
![](http://blog.51cto.com/images/editer/InBlock.gif)
}
![](http://blog.51cto.com/images/editer/InBlock.gif)
![](http://blog.51cto.com/images/editer/InBlock.gif)
}