php - Chart not rendered properly -

-

i have small table

my table

and want create type_donutchart phpexcel library. took example code examples/33chartcreate-pie.php file , adapted accordingly:

$dataserieslabels2 = array(     //new phpexcel_chart_dataseriesvalues('string', 'summen!$a$1', null, 1), ); $xaxistickvalues2 = array(     new phpexcel_chart_dataseriesvalues('string', 'summen!$b$1:$c$1', null, 2), ); $dataseriesvalues2 = array(     new phpexcel_chart_dataseriesvalues('number', 'summen!$b$2:$c$2', null, 2), );

the file served script, when try open it, error message occurs:

we found problem content in "myfile.xlsx". want try recover as can? if trust source of workbook, click yes.

when click yes , activate editing on document, following message this:

excel has finished check , repair of file. parts of file have been repaired or discarded.

removed part: part /xl/drawings/drawing4.xml. (drawing form)

what's wrong in code? have modify?

notes:

  • as can see, i'm using dataset in example. there's data in range a1:c2 (see screenshot above).
  • the worksheets name summen, double checked, problem not typo of sheet.
  • it's been asked in comments, have tried removing comment dataserieslabels2 entry.

my example

$objphpexcel = new phpexcel(); $objworksheet = $objphpexcel->getactivesheet(); $objworksheet->fromarray(     array(         array('whatever', 'cat1', 'cat2'),         array(77,         247,    128),     ) ); $objworksheet->settitle('summen');  $dataserieslabels1 = array( //    new phpexcel_chart_dataseriesvalues('string', 'summen!$a$1', null, 1), );  $xaxistickvalues1 = array(     new phpexcel_chart_dataseriesvalues('string', 'summen!$b$1:$c$1', null, 2), );  $dataseriesvalues1 = array(     new phpexcel_chart_dataseriesvalues('number', 'summen!$b$2:$c$2', null, 2), );  $series1 = new phpexcel_chart_dataseries(     phpexcel_chart_dataseries::type_donutchart, // plottype     null,                           // plotgrouping     range(0, count($dataseriesvalues1)-1),      // plotorder     $dataserieslabels1,             // plotlabel     $xaxistickvalues1,              // plotcategory     $dataseriesvalues1              // plotvalues );  $layout1 = new phpexcel_chart_layout(); $layout1->setshowval(true); $layout1->setshowpercent(true);  $plotarea1 = new phpexcel_chart_plotarea($layout1, array($series1)); $legend1 = new phpexcel_chart_legend(phpexcel_chart_legend::position_right, null, false); $title1 = new phpexcel_chart_title('test pie chart');   $chart1 = new phpexcel_chart(     'chart1',       // name     $title1,        // title     $legend1,       // legend     $plotarea1,     // plotarea     true,       // plotvisibleonly     0,          // displayblanksas     null,       // xaxislabel     null        // yaxislabel       - pie charts don't have y-axis );  //  set position chart should appear in worksheet $chart1->settopleftposition('a7'); $chart1->setbottomrightposition('h20');  //  add chart worksheet $objworksheet->addchart($chart1);   $objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel2007'); $objwriter->setincludecharts(true); $objwriter->save(str_replace('.php', '.xlsx', __file__));

generates correctly without errors


Comments

Post a Comment

Popular posts from this blog

android - Hide only the Action bar on Scroll not action bar tabs -

-
Image
i getting issue @ trying hide action bar while scrolling down.then while scrolling up,the action bar have shown again. for eg: i referred tutorial .here can see output , respective codes related hide , show action bar. i showing output till now. after scrolling down: the screenshot above shown, hide action bar tab also.but have hide action bar.that's major issue. after scrolling up: the screenshot above shows displays action bar tabs. topratedfragment.java: import info.androidhive.tabsswipe.r; import android.app.actionbar; import android.content.res.typedarray; import android.os.bundle; import android.support.v4.app.fragment; import android.view.layoutinflater; import android.view.view; import android.view.viewgroup; import android.view.viewtreeobserver; import android.view.window; import android.widget.scrollview; public class topratedfragment extends fragment implements viewtreeobserver.onscrollchangedlistener { private float mactionbarheight; ...
Read more

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more