Asp.net程序中生成Excel报表

1 XlsDocument xls = new XlsDocument(); //创建一个空的Excel文档
2        
3 xls.Send(); //将文档发送到浏览器。

XlsDocument xls = new XlsDocument();
xls.FileName = "Wacky.xls";
//添加文件属性
xls.SummaryInformation.Author = "Tim Erickson"; //作者
xls.SummaryInformation.Subject = "A wacky display of Excel file generation";
xls.DocumentSummaryInformation.Company = "in2bits.org";
for (int sheetNumber = 1; sheetNumber <= 5; sheetNumber++)
{
string sheetName = "Sheet " + sheetNumber;
int rowMin = sheetNumber;
int rowCount = sheetNumber + 10;
int colMin = sheetNumber;
int colCount = sheetNumber + 10;
//创建5个表格
Worksheet sheet = xls.Workbook.Worksheets.AddNamed(sheetName);
Cells cells = sheet.Cells;
for (int r = 0; r < rowCount; r++)
{
if (r == 0)
{
for (int c = 0; c < colCount; c++)
{
//在一行内创建colCount个单元格
cells.Add(rowMin + r, colMin + c, "Fld" + (c + 1)).
Font.Bold = true;
}
}
else
{
for (int c = 0; c < colCount; c++)
{
int val = r + c;
Cell cell = cells.Add(rowMin + r, colMin + c, val);
if (val % 2 != 0)
{
cell.Font.FontName = "Times New Roman";
cell.Font.Underline = UnderlineTypes.Double;
//给文字下方加一个双下划线
cell.Rotation = 45;//单元格文字旋转45度
}
}
}
}
}