Laravel Excel/PHP Excel: Import, modify, download

Question

I'm struggeling with Laravel-Excel (Laravel Package of PHPExcel).

I'm not able to modify a file. My file has one workbook (called template). I want to load the document, modify it and let the user download it:

Excel::selectSheets('template') -> load($source, function($file)
{

}) -> download('xls');

Code above works so far. But I don't get how to fill cells. I don't want to export an eloquent model directly, I need to follow a certain structure. The Excel file was not created by me, I just need to fill it with data.

So how can I for example fill cell A2 with the firstname of the current user?

I search for something like

Excel::cell('A2') -> content = $user -> name;

This is just an example of what I want to achive, this is not working code!

Thanks, LuMa

Laravelian · Accepted Answer · 2014-12-26 17:58:59Z

3

Laravel-Excel runs off of PHPExcel, and you can run native PHPExcel methods on the objects exposed by Laravel-Excel.

From the docs, to get the cell: http://www.maatwebsite.nl/laravel-excel/docs/export#cells

\Excel::create('Document', function($excel) {
    $excel->sheet('Sheet', function($sheet) {
        $sheet->cell('A2', function($cell) {
            $cell->setValue('this is the cell value.');
        });
    });
})->download('xls');

And, here is a screenshot of the $cell instance showing what else can be called on it:

Kint dump of the $cell instance

answered Dec 26, 2014 at 17:58

Laravelian

5981 gold badge3 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nishchit Over a year ago

@Laravelian Hey bro. scnshot gives nice functionality, What is this ? any app or library

Mayra Lozano · Accepted Answer · 2016-02-29 15:54:01Z

2

I use that in this way:

Excel::load('template_orden_compra.xls', function($doc){
   $sheet = $doc->getActiveSheet();
   $sheet->setCellValue('A2', $user->name);
})
->store('xls', storage_path('Excel'));

answered Feb 29, 2016 at 15:54

Mayra Lozano

212 bronze badges

Comments

Mantas D · Accepted Answer · 2015-03-07 19:34:10Z

0

You can use native PHP Excel functions:

Excel::load('file.xls', function($excel)
{
    $excel->getActiveSheet()->setCellValue('A1', 'cell value here');
}) -> download('xls');

answered Mar 7, 2015 at 19:34

Mantas D

4,2103 gold badges29 silver badges28 bronze badges

Comments

Dmitry · Accepted Answer · 2017-11-14 11:42:04Z

0

You can use following for multiple sheets.

$somevalue = array('abc', 'xyz');

Excel::load('file.xlsx', function($file) use($somevalue) {
   $file->sheet( 'sheetName', function ($sheet) use($somevalue){
        $sheet->setCellValue('A1', $somevalue);
   });
})->export('xlsx');

edited Nov 14, 2017 at 11:42

Dmitry

7,29614 gold badges42 silver badges42 bronze badges

answered Nov 14, 2017 at 11:21

Vishal S. Pawar

711 silver badge6 bronze badges

Collectives™ on Stack Overflow

Laravel Excel/PHP Excel: Import, modify, download

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related