Insert additional column that not in excel file

arogachev / yii2-excel

ActiveRecord import and export based on PHPExcel for Yii 2 framework

Other

64 stars 25 forks source link

Insert additional column that not in excel file #41

Closed waisan closed 7 years ago

waisan commented 7 years ago

Hi,

how can I add in the additional column that are not in the excel file? in my excel file => | id | name | description | when import, I wanna have another attribute called 'created_at' and assign current date to this field. how can I achieve this?

Thanks if anyone can help.

arogachev commented 7 years ago

There are 2 main options:

Handle it on database side with correct definition of table's column. This can vary depending on used RDBMS. Here is an example for MySQL.
Use framework's tools. Yii2 has a special behavior exactly for these purposes, it's called TimestampBehavior.