CODEWITHSUNDEEP
phplaravellaravel-excel
RomkaLTU
RomkaLTU

Reputation: 4129

Laravel excel Import when header have merged cells

It seams that http://www.maatwebsite.nl/laravel-excel/docs can't figure out how to handle simple merged cells.

Importing excel file like this:

Excel::load($tmp_path, function($reader) {
  $reader->dd();
})->get();

See image bellow where is problem:

enter image description here

Upvotes: 1

Views: 3701

Answers (2)

RomkaLTU
RomkaLTU

Reputation: 4129

Just checked configuration and we can set 'slugged_with_count' in heading, so results become like picture bellow. Or disable heading and rely on columns order.

enter image description here

Upvotes: 1

Nitish Kumar
Nitish Kumar

Reputation: 6276

You'll have to read this file out differently, you can't use the simple import methods. You have to read it out per coordinate, example of the native PHPExcel methods:

http://docs.typo3.org/typo3cms/extensions/phpexcel_library/1.7.4/manual.html#_Toc237519900

Also you can check the link: https://github.com/Maatwebsite/Laravel-Excel/issues/442

Hope this helps.

Upvotes: 1

Related Questions