Perl data labels of chart in excel -

-

i'm struggling problem more or less 2 days , i'm frustrated, since problem not big algorithm... want write perl program, saves few values excel sheet , makes xlcolumnstacked100 labeled diagram specific column colors out of it. far, managed make either stacked diagram (win32::ole) or labeled 1 (excel::writer::xlsx). doing wrong?? tried many things, somehow never has be... in advance tips!

#!/usr/bin/perl -w  use warnings; use win32::ole; use win32::ole qw(in); use win32::ole::const 'microsoft excel'; use win32::ole::const 'microsoft office .* object library'; use diagnostics; use strict;  $xlapp = win32::ole->new('excel.application'); $xlapp->{visible} = 1;  $xlbook = $xlapp->workbooks->add;  $mydata = [["", "a",     "b", "c", "d", "e"],         ["x", "1", "2", "3", "4", "5"],        ["y", "2", "3", "4", "5", "6"],        ["z", "3", "4", "5", "6", "7"],        ];  $rng = $xlbook->activesheet->range("a1:f4"); $rng->{value} = $mydata;  $chart = $xlbook->charts->add; $chart->setsourcedata($rng, 2); $chart->{charttype} = 53; $chart->location(2, "tabelle1");  $xlapp->$xlbook->$chart->applydatalabels({autotext => 1});

the other code:

#!/usr/bin/perl  use strict; use warnings; use diagnostics; use excel::writer::xlsx;  $workbook = excel::writer::xlsx->new('c:\\diagramm.xlsx'); $worksheet = $workbook->add_worksheet(); $bold = $workbook->add_format( bold => 1 );  $headings = [ ' ', 'a', 'b', 'c', 'd', 'e']; $data = [         ['x', 'z', 'y'],         [1, 2, 3],         [2, 3, 43],         [3, 4, 5],         [4, 5, 6],         [5, 6, 7],        ];  $worksheet->write( 'a1', $headings, $bold ); $worksheet->write( 'a2', $data );  $chart = $workbook->add_chart( type => 'column', embedded => 1 ); $chart->add_series(     categories  => '=sheet1!$a$2:$a$4',     values => '=sheet1!$b$2:$b$4',     data_labels => { value => 1 },     name => 'a', );  $chart->add_series(     categories  => '=sheet1!$a$2:$a$4',     values      => '=sheet1!$c$2:$c$4',     data_labels => { value => 1 },     name => 'b', );  $chart->add_series(     categories  => '=sheet1!$a$2:$a$4',     values      => '=sheet1!$d$2:$d$4',     data_labels => { value => 1 },     name => 'c', );  $chart->add_series(     categories  => '=sheet1!$a$2:$a$4',     values      => '=sheet1!$e$2:$e$4',     data_labels => { value => 1 },        name => 'd', );  $chart->add_series(     categories  => '=sheet1!$a$2:$a$4',     values      => '=sheet1!$f$2:$f$4',     data_labels => { value => 1 },     name => 'e', );  $chart->set_x_axis( name => 'somename' ); $chart->set_title( name => 'sometitle' ); $chart->set_style( 10 ); $worksheet->insert_chart( 'j2', $chart, 25, 10 );


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more