Aspose.cell操作Excel使用合集

Cells cells = sheet.Cells;

Style style = workbook.Styles[workbook.Styles.Add()];
style.Font.IsBold = true;
style.Font.Name = "宋体";
style.Font.Size = 12;
//固定模板头
//居中、画边框、粗体、背景色为浅蓝
style = workbook.Styles[workbook.Styles.Add()];
style.HorizontalAlignment = TextAlignmentType.Center; //文字居中
style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
style.ForegroundColor = System.Drawing.Color.FromArgb(191, 191, 191);
style.Pattern = BackgroundType.Solid;
style.Font.IsBold = true;

//采样日期的格式
Style dateStyle = workbook.Styles[workbook.Styles.Add()];
dateStyle.Custom = "yyyy-MM-dd";

//采样时分的格式
Aspose.Cells.Style timeStyle = workbook.Styles[workbook.Styles.Add()];
timeStyle.Custom = "hh:mm";

//设置行高
cells.SetRowHeight(rowNum, 30);


sheet.FreezePanes(ROW_DATASTART, 0, ROW_DATASTART, 0); //冻结列头内容 
//列头设置统一样式      
style.Font.Color = System.Drawing.Color.FromArgb(0, 0, 0);
Range dateDeatailRange = sheet.Cells.CreateRange(0, 0, ROW_DATASTART, colNum);
StyleFlag dateDeatailFlg = new StyleFlag();
dateDeatailFlg.All = true;
dateDeatailRange.ApplyStyle(style, dateDeatailFlg);

//设置单元格样式
cells[1, i].SetStyle(styleSubtitle);

/*设置单元格样式-方法2*/
var contentStyle = cells[i + 1, j].GetStyle();//得到原本样式
contentStyle.HorizontalAlignment = TextAlignmentType.Center;//在原本样式的基础上设置新的样式
cells[i + 1, j].SetStyle(contentStyle);  //重新设置

sheet.AutoFitColumns(); //自适应列宽
//隐藏不需要的行
cells.HideRow(ROW_LHCODEID);
 
//单元格设置值
sheet.Cells[rowNum, j].PutValue("内容");

//设置数字格式-设置展示小数位
Aspose.Cells.Style numberStyle = sheet.Cells[rowNum, colNo].GetStyle();
numberStyle.Number = 2;
sheet.Cells[rowNum, colNo].SetStyle(numberStyle);