spreadsheets

import { numToSSColumnLetter } from '@bbc/front-end-kit/js/utils/spreadsheets';

Utility functions for working with spreadsheet data.

numToSSColumnLetter(num)

Converts a positive integer to an Excel-style column letter. Uses the same base-26 bijective numeration that spreadsheet applications use (1 → A, 26 → Z, 27 → AA, etc.).

Parameters

• num (number): A positive integer to convert.

Returns

string — the Excel-style column letter (e.g. 'A', 'Z', 'AA'), or undefined if num is 0 or negative.

Example

import { numToSSColumnLetter } from '@bbc/front-end-kit/js/utils/spreadsheets';

numToSSColumnLetter(1);   // 'A'
numToSSColumnLetter(26);  // 'Z'
numToSSColumnLetter(27);  // 'AA'
numToSSColumnLetter(703); // 'AAA'
numToSSColumnLetter(0);   // undefined
numToSSColumnLetter(-1);  // undefined