Compass helpers for browser platforms
    Preparing search index...

    Function numberToExcelColumn

    • 将数值转为Excel列名

      Parameters

      • columnNumber: number

        列的数值(从1开始)

      Returns string

      Excel列名字符串

      当输入不是正整数时抛出错误

      console.log(numberToExcelColumn(1));   // 输出: "A"
      console.log(numberToExcelColumn(26)); // 输出: "Z"
      console.log(numberToExcelColumn(27)); // 输出: "AA"
      console.log(numberToExcelColumn(28)); // 输出: "AB"
      console.log(numberToExcelColumn(702)); // 输出: "ZZ"
      console.log(numberToExcelColumn(703)); // 输出: "AAA"