sheetのdataをobjectで取得する関数

[udayan28]

const getData = (
  sheet: GoogleAppsScript.Spreadsheet.Sheet,
): { [name: string]: unknown }[] => {
  const range = sheet.getDataRange();
  const values = range.getValues();

  const data: { [name: string]: unknown }[] = [];
  const headers = values[0];
  const sheetData = values.slice(1);

  for (let i = 0; i < sheetData.length; i++) {
    const obj = {};

    for (let j = 0; j < headers.length; j++) {
      obj[headers[j]] = sheetData[i][j];
    }

    data.push(obj);
  }

  return data;
};