Function createSpreadsheetData

handsontable/src/helpers/data.ts:53–68

(rows: number = 100, columns: number = 4)

 * @returns {Array}
 */
export function createSpreadsheetData(rows: number = 100, columns: number = 4): string[][] {
  const _rows = [];
  let i;
  let j;

  for (i = 0; i < rows; i++) {
    const row = [];

    for (j = 0; j < columns; j++) {
      row.push(spreadsheetColumnLabel(j) + (i + 1));
    }
    _rows.push(row);
  }

  return _rows;
}

/**
 * Creates 2D array of Excel-like values "A1", "A2", as an array of objects.