Aspose.Cells 17.7 for .NET 学习版(包括.net 2.0,3.5,4.0版本),直接修改IL代码从而不出现水印,并且重新进行了强名称签名,可以通过强名称验证
以下代码读取Excel内容:
using Aspose.Cells;
Workbook workbook = new Workbook("D:\\test.xlsx");
Cells cells = workbook.Worksheets[0].Cells;
for (int i = 0; i < cells.MaxDataRow + 1; i++)
{
for (int j = 0; j < cells.MaxDataColumn + 1; j++)
{
string s = cells[i, j].StringValue.Trim();
//一行行的读取数据,插入数据库的代码也可以在这里写
}
}
以下代码导出Escel内容
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
Cells cells = worksheet.Cells;
cells.InsertRow(0);
Aspose.Cells.Style style = workbook.Styles[workbook.Styles.Add()];//新增样式
style.HorizontalAlignment = TextAlignmentType.Center;//文字居中
style.Font.Size = 11;//文字大小
style.Font.IsBold = true;//粗体
cells.SetRowHeight(0, 20); //设置行高
List<string> listHead = new List<string>();
listHead.Add("学生编号");
listHead.Add("学生姓名");
listHead.Add("学生年龄");
listHead.Add("电话");
for (int i = 0; i < listHead.Count; i++)
{
cells[0, i].PutValue(listHead[i]);
cells[0, i].SetStyle(style);
cells.SetColumnWidth(i, 30);
}
worksheet.Cells.ImportCustomObjects(list, new string[] {"Id","Name","Age","Tel"}, false, 1, 0, list.Count, true, "", false);
workbook.Save(System.Web.HttpContext.Current.Response, "数据统计.xls", Aspose.Cells.ContentDisposition.Attachment, new XlsSaveOptions(Aspose.Cells.SaveFormat.Excel97To2003));
前端下载时调用:
共有条评论 网友评论