C# 解决EXCEL单元格合并,行高无法自适应问题

public static float getExcelCellAutoHeight(string strtest, float fontCountInline)

  {

      float defaultRowHeight = 18.00f;//每一行的高度指定

      float defaultCount = 0.00f;

      for (int i = 0; i <strtest.Length; i++)

      {

          float ff = getRegex(strtest.Substring(i, 1));

          defaultCount = defaultCount + ff;

      }

      return ((int)(defaultCount / fontCountInline) + 1) * defaultRowHeight;//计算

  }