114 lines
3.9 KiB
JavaScript
114 lines
3.9 KiB
JavaScript
|
const ExcelJS = require('exceljs');
|
|||
|
|
const fs = require('fs');
|
|||
|
|
const path = require('path');
|
|||
|
|
// example: npm run genrate:lang public/lang.xlsx(读取excel文件的路径) src/lang(输出文件路径)
|
|||
|
|
|
|||
|
|
function resolve(dir) {
|
|||
|
|
return path.resolve(__dirname, '..', dir);
|
|||
|
|
}
|
|||
|
|
const rawArgv = process.argv.slice(2);
|
|||
|
|
|
|||
|
|
let excelFilePath;
|
|||
|
|
let jsonFilePath;
|
|||
|
|
if (rawArgv.length === 0) {
|
|||
|
|
console.log('请输入Excel文件路径');
|
|||
|
|
process.exit(1);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (rawArgv.length === 1) {
|
|||
|
|
console.log('请输入语言包导出的文件路径');
|
|||
|
|
process.exit(1);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// 文件路径
|
|||
|
|
excelFilePath = resolve(rawArgv[0]);
|
|||
|
|
jsonFilePath = resolve(rawArgv[1]);
|
|||
|
|
const langFileNameEnum = {
|
|||
|
|
简体中文: 'zh-CN',
|
|||
|
|
English: 'en-US',
|
|||
|
|
};
|
|||
|
|
const keyIndex = 1; // 键值所在列
|
|||
|
|
const headerRowIndex = 1; // 标题行所在行索引
|
|||
|
|
|
|||
|
|
// 创建一个新的工作簿实例
|
|||
|
|
const workbook = new ExcelJS.Workbook();
|
|||
|
|
// 读取Excel文件
|
|||
|
|
workbook.xlsx
|
|||
|
|
.readFile(excelFilePath)
|
|||
|
|
.then(async () => {
|
|||
|
|
// 生成json映射文件，new Map(){sheetName:{ lang:jsonData}}
|
|||
|
|
const dataMap = getJsonDataMap(workbook)
|
|||
|
|
// 生成json文件
|
|||
|
|
await generateJsonFiles(dataMap)
|
|||
|
|
})
|
|||
|
|
.catch((error) => {
|
|||
|
|
console.error('Error reading Excel file:', error);
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
/**
|
|||
|
|
* 从工作簿中获取JSON数据映射表
|
|||
|
|
* @param {object} workbook - Excel工作簿对象，用于遍历工作表和工作表数据
|
|||
|
|
* @returns {Map} dataMap - 包含工作表名称和对应数据对象的映射表，其中数据对象是语言文件名枚举和其键值对的映射
|
|||
|
|
*/
|
|||
|
|
function getJsonDataMap(workbook) {
|
|||
|
|
const dataMap = new Map();
|
|||
|
|
workbook.eachSheet(function (worksheet) {
|
|||
|
|
// 初始化工作表名和文件对象
|
|||
|
|
const sheetName = worksheet._name;
|
|||
|
|
const fileObjects = {};
|
|||
|
|
const cellIndexMap = {};
|
|||
|
|
// 遍历每一行，首先处理表头，然后处理数据行
|
|||
|
|
worksheet.eachRow((row, rowNumber) => {
|
|||
|
|
if (rowNumber === headerRowIndex) {
|
|||
|
|
// 处理表头，建立语言文件名和列索引的映射
|
|||
|
|
row.eachCell((cell, colNumber) => {
|
|||
|
|
if (colNumber !== keyIndex) {
|
|||
|
|
fileObjects[langFileNameEnum[cell.value]] = {};
|
|||
|
|
cellIndexMap[colNumber] = langFileNameEnum[cell.value];
|
|||
|
|
}
|
|||
|
|
});
|
|||
|
|
} else {
|
|||
|
|
// 处理数据行，根据列索引映射填充语言文件的数据键值对
|
|||
|
|
Object.keys(cellIndexMap)
|
|||
|
|
.map((item) => Number(item))
|
|||
|
|
.map((colNumber) => {
|
|||
|
|
const key = row.getCell(keyIndex).value;
|
|||
|
|
const value = row.getCell(colNumber).value || '';
|
|||
|
|
const lang = cellIndexMap[colNumber];
|
|||
|
|
fileObjects[lang][key] = value;
|
|||
|
|
});
|
|||
|
|
}
|
|||
|
|
});
|
|||
|
|
// 将工作表数据对象映射到工作表名称
|
|||
|
|
dataMap.set(sheetName, fileObjects);
|
|||
|
|
});
|
|||
|
|
return dataMap;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// 导出语言包文件到指定目录
|
|||
|
|
async function generateJsonFiles(dataMap) {
|
|||
|
|
// 清空文件输出目录
|
|||
|
|
const exist = fs.existsSync(jsonFilePath)
|
|||
|
|
exist && await fs.rmSync(jsonFilePath, { recursive: true }, () => { })
|
|||
|
|
// 逐个生成目录和文件
|
|||
|
|
for (const [modules, objs] of dataMap.entries()) {
|
|||
|
|
for (const [lang, jsonData] of Object.entries(objs)) {
|
|||
|
|
const path = resolve(jsonFilePath + `/${lang}/${modules}.json`);
|
|||
|
|
await writeJsonToFile(jsonData, path);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
console.log('Excel file has been converted to JSON and saved to', jsonFilePath);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// 异步创建文件夹并写入JSON数据
|
|||
|
|
async function writeJsonToFile(jsonData, filePath) {
|
|||
|
|
const dirPath = path.dirname(filePath); // 获取文件路径的目录部分
|
|||
|
|
try {
|
|||
|
|
await fs.mkdirSync(dirPath, { recursive: true }, () => { }); // 如果目录不存在，会递归创建
|
|||
|
|
await fs.writeFileSync(filePath, JSON.stringify(jsonData, null, 2), 'utf8', () => { }); // 异步写入JSON数据
|
|||
|
|
console.log(`JSON data written to ${filePath}`);
|
|||
|
|
} catch (err) {
|
|||
|
|
console.error(`Error writing JSON data to ${filePath}:`, err);
|
|||
|
|
}
|
|||
|
|
}
|