/// <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;
}
