{"repo":"rap2hpoutre/fast-excel","free":true,"listed":false,"github":"https://github.com/rap2hpoutre/fast-excel","clone":"git clone https://github.com/rap2hpoutre/fast-excel.git","description":"🦉 Fast Excel import/export for Laravel","language":"PHP","stars":2321,"topics":["laravel","laravel-package","csv","xlsx","php","excel","fast","memory-efficiency","hacktoberfest"],"license":"MIT","category":"api-integrations-sdks","readme_excerpt":"Fast Excel import/export for Laravel, thanks to Spout. See benchmarks below. Quick start Install via composer: Export a Model to .xlsx file: Export Export a Model, Query or Collection : Export xlsx , ods and csv : Export only some attributes specifying columns names: Hide columns from the exported file while still being able to use them inside the callback, using hideColumnsPrefixedWith() . This is handy for callback-only data (lookups, computed flags, etc.) that should not appear as a column: Columns are hidden from both the header row and every data row. The prefix defaults to , and any other one can be used — hideColumnsPrefixedWith('tmp ') . Hiding is opt-in: unless you call this method, every column is exported, so columns that already start with an underscore keep working as before. Download (from a controller method): Import import returns a Collection: Import a csv with specific delimiter, enclosure characters and \"gbk\" encoding: Import and insert to database: Limit the number of data rows imported with limitRows (headers excluded). It works with both import and importLazy : Facades You may use FastExcel with the optional Facade. Add the following line to config/app.php under the aliases key. Using the Facade, you will not have access to the constructor. You may set your export data using the data method. Global helper FastExcel provides a convenient global helper to quickly instantiate the FastExcel class anywhere in a Laravel application. Advanced usage Export multi","default_branch":null,"files":null,"tree":[],"storefront":"/r/rap2hpoutre","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/rap2hpoutre/fast-excel/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}