i18n-xlsx-to-json-directory
Library that converts and downloads multilingual data stored in xlsx files into a JSON directory structure, and vice versa. The directory structure is tailored to the i18next library.
Features
Supporting a wide variety of execution environments
Supports direct execution via npx commands. It also supports importing from browser and Node environments.
Select whether to compress the JSON directory
When converting to a JSON directory, you can choose whether to compress to a zip file. It's also possible in reverse.
Auto-creating index.js/ts files
You can choose whether to create an index.js/ts file for importing multilingual data into your project.
Can create template xlsx files
Create a template xlsx file to get you started easily.
Direct usage
Examples of commands that can be executed directly from the terminal include the following.
Without auto-compressing/extracting JSON directory and auto-generating index.js:
npx i18n-xlsx-to-json-directory template-xlsx -d ./template_i18n.xlsx
npx i18n-xlsx-to-json-directory xlsx-to-json-zip -s ./template_i18n.xlsx -d ./i18n.zip --export-file-type js
npx i18n-xlsx-to-json-directory json-zip-to-xlsx -s ./i18n.zip -d ./i18n.xlsxWith auto-compressing/extracting JSON directory auto-generating index.ts:
npx i18n-xlsx-to-json-directory template-xlsx -d ./template_i18n.xlsx
npx i18n-xlsx-to-json-directory xlsx-to-json-zip -s ./template_i18n.xlsx -d ./i18n --export-file-type ts --auto-extract
npx i18n-xlsx-to-json-directory json-zip-to-xlsx -s ./i18n -d ./i18n.xlsx --auto-compresstemplate-xlsx
Create and save template xlsx files.
options
-d, --destination: The path on which the converted file will be stored.
xlsx-to-json-zip
After converting the xlsx file into a json directory structure, compress it to create and download a zip file.
options
-s, --source: The path to import the file you want to convert.
-d, --destination: The path on which the converted file will be stored.
--auto-extract: Automatically decompress converted zip files. You must specify a directory in the -d option.
--export-file-type: Creates a default index script file that exports each language and namespace.('js' || 'ts' || undefined)
json-zip-to-xlsx
After analyzing the zip file, create and download the xlsx file.
options
-s, --source: The path to import the file you want to convert.
-d, --destination: The path on which the converted file will be stored.
--auto-compress: Automatically compresses and converts the selected directory. You must specify a directory in the -d option.
Usage in a browser environment
Import the library into the script file as follows.
import {
createTemplateXlsx,
convertXlsxToJsonZip,
convertJsonZipToXlsx,
} from 'i18n-xlsx-to-json-directory/browser';createTemplateXlsx()
Create and save template xlsx files.
convertXlsxToJsonZip(file, options)
After converting the xlsx file into a json directory structure, compress it to create and download a zip file.
options
exportFileType: Creates a default index script file that exports each language and namespace.('js' || 'ts' || undefined)
convertJsonZipToXlsx(file)
After analyzing the zip file, create and download the xlsx file.
Usage in Node.js environment
Import the library into the script file as follows.
import {
createTemplateXlsx,
convertXlsxToJsonZip,
convertJsonZipToXlsx,
} from 'i18n-xlsx-to-json-directory/node';createTemplateXlsx(destination)
Create and save template xlsx files.
convertXlsxToJsonZip(source, destination, options)
After converting the xlsx file into a json directory structure, compress it to create and download a zip file.
options
autoExtract: Automatically decompress converted zip files. You must specify a directory in the -d option.
exportFileType: Creates a default index script file that exports each language and namespace.('js' || 'ts' || undefined)
convertJsonZipToXlsx(source, destination, options)
After analyzing the zip file, create and download the xlsx file.
options
autoCompress: Automatically compresses and converts the selected directory. You must specify a directory in the -d option.
Troubleshooting
SSL certificate issue occurred with SheetJS dependency.
You can fix the problem by referring to the SheetJS library website.
Contributing
Pull requests are always welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.