iandis/arbxcel

Generates ARB files from an Excel file or create an Excel file from ARB files.

ARB Excel

For reading, creating and updating ARB files from XLSX files.

Install

pub global activate arbxcel

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

Creates an XLSX template file.

pub global run arbxcel -n app.xlsx

Generates ARB files from a XLSX file.

pub global run arbxcel -a app.xlsx

Creates an XLSX file from ARB files.

pub global run arbxcel -e app_en.arb

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

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:

key	en	id
date1	"DateTime", "format": "yMd"	"DateTime", "format": "dMy"

To use it on the main sheet:

name	description	placeholders	en	id
payAtDate	Text 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"
      }
    }
  }
}

id.arb

{
  "payAtDate": "Bayar pada tanggal {date}",
  "@payAtDate": {
    "placeholders": {
      "date": {
        "type": "DateTime",
        "format": "dMy"
      }
    }
  }
}