问将行数据移动到某些选项卡

EN

function main(workbook: ExcelScript.Workbook) {
  //get the used range, assuming there is one worksheet
  let worksheet = workbook.getActiveWorksheet();
  let range = worksheet.getUsedRange();
  let rangeValues = range.getValues();
  
  // create an array to hold all the unique values in the first column skipping the header row
  let firstCol: string[] = [];
  rangeValues.forEach((curRow, index) => {
    if (index > 0) {
      firstCol.push(curRow[0].toString());
    }
  });
  let uniqueFirstCol = firstCol.filter((val, ind, arr) => arr.indexOf(val) === ind);

  // run thru all the unique values, filter as appropriate and add filtered values to new worksheets
  uniqueFirstCol.forEach(v => {
    let tempValues = rangeValues.filter((row, index) => row[0] === v);
    let newSheet = workbook.addWorksheet(v);
    let newRange = newSheet.getRangeByIndexes(1,0, tempValues.length, tempValues[0].length);
    newRange.setValues(tempValues);
    newSheet.getRangeByIndexes(0,0, 1, rangeValues[0].length).setValues([rangeValues[0]])
  });
}