Download the PHP package frvaillant/entitytoexcel without Composer
On this page you can find all versions of the php package frvaillant/entitytoexcel. 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 entitytoexcel
EntityToExcel
This package adds a command to your symfony project. You'll be able to export excel files representing your entities in order to help you to fill database with client data.
This program doesn't export any data. It just export structure of your data inb order to help you and/or your clients to give you data well formatted before import them.
Requirements
Symfony > 4.4
php > 7.0
Read before
This software is free to use, modify and share. It's made with a lot of love but comes without any guarantee.
Install
first run
composer require frvaillant/entitytoexcel
Edit your config/services.yaml file and add under services key :
run
launch command in your terminal :
php bin/console entity:excel Entity
Replace Entity by the name of the entity you want to export as excel file
The file is exported as Entity.xlsx in the public/xls directory
Excel file description
Each property of your entity is reported on each column of the table.
On the first line, the name of the property
On the second line, the display name (if you choose some (see below))
On the third line, the default values
Get more
The package comes with an annotation class wich allows you to be more precise
Use it with @EtEx()
-
exclude field
If you want to exclude one of your entity properties from your excel file : -
Add a dropdown value selector
if you want to add choices to fill cells, you can add a list parameter as below -
Add a dropdown selector from another entity
If your property is for example a ManyToOne Relation with another entity, you can list the values from your entity usin the listFromEntityWith argument.
This argument needs the name of the field you want to use to list your linked entity. -
Default value
You can add a default value. This value will fill the cell on the third line as an example. -
display name
By default, the title of each column is the name of the property in the entity.
But sometimes, you'll probably want to display a translation of the terms used in entity definition.
To do this, you can add a displayName paramater - Add sheets from other entities
If your entity is linked with some others. For example your entity "Person" represents some persons, and some of them are musicians.
You probably need some more informations about musicians wich are represented by the "Musician" entity.
With theincludeFieldsparameter, you will generate another sheet in your excel file with the properties of the Musician entity.
You can use one of the above parameters, and of course you can use as much filters as you like
Future development
The reverse side of this program is on the way in order to import data following excel files.
To be continued ...
Feel free to report any encountered problem using issues on github
Github repository : https://github.com/frvaillant/EntityToExcel/
