/// <summary> /// Colses the alighment. /// </summary> /// <param name="xlsSheet">The XLS sheet.</param> /// <param name="startRow">The start row.</param> /// <param name="endRow">The end row.</param> /// <param name="cols">The cols.</param> /// <param name="HAlight">The H alight.</param> private void ColsAlighment(IWorksheet xlsSheet, int[] cols, ExcelHAlign HAlight) { for (int i = 0; i < cols.Length; i++) { ColAlighment(xlsSheet, cols[i], HAlight); } }
/// <summary> /// 单元格文字对齐方式 /// </summary> /// <param name="startRow">起始行</param> /// <param name="startColumn">起始列</param> /// <param name="endRow">结束行</param> /// <param name="endColumn">结束列</param> /// <param name="hAlign">水平对齐</param> /// <param name="vAlign">垂直对齐</param> public void CellsAlignment(int startRow, int startColumn, int endRow, int endColumn, ExcelHAlign hAlign, ExcelVAlign vAlign) { Range range = myExcel.get_Range(myExcel.Cells[startRow, startColumn], myExcel.Cells[endRow, endColumn]); range.HorizontalAlignment = hAlign; range.VerticalAlignment = vAlign; }
/// <summary> /// Cells the alighment. /// </summary> /// <param name="xlsSheet">The XLS sheet.</param> /// <param name="startRow">The start row.</param> /// <param name="startCol">The start col.</param> /// <param name="endRow">The end row.</param> /// <param name="endCol">The end col.</param> /// <param name="HAlight">The H alight.</param> /// <param name="VAlight">The V alight.</param> private void CellAlighment(IWorksheet xlsSheet, int startRow, int startCol, int endRow, int endCol, ExcelHAlign HAlight, ExcelVAlign VAlight) { xlsSheet.Range[startRow, startCol, endRow, endCol].CellStyle.HorizontalAlignment = HAlight; xlsSheet.Range[startRow, startCol, endRow, endCol].CellStyle.VerticalAlignment = VAlight; }
/// <summary> /// Cols the alighment. /// </summary> /// <param name="xlsSheet">The XLS sheet.</param> /// <param name="startRow">The start row.</param> /// <param name="endRow">The end row.</param> /// <param name="col">The start col.</param> /// <param name="HAlight">The H alight.</param> private void ColAlighment(IWorksheet xlsSheet, int col, ExcelHAlign HAlight) { xlsSheet.Range[1, col, ROW_MAXIMUM, col].CellStyle.HorizontalAlignment = HAlight; xlsSheet.Range[1, col, ROW_MAXIMUM, col].CellStyle.VerticalAlignment = ExcelVAlign.VAlignCenter; }
/// <summary> /// 单元格文字对齐方式 /// </summary> /// <param name="startRow">起始行</param> /// <param name="startColumn">起始列</param> /// <param name="endRow">结束行</param> /// <param name="endColumn">结束列</param> /// <param name="hAlign">水平对齐</param> /// <param name="vAlign">垂直对齐</param> public void CellsAlignment(int startRow, int startColumn, int endRow, int endColumn, ExcelHAlign hAlign, ExcelVAlign vAlign) { Excel.Range range = myExcel.get_Range(myExcel.Cells[startRow, startColumn], myExcel.Cells[endRow, endColumn]); range.HorizontalAlignment = hAlign; range.VerticalAlignment = vAlign; }