查找行中的最后一项，然后返回该列顶行单元格的值

const ExcelJS = require('exceljs');

async function findLastItem() {
  const workbook = new ExcelJS.Workbook();
  await workbook.xlsx.readFile('path/to/file.xlsx');
  
  const worksheet = workbook.getWorksheet('Sheet1');
  const rowRange = worksheet.getRow(1).values;
  const columnRange = worksheet.getColumn(1).values;
  
  let lastRowIndex = -1;
  let lastColumnIndex = -1;
  
  // Find the last item in the row range
  for (let i = 0; i < rowRange.length; i++) {
    if (rowRange[i] === undefined) {
      lastRowIndex = i - 1;
      break;
    }
  }
  
  // Find the last item in the column range
  for (let i = 0; i < columnRange.length; i++) {
    if (columnRange[i] === undefined) {
      lastColumnIndex = i - 1;
      break;
    }
  }
  
  // Get the value of the top cell in the last column
  const lastItemValue = worksheet.getCell(lastRowIndex + 1, lastColumnIndex + 1).value;
  
  console.log('The value of the top cell in the last column is:', lastItemValue);
}

findLastItem();