1.0.4 • Published 4 years ago
@dxmcorp/spreadsheet-parser v1.0.4
spreadsheet-parser
google spreadsheet parser
sheet example
==================================
code | kr | en
==================================
TestKey | 테스트 키 | Test Key
Group_login | 로그인 | Login
Group_confirm | 확인 | Confirm
----------------------------------
code example
const parser = require('@dxmcorp/spreadsheet-parser');
const spreadsheetId = '1aPnMLwzbWkwdHxWIuRGuWKUDXg6sXnBiYHGM-hezIy4';
const spreadsheetIndex = 1;
const options = {
separator: '_',
localeList: ['ko', 'en'],
fallbackLocale: 'ko',
codeName: 'code',
encoding: 'utf-8'
};
function writeJson(output, content, encoding='utf-8') {
const fs = require('fs');
const path = require('path');
fs.writeFile(path.resolve(__dirname, output), content, encoding, (err) => {
if (err)
throw new Error(err);
})
}
console.log('spreadsheet downloading...');
parser.parseSpreadsheet(spreadsheetId, spreadsheetIndex,function (err, data) {
if (err) {
console.log(err);
}
else if (data) {
console.log('locale parsing...');
let parsed = parser.parseLocale(data, options);
for (let locale in parsed) {
let output = `lang/${locale}.json`;
writeJson(output, JSON.stringify(parsed[locale], null, 2));
console.log(`convert to file : "${output}"`);
}
console.log('complete!');
}
});
output file
lang/ko.json
{
"TestKey": "테스트 키",
"Group": {
"login": "로그인",
"confirm": "확인"
}
}
lang/en.json
{
"TestKey": "Test Key",
"Group": {
"login": "Login",
"confirm": "Confirm"
}
}