README.md
September 6, 2022 Β· View on GitHub
β‘ Why need this?
i18n messages is stored in Excel file, but it is not easy to edit in your code. So, this tool is created to convert Excel to JSON.
π Features
Excel data structure is converted to JSON. The key of the first column of the first row is required.
| key | zh_CN | zh_HK | en | and more languages... |
|---|---|---|---|---|
| hello | δ½ ε₯½ | δ½ ε₯½ | hello | ... |
| world | δΈη | δΈη | world! | ... |
output JSON:
{
"zh_CN": {
"hello": "δ½ ε₯½",
"world": "δΈη",
},
"zh_HK": {
"hello": "δ½ ε₯½",
"world": "δΈη",
},
"en": {
"hello": "hello",
"world": "world!",
}
}
π Installation
Using npm:
$ npm install -g excel-to-json-parser
Using yarn:
$ yarn global add excel-to-json-parser
π₯ Usage
run etj --help without arguments to see list of options:
Usage: etj --sourceFile <dir>
Options:
-V, --version output the version number
-s, --sourceFile <dir> source file path need to be converted
-h, --help display help for command
use CLI
etj --sourceFile /yourdir/example.xlsx
// or
etj -s /yourDir/example.xlsx
π§ Examples
run example
yarn example