Download the PHP package codemix/yii2-excel-message without Composer
On this page you can find all versions of the php package codemix/yii2-excel-message. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package yii2-excel-message
Yii2 Excel Message
Translate messages via Excel files.
Features
With this extension you can export messages from PHP message files to Excel, send them to your translators and read them back into your message files.
Note: To read and write to and from Excel file, we use the excellent PhpSpreadsheet package.
Installation
Install the package with composer.
composer require codemix/yii2-excel-messageThen update your console configuration:
Creating Excel files with new translations
To create Excel files with new translations, you need to supply the Yii2 message configuration and the output directory where the files should be written to:
This will create one file per language (filename == language) with one sheet per
category. The source messages are listed in column A. Translators should add their
translations to column B.
The files will be in Excel2007 format with xlsx extension.
If you want a file with all translations instead, pass all as 3rd argument. You can
also export only certain languages or categories:
Update PHP message files from Excel files
After you receive the Excel files back from your translators you can update your PHP message files. Again you need to supply the Yii2 message configuration and the directory path where your Excel files are:
This will add the new translations to your PHP message files. Yes it's really that simple.
You can also pass a third parameter with the file extension, the default is xlsx
as used by Excel 2007+ files. PhpSpreadsheet should also autodetect other Excel formats
Note: The files must be provided in the same format as they where created by the export:
- One file per language with language code as filename
- One sheet per category
- Source messages in column
A, translations in columnB- First line is skipped.
Options
You can use the following options.
| Option | Description |
|---|---|
--languages=aa,bb,cc |
Comma separated list of languages to process. |
--categories=cat1,cat2 |
Comma separated list of categories to process. |
--ignoreLanguages=aa,bb,cc |
Comma separated list of languages to ignore. This option is ignored if --languages is used. |
--ignoreCategories=cat1,cat2 |
Comma separated list of categories to ignore. This option is ignored if --categories is used. |
--lineHeight=x |
export only: The line height to set on the excel file. The default is auto but this does not work if the file is openend in LibreOffice Calc. So you can set a fixed line height like 50 here as a workaround. |
