|
rcent.Columns.Count - 2], worksheet.Cells["B1:M1"]);
//chartSerie.HeaderAddress = worksheet.Cells[row + 1, 1];//设置每条线的名称
//垂直居中
worksheet.Cells.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
//水平居中
worksheet.Cells.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
//单元格是否自动换行
worksheet.Cells.Style.WrapText = false;
//单元格自动适应大小
worksheet.Cells.Style.ShrinkToFit = true;
//合并单元格
//worksheet.Cells[2, 1, 2, 2].Merge = true;
//worksheet.Cells[int fromRow, fromCol, int toRow,int toCol].Merge = true;
//冻结首行（行号，列号）
worksheet.View.FreezePanes(2, 1);
////冻结1-2列
//worksheet.View.FreezePanes(1, 3);
//新建一个 Excel 文件
string filePath = @"C:\Users\Lenovo\Desktop\" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + ".xlsx";
FileStream fileStream = new FileStream(filePath, FileMode.Create);
package.SaveAs(fileStream);
//package.Save();
fileStream.Close();
fileStream.Dispose();
worksheet.Dispose();
package.Dispose();
GC.Collect();
三 效果
|