Function htmlToGridSettings

handsontable/src/utils/parseTable.ts:271–447

(element: HTMLTableElement | string, rootDocument: Document = document)

 */
// eslint-disable-next-line no-restricted-globals
export function htmlToGridSettings(element: HTMLTableElement | string, rootDocument: Document = document) {
  const settingsObj: Record<string, unknown> = {};
  const fragment = rootDocument.createDocumentFragment();
  const tempElem = rootDocument.createElement('div');

  fragment.appendChild(tempElem);

  let checkElement: HTMLTableElement | string | null = element;

  if (typeof checkElement === 'string') {
    // Use replaceTdCellsWithTextContent so nested <td> (e.g. Excel shape cells) are matched correctly
    const normalizedHTML = replaceTdCellsWithTextContent(checkElement);

    tempElem.insertAdjacentHTML('afterbegin', normalizedHTML);
    checkElement = tempElem.querySelector<HTMLTableElement>('table');
  }

  if (!checkElement || !isHTMLTable(checkElement as HTMLElement)) {
    return;
  }

  const el: HTMLTableElement = checkElement as HTMLTableElement;
  const generator = tempElem.querySelector('meta[name$="enerator"]') as HTMLMetaElement | null;
  const hasRowHeaders = el.querySelector('tbody th') !== null;
  const trElement = el.querySelector('tr') as HTMLTableRowElement | null;
  const countCols = !trElement ? 0 : (Array.from(trElement.cells)
    .reduce((cols: number, cell: HTMLTableCellElement) => cols + cell.colSpan, 0)) - (hasRowHeaders ? 1 : 0);
  const fixedRowsBottom: HTMLTableRowElement[] = el.tFoot && Array.from(el.tFoot.rows) || [];
  const fixedRowsTop: HTMLTableRowElement[] = [];
  let hasColHeaders = false;
  let thRowsLen = 0;
  let countRows = 0;

  if (el.tHead) {
    const thRows = Array.from(el.tHead.rows).filter((tr: HTMLTableRowElement) => {
      const isDataRow = tr.querySelector('td') !== null;

      if (isDataRow) {
        fixedRowsTop.push(tr);
      }

      return !isDataRow;
    });

    thRowsLen = thRows.length;
    hasColHeaders = thRowsLen > 0;

    if (thRowsLen > 1) {
      settingsObj.nestedHeaders = Array.from(thRows).reduce((rows: unknown[], row: HTMLTableRowElement) => {
        const headersRow = Array.from(row.cells).reduce(
          (headers: unknown[], header: HTMLTableCellElement, currentIndex: number) => {
            if (hasRowHeaders && currentIndex === 0) {
              return headers;
            }

            const {
              colSpan: colspan,
              innerHTML,