KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Excel export template not working on code igniter #1552

Open Yanick Ileo opened this topic on on Aug 3, 2020 - 6 comments

Yanick Ileo commented on Aug 3, 2020

am using codeigniter hmvc

here is my method :

public function export()

{
	ob_start();
	$report = new DashboardReport;
	$report->run();
	ob_end_clean();
	$report->exportToExcel('DashboardReportExcel')->toBrowser("Dashboard.xlsx");

}

please see below the error i receive on submit :

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: Chart/DataSeries.php

Line Number: 127

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Chart/DataSeries.php Line: 127 Function: _error_handler

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/Chart.php Line: 137 Function: __construct

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExportHandler.php Line: 208 Function: saveContentToSheet

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExcelExportable.php Line: 39 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: Chart/DataSeries.php

Line Number: 131

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Chart/DataSeries.php Line: 131 Function: _error_handler

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/Chart.php Line: 137 Function: __construct

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExportHandler.php Line: 208 Function: saveContentToSheet

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExcelExportable.php Line: 39 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Notice

Message: Undefined index:

Filename: Chart/DataSeries.php

Line Number: 131

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Chart/DataSeries.php Line: 131 Function: _error_handler

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/Chart.php Line: 137 Function: __construct

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExportHandler.php Line: 208 Function: saveContentToSheet

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExcelExportable.php Line: 39 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: Chart/DataSeries.php

Line Number: 132

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Chart/DataSeries.php Line: 132 Function: _error_handler

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/Chart.php Line: 137 Function: __construct

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExportHandler.php Line: 208 Function: saveContentToSheet

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExcelExportable.php Line: 39 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: Chart/DataSeries.php

Line Number: 248

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Chart/DataSeries.php Line: 248 Function: _error_handler

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Chart.php Line: 1110 Function: getPlotLabelByIndex

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Chart.php Line: 254 Function: writePlotGroup

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Chart.php Line: 81 Function: writePlotArea

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php Line: 286 Function: writeChart

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExportHandler.php Line: 267 Function: save

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExcelExportable.php Line: 39 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: Chart/DataSeries.php

Line Number: 248

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Chart/DataSeries.php Line: 248 Function: _error_handler

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Chart.php Line: 1147 Function: getPlotLabelByIndex

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Chart.php Line: 254 Function: writePlotGroup

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Chart.php Line: 81 Function: writePlotArea

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php Line: 286 Function: writeChart

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExportHandler.php Line: 267 Function: save

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/ExcelExportable.php Line: 39 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: exportToExcel

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 38

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 38 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 39

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 39 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 40

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 40 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 41

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 41 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 42

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 42 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 43

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 43 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 44

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 44 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 45

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 45 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/hmvc_proj/system/core/Exceptions.php:271)

Filename: excel/FileHandler.php

Line Number: 46

Backtrace:

File: /opt/lampp/htdocs/hmvc_proj/application/libraries/koolreport/koolreport/excel/FileHandler.php Line: 46 Function: header

File: /opt/lampp/htdocs/hmvc_proj/application/modules/reports/controllers/Mars.php Line: 104 Function: toBrowser

File: /opt/lampp/htdocs/hmvc_proj/index.php Line: 330 Function: require_once PK�JQ��Zxl[Content_Types].xmlŕMn�0��=�'YTU�E�.�HM��C���q�n�B[U iR7 ���ol1��"ځGmM��ɈE�UڬS��z��Y�A% k eG@6��LWG������(s(&ց�7������� �k����Kk��ʃͦ���ZA�>���0�P�@n�\� ���V� � -E���Ψ_��f����ܖ$Ij��ʅ�b8��Q�<�9@(��1m� �Ķ�Ӂܛ�=x�fB��̵�"t/�n�3�/���V�}o�����бW5)�6]C'��[��P��*9*vd >��w���p=������S�u4��28�/�+���S� �-xڤ������P�9����\NF��z��e0&��6lټ�Y�>PK�JQ�78�K _rels/.rels���j�0 ��{ �{���1F�^ʠ�2��l�$���-}�y����Î��O��v�y�;�؋Ӱ.JP��޵^�����Yű�3G�Ww�g)���>� qQC��D���b!�]�i$L��3��� �2n���oT �:Z �h����[��4�ი��]��yN�,ە�>�>�j -' V�)�#��EF^6��n���8q"K��H��>_ׄ����eƏ�<⇄�Ud�v�� T�PK�JQ�����Fxl/_rels/workbook.xml.rels���j�0��} ��Z��C)�s)�\[����LlIh�?~�� m�ӓ�;�1�f�1� #��)(��ƛ�u ^���;��=x� &$�V�'4��} �L)���^Jj,��2Х���Qs���A7{ݡ,��VƹT'�bgĝ)@�S��x���|��눎�DH�iH��ֱCVp�Y�y>�\3��.ӿ�aX,1\�Z���3����&��%��5a�}ܓE�#��� 5����3L�#O�� PK�JQ��וZdocProps/app.xml�S�n�0 ��+ ���P ��bHV��b�vǁ��X�- "k$����:�a�|z||x~%uwl���HֻB�,r��3���P�����W��+�� qBw�Jm��"e��Q!j氒�L�-�"�]�T>�������x�֢c���[�GFWby&Cqv\u����7}>zޟB���[�5�iH�hM��+ξ 6JΛ*�мE�'�+9/��@��d�+h�� �Bf[����xաa3�ҩ-E��}�Bt-8gٹp�����+ՈLJN���9�_�r$p)�S��/#�-7H?�-D�W�!��e��/b9�8!S'��%0|�����׾ �N�ݬ} >KQrl�Gpp��B?�{����sI�] �e�崸�Pi����u �����������"O�p{FNɏW��PK�JQ����CdocProps/core.xml���n� E�����iTY�&Ө�i��j�^S&6X@�����M� �p�]S^�� ���ښ%fs�i�6�%~ح�+�|F��X�<��?J��:��l.h�(��/d�į!4!^�B-�<&��E�C�'����S����A�^�5���JN���$P�@5�� �3��p��rA�\��]�cq�O^O۶�v��x~F�6���j�M��K% �@�����(G�JrQ�s����������lk�j@J�)�mP(��+��՟���4�W]�+rV0�����1>Hޭ�y��iGK�"�POO�&��/�nB��|��#<�p��kQ�"�|�2��{0��}��Z��7' ��v������Y�U�;�&�I����t�c{�:>~��L���ý��PK�JQs�{Y��xl/theme/theme1.xml�YOo�6��S���l�u�:E���֦ �C��DK�)Q 餾 �q��aݰˀ�v�h�]�O����� {�c���6iSlC�-������Q�|�^��!��k9"����]��hx�c!�p�ҵ�DZW�>��7UDb��<���kEJ���-}���"OIk.b�(B;����n6m;�4�P�c�zs2�>A�����>�(�M�L��D�"�S'��s�gbֵ@N��F䞲�R�B�j��޺l/��ZC�� �OIW�fN'�����v����U�0��%��},uV����<5P�ʻ��n��o��7z���Q÷*����4��v��w+���o��o��^�o����6�n��"F�� :��22KȄ��Fx����P��� �D��k1���yp�� R�L��>�ǂ�L�$X[)�|�2��B�4U]��CFT�O|��1z�����'��9~�����«8 u������������Wf������o�~i*���G��6�2g�E��(pHp����3�G�λ-������t=��LQ�Z׀���Fs�e�tsfIh.f:n�C�����f)�djbُHM�=��!I�B��b �Ciͯ��\�Bw(�ajtɈ����*�!.slu�7��Q�3�rXGBBfbIX͍�±Qc3y�Ȥ��\�5�K� �h)M47ż��5 ���]6��H��Ԅ��9ב;|ڏp�u�I�c?�Sآ�qeT��3$Cp�6ܷ)QgK�[4��$[� SJ^��9�`����V�c���l3 u�}�^���c�(��p����g���x��W�w�B�����U)��^;g�m�'��5g�̋��!L惜h��<��j�P�� �>�:�p b�\B(K֡D)�p����ί�l��Ž�X��n���%�|J]P+cpZa�Ko&�)����xfi�K�ٚ7!o�^&8�f!6 f$��^0X���C$#�2F���uJ�u^�5M�F�ͤ�&H�8w�8���X�����,���h�5= �8�Z��1N���Jfaҵ|U���d>i�y[:���D�B�,��_Z��I������| �_W�V����O��L&�Wkf�a��g���(8Bc6��v��P GEs1��n���_f���>ev`�F��I-�<^ꐏ4��5���)�s4�{wM�v.4�� �zA 0��h��BE�PQ(�q�e�^�"S ��v�+9��V��(ra��i��J�"AȞ�|3���� Fe�Y�+��wL e����P��&�#r�ɠ٦����p��6^�=��g�E\��kG�ƛ�pƣ�i�����Mᚂ�/(�T���oG|���%��x�S��rr :w4�2Vo���B�i���Ssvk�����l��k�家WS��.2�h��,>� �w�~4cJ�����������?PK�JQ��[4��xl/sharedStrings.xmlm��j�0 ��{ ��꬇1��z(��<������3�.��ϥ�Aң�O?I��~Ǡ���#��aSi����S_�����V��:���3�޹;+�T���zHiz6F�G�M���9E!��{##t2 �1�mU=��if�^pt��0%]�QY���:����� �$\I��#5�&}8rz�P ��MK ��jj�>P�Di���A�� b.TK�]�������gHiI��W� L�4���T�N��m���}(�x� #�۩�f��[���ݼ�l¥��4FlWJ��-�B��@x�C�����B�-�� �ޏ"��+�t�'8���r�$bD�g�fCJ~����ٷn�X��c�B��j�Y�����9����&���m/��-�����9�`A��n6�\�Ҷ�[����P��\�~�V�}�h�е��L�M���.i���^zl��\o�8����L9�ɻ�DNu6��"�f�����w��RP�IcrrQ�4{�x� 5�T��$V8)WJ���  �R�k���pc���L��U�&�N_=���_��ig)>��������5�8�����v~����Y���q;�Ƚ�|� ��g:��c�|d�Zf��SvX�ۏ�KI+�q�OR�g�#-Y'��S�'vP0F �:�F��3'�PK�JQ�]�z�'xl/workbook.xml�RMo�0 ��W��v��؂8�,[�}aͺ�@�tMT� �N���Rv�y;���|�x���s�#S�9=)L�ކ��}i~l7�ߘ�| .x,���Z�Z�C|�BxȔ�������q�&��Kӊ�OE��B�_5�g3ƨx~�UcC�$9+�[�t5��v����˔&�;�ס��G�����kE��O�����9� I}��[�PK�JQ6� �� xl/worksheets/sheet1.xml�W�r�6}�Wp����FR&���3�$c;�3DBj�H���]$^2�i��8{pX���ת�ΘqB��9�m�:��k���݇Զ�@u�JZ�����q���B� ?b,, X��0�0�1;c[:k���B4�ł�G\!���0���BLvXp�A�b�ʅ��B�n��=t�'9����µ�$ �H@N�Hޱ���+�@��C⭞���p�W��QN���i�J�f�-�A�U�ab/��7�܎�D�)��U�ˇCMڕp �J���N`ڬ��۬�I���ߘ�Oz��%�@�؝��B:�բ�+��2������-o=WB�O�/�[�p�s� �-�mG鋜|�)?����AԚ`'�������=du-��Xq���w�[\�k�6�����r��v��2/��J���6�� m�ݛ����G�)�����i��_�"�J�B�:QR�#�\'��4��o���#��0?qA��&-��w̚�o9�+��$���� Z��� [���9z[���ڬ�XLg���-C(�\:?��9�獻Z�%���>П �@o>0� �^Eڇ�}�B�hD` �!b;E�C��͋ gE�*�ܜx$R#B-/���IG�� �S?��0�4!^�x�����hVh4���F�~���TlMH���d�H� �b'M� �ƳB�Б����Q/I2�U�ք$~�eN4>�x(���0���'�B���l$41���8v���� I=ׇ� �$N�A�� Mg����;R��k�I�¥2RjB�$p#'�%s� 1�x 4��M��T�d�ٻi7���7!q��tKM�FQ�{�O�&ϝ���� �m�p*�T�k{�J�/��~��<�5b�^=���/��G�SU���r^]���r����[���/׉�~�� �;`�=�g���b��SvM��#���w5�Lųl��l��r��\avPM7�}gt�{'�0R���ji�õ�iW�=O�{,��A���U�=��G`[L�,j,h�Fp����ǵ���}�V ���hya�Sc5�����U�SF�W}��n�$YH�О e�'��MSk��JZ/{�ֳ ��c�_���3����M�ƅQ{��"��[��PI�������- �"�Nc�յ�C�V�pӐ�>�4�RZ2��� -s�k�?8,�$����BWF��k�/PK�JQ�y��N� xl/charts/chart1.xml�WKo�6��W��{Jh;I�����:Mg��KAI#�5E�$�����z�� �؋Lΐ��͐����y� J3)���x b�0�M�oO7G�0І��r)�@�_f�\ƓxM�Y4�1����pmL1!D�kȩ>�ԥR���Te$Q��sNF��oā��@N������i�b��q��0D��׬�� �K�����4x�|Bb���� @�^y���H YH%0���y<�sJ �B ��Uv��TNզ,�b�h\�83;gn�k���O s+�ej��r����9'c2����L���e#0<�h���F�%Ҝ�L���G4��0t7K[=y%��Cv���[T�g�t�d���rmV� 7)�G�σ "�o9 ՒV� ��ʍB�����"o��r)� vXv��ݡ�k��2�5��6R���N��QAb����F>��5p0���Upi� h�hG9%�����q&`Q�/C�f��W�xh ���d�;Q�TO� �?� �|t>�}�L5>��R;Jg�] ��z���4�t2���nJ�� ��t>�֊�g�������(�X����������h1�eĵ۲�/K�@$a� j�S~ [P���@����T ���UEV���-K�������j�Υ4��F��������bx2�"��X�E���-c���G��C�k��9wt[��]�8��Y� +�"/�p����yE��&7��� ���l�cG�%f3���aN���ś;l����d��J�rLe [�$��vn=���R՜�=�OP�.;����gU�b��}�j0uo������c��'��V��Sw��b��f��w�O�>����lt1-�a��!�-�"s7d�����j+Zr� <��$?L�G��TW`^%�e��V�${������&�[����qy��U���d� ��n-q<����>���۪zRo��[?�3}/��W� ���l��r&�E{+\����`��Y�<� ńY���N��a�n��,@���I�1���V�0�'a�WV�{��5��U� +����a!�Q���۳�t�=��PK�JQ<�� xl/worksheets/sheet2.xml�VM��8��p��¤&ɲ��I%53ٜ��� ��d��oK��|��=�'���R����kż#HEO�8�|x&r�����e�!�=� � R� ����c}�J���J�$��Z�y߀\�~�u� C��P�8�BVD�)��BɭR��I�ÊP�*��{4DQ� �����k'"��9��֪S{�ߥ�Kr���x!~q3�^<�ѫh&��2Q���f� �WyV�{��<4��1�eT�m��We��{.$�1< �d�(I�?�D���b?�f-�(��SM��?',����7����T�'�H��xu��v��Nj0�4�=�LC��X���vB��W�R���4�h�Դl��O��Y�L��ā�V�8'�s����`j�Nr��������$0� �0�~��u�|�ݚG8{2{]c���Q&���^E�ݻ�����u��8X��l�'���Twf�Ң�喵I�9t�:iW�D��Z���e?�u51�2^�-� xo�ԟ��+D���:<� ��OG�SK�9b2O�A2��F���L�wA����F�wC��b� ��8>ʟ�q���d6���C~�H"<�q~2�O��G�2 ���88��2 ���S� La��o�Uo� 8�T\�KL��`�5�b ʱ��,t��‡s K�p���jx���+w]Ev��:Z%�%a�h��L�졚�~1M��O�n���Ԓr���o�������#��]AC"{�F�S�8�'�{�u;֢�#,ѝ�xe;����XS��BwF����ګ n�3�lW���f��oۏ9b�}a�)�~};j��K�N��n�?/�E%����G����&�T*=(%���ٮ�F���F�8�y�/��C����#� 3� C�0���+�=��n����PK�JQ9A�#xl/worksheets/rels/sheet1.xml.rels��� �0нfoҺ��݈Э����I|���FQp�r�2g�U�03�Q���J^#���� ���;1��8;K��ԫ�D3�|��G�%�)��Q�d0r���w��c�Gu��Ħ(�"|P���B�K����������ՐM?^�e�@I��;,yfAԕ��X?PK�JQϢ��$#xl/drawings/_rels/drawing1.xml.rels��� �0н_foҺ��݈Э����I��ta��˙�=�T����A!N�J(y��rz���kw��ńV��,IX(BSo� ͘r'���,#6JS�G!���Γ�I����0���]Q�E�6�^���B�K`����������ݐM?N5bH�0P���{� J�Au%V��/PK�JQrg�o�xl/drawings/drawing1.xml�S�n�0 }�WDy)�RѢ��iҴ�}@��4Z�TN���(����>��q�x�ld������I�WLgBmc������X�2Zj�c|�/��E�AT���W&rn� k��� .���+�5Hj� [���,I�T�if �m�G��7�IN��l�W�,_+4�PZ��e,��g�����"��$��xk�(�{�sԱ���xY�yίhήh�JNt�-Ъl Tr$)c?�7~0�c���UA��)F"s�!��%����w�~ �\�&�hr�-��s�����C{��E�ـ�q��ad��R�q�b��ݰX�Y�/���<��V��^0�j��\ٞxI�[LS��Q�,�M�1��x����ǿb)w�>��lQȰ��/PK�JQ�KR"x�#xl/worksheets/_rels/sheet2.xml.relsM�1!{A��@ c�q����p+a!,1�{)-'��y����$�p� (bW�����~ݟAIG�0& X��|��}4b5&,B�����@e�x�gi���uE�BO�h�I����PK�JQ��Zxl��[Content_Types].xmlPK�JQ�78�K ���_rels/.relsPK�JQ�����F���xl/_rels/workbook.xml.relsPK�JQ��וZ���docProps/app.xmlPK�JQ����C���docProps/core.xmlPK�JQs�{Y����wxl/theme/theme1.xmlPK�JQ��[4����[ xl/sharedStrings.xmlPK�JQ��j�R+ ��hxl/styles.xmlPK�JQ�]�z�'���xl/workbook.xmlPK�JQ6� �� ���xl/worksheets/sheet1.xmlPK�JQ�y��N� ���xl/charts/chart1.xmlPK�JQ<�� ��*xl/worksheets/sheet2.xmlPK�JQ9A�*#���xl/worksheets/_rels/sheet1.xml.relsPK�JQϢ��$#��� xl/drawings/_rels/drawing1.xml.relsPK�JQrg�o����!xl/drawings/drawing1.xmlPK�JQ�KR"x�#���#xl/worksheets/_rels/sheet2.xml.relsPKAR$

David Winterburn commented on Aug 3, 2020

Hi,

Please post your excel template code for us to check it and make sure that your chart excel widget's datasource is not empty. Thanks!

Yanick Ileo commented on Aug 3, 2020

DashboardReportExcel.view.php



<?php

    use \koolreport\excel\Table;
    use \koolreport\excel\PivotTable;
    use \koolreport\excel\PieChart;
    use \koolreport\excel\BarChart;
    use \koolreport\excel\LineChart;

    $sheet1 = "Dashboard";
?>


<meta charset="UTF-8">
<meta name="description" content="Free Web tutorials">
<meta name="keywords" content="Excel,HTML,CSS,XML,JavaScript">
<meta name="creator" content="Eroute 2 Market">
<meta name="subject" content="subject1">
<meta name="title" content="title1">
<meta name="category" content="category1">

<div sheet-name="<?php echo $sheet1; ?>">

    <div cell="A1" range="A1:H1" excelstyle='<?php echo json_encode($styleArray); ?>' >
        Sales By Region
    </div>

    <div>Regions</div>


    <div>
        <?php
        Table::create(array(
            'name' => 'Month',
            "dataSource" => $this->dataStore('result2'),
            //"dataSource" => 'result',
             "columns" =>[
                 'Month', "CasesCurr" ,"CasesPrev","PrevContr"
             ],

        ));
        ?>
    </div>
    <div range="A25:H45">
        <?php

        LineChart::create(array(
         'title'=>"Monthly",
         //"dataSource" => $this->dataStore('result'),
         "dataSource" => 'result2',
          "columns" =>[
              'Region', 'CasesCurr'
            ],


        ));
        ?>
    </div>


</div>
David Winterburn commented on Aug 3, 2020

Please put your code inside the code tag of the forum editor:

Yanick Ileo commented on Aug 3, 2020
<?php

    use \koolreport\excel\Table;
    use \koolreport\excel\PivotTable;
    use \koolreport\excel\PieChart;
    use \koolreport\excel\BarChart;
    use \koolreport\excel\LineChart;

    $sheet1 = "Dashboard";
?>


<meta charset="UTF-8">
<meta name="description" content="Free Web tutorials">
<meta name="keywords" content="Excel,HTML,CSS,XML,JavaScript">
<meta name="creator" content="Eroute 2 Market">
<meta name="subject" content="subject1">
<meta name="title" content="title1">
<meta name="category" content="category1">

<div sheet-name="<?php echo $sheet1; ?>">

    <div cell="A1" range="A1:H1" excelstyle='<?php echo json_encode($styleArray); ?>' >
        Sales By Region
    </div>

    <div>Regions</div>


    <div>
        <?php
        Table::create(array(
            'name' => 'Month',
            "dataSource" => $this->dataStore('result2'),
            //"dataSource" => 'result',
             "columns" =>[
                 'Month', "CasesCurr" ,"CasesPrev","PrevContr"
             ],

        ));
        ?>
    </div>
    <div range="A25:H45">
        <?php

        LineChart::create(array(
         'title'=>"Monthly",
         //"dataSource" => $this->dataStore('result'),
         "dataSource" => 'result2',
          "columns" =>[
              'Region', 'CasesCurr'
            ],


        ));
        ?>
    </div>


</div>
David Winterburn commented on Aug 3, 2020

Please output datastore "result2" to the report's view and send us the screenshot of the result:

//DashboardReport.view.php
<?php
    \koolreport\widgets\koolphp\Table::create(array(
            'name' => 'table1',
            "dataSource" => $this->dataStore('result2'),
            "columns" =>[
              'Region', 'CasesCurr'
            ],

        )); 

Thanks!

Yanick Ileo commented on Aug 11, 2020

Thank you very much , it is working fine

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed
solved

Excel