NPOI R1C1引用样式转A1引用样式

using NPOI;
using NPOI.SS.UserModel;
using NPOI.HSSF.UserModel;
using NPOI.SS.Util;
using System.Text.RegularExpressions;

/// <summary>
/// R1C1样式转A1样式
/// </summary>
/// <param name="R1C1Str">R1C1地址</param>
/// <returns>对应A1样式地址</returns>
public string R1C1ToA1(string R1C1Str) 
{
    string A1 = String.Empty;
    Regex R1C1_reg = new Regex(@"^R\d+C\d+$");
    //检测是否是R1C1格式
    if (R1C1_reg.IsMatch(R1C1Str)) {
        Regex regex = new Regex(@"^R(\d+)C(\d+)$");
        int row = Convert.ToInt32(regex.Match(R1C1Str).Groups[1].Value);
        int col = Convert.ToInt32(regex.Match(R1C1Str).Groups[2].Value);
        A1=new CellReference(row-1, col-1).FormatAsString();
    }
    return A1;
}

R1C1ToA1("R1C1")  输出：A1

R1C1ToA1("R1C3")  输出：C1