PHP array to excel including hyperlink using phpexcel

Question

How will convert array to excel using PHPexcell. Its a mixed array few values are hyperlink few are dates and string. Thanks in advance. For below array using setCellValue and getHyperlink()->setUrl works fine But i want directly from array($array) to exce $array = array( 0 => array('product_name' => 'mobile', 'description' => 'Mobile Details', 'add_date' => '10-12-2015', 'details_link' => array('lable' => 'details_link', 'link' => 'www.example.com/mobiledetails.php')), 1 => array('product_name' => 'Computer', 'description' => 'Computer Details', 'add_date' => '10-01-2015', 'details_link' => array('lable' => 'details_link', 'link' => 'www.example.com/computerdetails.php')));

where is your code?

Passionate Coder
– Passionate Coder

2016-08-11 07:53:17 +00:00
Commented Aug 11, 2016 at 7:53 — Passionate Coder
– Passionate Coder, Commented Aug 11, 2016 at 7:53
Post some code what you tried so far.

UeliDeSchwert
– UeliDeSchwert

2016-08-11 07:53:19 +00:00
Commented Aug 11, 2016 at 7:53 — UeliDeSchwert
– UeliDeSchwert, Commented Aug 11, 2016 at 7:53

Mark Baker · Accepted Answer · 2016-08-11 09:47:08Z

1

Use PHPExcel's fromArray() method, with the Advanced Value Binder; that should cover most variations, although you may need to extend the Advanced Value Binder with a custom binder to handle hyperlinks.

answered Aug 11, 2016 at 9:47

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

Collectives™ on Stack Overflow

PHP array to excel including hyperlink using phpexcel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related