如何使用NodeJs或nodejs节点模块删除excel表格中的列

npm install xlsx fs

const xlsx = require('xlsx');
const fs = require('fs');

const workbook = xlsx.readFile('path/to/excel/file.xlsx');

const worksheet = workbook.Sheets['Sheet1']; // 替换'Sheet1'为实际的工作表名称

const range = xlsx.utils.decode_range(worksheet['!ref']);
const columnToDelete = 2; // 替换为要删除的列的索引（从1开始）
for (let r = range.s.r; r <= range.e.r; r++) {
  const cellAddress = xlsx.utils.encode_cell({ c: columnToDelete - 1, r: r });
  delete worksheet[cellAddress];
}

const newWorkbook = xlsx.utils.book_new();
xlsx.utils.book_append_sheet(newWorkbook, worksheet, 'Sheet1'); // 替换'Sheet1'为实际的工作表名称
xlsx.writeFile(newWorkbook, 'path/to/new/excel/file.xlsx');

const xlsx = require('xlsx');
const fs = require('fs');

const workbook = xlsx.readFile('path/to/excel/file.xlsx');
const worksheet = workbook.Sheets['Sheet1']; // 替换'Sheet1'为实际的工作表名称

const range = xlsx.utils.decode_range(worksheet['!ref']);
const columnToDelete = 2; // 替换为要删除的列的索引（从1开始）
for (let r = range.s.r; r <= range.e.r; r++) {
  const cellAddress = xlsx.utils.encode_cell({ c: columnToDelete - 1, r: r });
  delete worksheet[cellAddress];
}

const newWorkbook = xlsx.utils.book_new();
xlsx.utils.book_append_sheet(newWorkbook, worksheet, 'Sheet1'); // 替换'Sheet1'为实际的工作表名称
xlsx.writeFile(newWorkbook, 'path/to/new/excel/file.xlsx');