|
static private ReferenceToColRow ( string reference ) : int>.Tuple |
||
| reference | string | |
| 리턴 | int>.Tuple | |
/// <summary>
/// Create a CellAddress from a Reference like A1
/// </summary>
/// <param name="cellAddress"></param>
public CellAddress(string cellAddress)
{
var cr = CellAddressHelper.ReferenceToColRow(cellAddress);
Column = cr.Item1;
Row = cr.Item2;
}
/// <summary>
/// Insert a manual page break to the left of the column specified by the cell address (e.g., B5)
/// </summary>
/// <param name="sheet"></param>
/// <param name="cellAddress"></param>
public static void InsertManualPageBreakAfterColumn(this Worksheet sheet, string cellAddress)
{
CellAddressHelper.ReferenceToColRow(cellAddress, out int row, out int col);
sheet.InsertManualPageBreakAfterColumn(col + 1);
}