Advance Excel Import allows to import data without writing import script for each project, using this package you will be able to import data using a GUI interface withouth writing any script.
Via Composer
composer require sunarctech/excel-import
Just install this package and make changes accordingly in configuration file
- Import an excel file
- Maintain session lifetime for file to be saved on server via configuration
- Supports xls,xlsx.csv
- Choose table name and column on which excel data need to be imported
Add the field which you wish should not be imported
'fields_to_be_excluded' => [
'id', 'created_at', 'updated_at', 'deleted_at'
],
Define the public path where to file should be uploaded, and read.
'default_path' => 'assets/excel/global',
Define the lifetime for a import session in minutes.
'session_lifetime' => 10,
php artisan vendor:publish --provider="Sunarc\ImportExcel\ImportExcel\ImportExcelServiceProvider" --tag="config"
- doctrine/dbal
- illuminate/support
- maatwebsite/excel
- php_zip
- php_xml
- php_gd2
- php_iconv
- php_simplexml
- php_xmlreader
- php_zlib
Two routes been registered automatically which allows to import the file and choose the columns. Using import as prefix.
- youdomainname/import/file-upload
- Using this route you can upload the file which will be saved into public storage.
- youdomainname/import/start-import
- This will be used for selection and import process start.
Sample File - sampleimport.xlsx
We are the leading Software Development Company providing end-to-end IT services & solutions to our esteemed customers in multiple industries and domains for the past 18+ years? Give us a call.
https://sunarctechnologies.com/
info@sunarctechnologies.com
+91-8764025209
Versions supported.
Version | Laravel Version | PHP Version | Support |
---|---|---|---|
0.1 | <=7.0 | 7.3 - 8.x | All features |
The MIT Public License. Please see LICENSE for more information.