arbxcel

Description:

arbxcel

ARB Excel #
For reading, creating and updating ARB files from XLSX files.
Install #
pub global activate arbxcel
copied to clipboard
Basic Usage #
pub global run arbxcel

arbxcel [FLAGS] [OPTIONS] path/to/file/name

FLAGS
-n, --new New translation sheet
-a, --arb Export to ARB files
-e, --excel Import ARB files to sheet

OPTIONS
-s, --sheet Main sheet name (defaults to "Main")
-p, --placeholders Sheet name for predefined placeholders
copied to clipboard
Creates an XLSX template file.
pub global run arbxcel -n app.xlsx
copied to clipboard
Generates ARB files from a XLSX file.
pub global run arbxcel -a app.xlsx
copied to clipboard
Creates an XLSX file from ARB files.
pub global run arbxcel -e app_en.arb
copied to clipboard
Usage with Flutter Localizations #
dart run arbxcel:excel10n [FLAGS] [OPTIONS] path/to/file/name

FLAGS
-h, --help Show usage information

OPTIONS
--path Path containing the localization files (*.arb and *.xlsx files).
Defaults to "lib/src/l10n"
-e, --excel-source-file Excel file for generating the localization files.
Defaults to "app.xlsx"
-s, --excel-main-sheet-name Target Excel main sheet name.
Defaults to "Main"
-p, --excel-placeholder-sheet-name Target Excel placeholder sheet name.
Defaults to empty
-t, --template-arb-file Template ARB file for generating the localization files.
Defaults to "app_en.arb"
-o, --output-localization-file Output localization file for generating the localization files.
Defaults to "app_localizations.dart"
-f, --flutter-path Path to the flutter SDK.
Defaults to system's env path to flutter
copied to clipboard
Predefined Placeholders #
If you have multiple same placeholders, you can utilize the predefined placeholders feature by creating a separate excel sheet that has columns of "key" and its corresponding values in each language.
Note: each key can ONLY contain alphanumeric (a-Z, 0-9) and underscores ("_")
Example:


keyenid


date1"DateTime", "format": "yMd""DateTime", "format": "dMy"


To use it on the main sheet:


namedescriptionplaceholdersenid


payAtDateText for pay with date{"date": {"type": $date1}}Pay when {date}Bayar pada tanggal {date}


Generating will produce:
en.arb
{
"payAtDate": "Pay when {date}",
"@payAtDate": {
"placeholders": {
"date": {
"type": "DateTime",
"format": "yMd"
}
}
}
}
copied to clipboard
id.arb
{
"payAtDate": "Bayar pada tanggal {date}",
"@payAtDate": {
"placeholders": {
"date": {
"type": "DateTime",
"format": "dMy"
}
}
}
}
copied to clipboard