Aspose.Cells.dll操作exel
来源:互联网 发布:大众软件订阅 编辑:程序博客网 时间:2024/05/19 04:07
1.创建execl(不需要服务器或者客户端安装office)
public void DCExexl(DataTable dt)
{
Workbook wb = new Workbook();
Worksheet ws = wb.Worksheets[0];
Cells cell = ws.Cells;
cell[0, 0].PutValue("ID");//添加数据到第0行和第0列
cell.SetRowHeight(0, 0);设置行高
Aspose.Cells.Style style1 = wb.Styles[wb.Styles.Add()];
style1.HorizontalAlignment = TextAlignmentType.Right;//文字居中
style1.Font.Name = "宋体";
style1.Font.IsBold = true;//设置粗体
style1.Font.Size = 12;//设置字体大小
cell[0, 0].SetStyle(style1);
cell.SetColumnWidth(0, 10.00);//列宽
Range range = cell.CreateRange(0, 0, 1, 1);//合并单元格
range.Merge();
string FileName = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
HttpResponse response = Page.Response;
response.Buffer = true;
response.Charset = "utf-8";
response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
response.ContentEncoding = System.Text.Encoding.UTF8;
response.ContentType = "application/ms-excel";
response.BinaryWrite(wb.SaveToStream().ToArray());
response.End();
}
2.读取execl
public DataTable GetDataTable(string path)
{
Workbook workbook = new Workbook();
workbook.Open(path);
Cells cells = workbook.Worksheets[0].Cells;
DataTable dt = new DataTable();
bool d = true;//防止表头重复加载
for (int i = 0; i < cells.MaxDataRow + 1; i++)
{
DataRow row = dt.NewRow();
for (int j = 0; j < cells.MaxDataColumn + 1; j++)
{
if (d) {
dt.Columns.Add(cells[0, j].StringValue.Trim());
}
row[j] = cells[i + 1, j].StringValue.Trim();
}
dt.Rows.Add(row);
d = false;
}
return dt;
}
- Aspose.Cells.dll操作exel
- Excel操作帮助类 (基于Aspose.Cells.dll)
- Aspose.Cells.dll的运用
- Aspose.Cells
- 【学习笔记】C#使用Aspose.Cells.dll处理excel表格
- Aspose.Cells.dll 读写Excel的用法总结-技术&分享
- MVC利用Aspose.Cells.dll实现Excel数据导入数据库
- excel 在线预览类库:Aspose.Cells.dll
- vs2013提示未能找到aspose.cells.dll文件的问题
- 用Aspose.Cells.dll从Excel读取数据到DataSet
- 使用Aspose.Cells.dll导出数据到Excel
- 报表中的Excel操作之Aspose.Cells(Excel模板)
- Aspose.Cells 使用整理
- Aspose.Cells教学视频
- Aspose.Cells简单用法
- Aspose.Cells中文版文档
- Aspose.Cells 使用汇总
- Java Aspose Cells
- (转载)机器学习数据集(Dataset)汇总
- Unreal Engine 4学习笔记:改变天空颜色
- [NOIP2016]组合数问题
- 使用JS判断客户端、浏览器、操作系统类型
- python中文截断
- Aspose.Cells.dll操作exel
- MindManager职场攻略“赶走瞌睡虫”!
- 安装fabric运行环境的时候Vagrant up遇到的问题,解决路径
- Linux_使用java给文件添加权限
- Cef经典N大问题
- ActivityInfo的获取
- nltk中文语料库使用总结
- 有关于python中的换行
- 对jq插件进行封装