1.0.3 • Published 2 years ago
excel2lang v1.0.3
excel2lang
excel2lang is a small utility program which takes a xlsx file as an input and extracts the languages strings to a JSON format. It has several cool features:
- Support comment lines
- Can create multiple files
- Use the first column as default if no value
Installation
npm install -g excel2lang
Usage
excel2lang input.xlsx
xlsx format
Your excel must be like this:
# | Unique ID | English | French |
---|---|---|---|
C | id | en | fr |
F | ./{lang}.json | ||
# | Generic | ||
open | Open | Ouvrir | |
browse | Browse | Parcourir | |
edit | Edit | Modifier | |
select | Select | Selectionner | |
F | ./topbar/{lang}.json | ||
# | Topbar | ||
topbar/file | File | Fichier | |
topbar/help | Help | Aide |
The first column indicates what the line is for:
Character | Description |
---|---|
nothing | Regular line of strings. |
C | Code line, indicating the language code for each column. |
F | The JSON file to create. Will include all lines until the end of the file or another F line. The {lang} substring will be replace by the current language code. |
# | Comment line. |
In order to work, a C line MUST be the first line of the excel sheet (beside comment line). Also, a F line MUST be present before the first string line.
TODO
- More checks for errors