`openxlsx`：加载并应用读取文件中的所有格式

const openxlsx = require('openxlsx');

// 读取 Excel 文件
const workbook = openxlsx.load('path/to/your/file.xlsx');

// 获取第一个工作表
const worksheet = workbook.worksheets[0];

// 遍历工作表中的所有单元格
worksheet.eachRow(function(row, rowNumber) {
    row.eachCell(function(cell, colNumber) {
        console.log(`Row ${rowNumber}, Column ${colNumber}: ${cell.value}`);
        // 应用单元格格式
        const cellRef = openxlsx.utils.encode_cell({r: rowNumber, c: colNumber});
        const cellStyle = worksheet[cellRef].style;
        console.log(`Style: ${JSON.stringify(cellStyle)}`);
    });
});

// 保存修改后的工作簿
workbook.save('path/to/your/output/file.xlsx');

const workbook = openxlsx.load('path/to/your/file.xlsx', {cellStyles: true});

const cellRef = openxlsx.utils.encode_cell({r: 0, c: 0});
worksheet[cellRef].style = {
    font: { name: 'Arial', sz: 14, color: { rgb: 'FF0000' } },
    fill: { fgColor: { rgb: 'FFFF00' } }
};