How to move position of chart in excel by Java POI -

-

i want add row in excel java poi , try both shiftrows() function , createrow() function

enter image description here
both function can add row in excel below chart position remain , not move

i move (shift down) position of chart

i use poi version 3.9

can give me advice or idea move position of chart image

as fact, data range of chart not changed. need not move position of charts need increase data range of chart

thanks!!

enter image description here

the shifting of drawing anchors determine chart positions possible. method void insertrowsshiftshapes(sheet sheet, int startrow, int n) drawing anchors affected of row inserting process sheet.

the correcting of chart data ranges affected of row inserting sheet complicated said already. not tested , not ready yet. provide working draft. hope useful start point further programming.

for running code ooxml-schemas-1.3.jar needed mentioned in apache poi faq

a resource documentation of ooxml-schema objects me grepcode

examples: cttwocellanchor, ctpiechart, ctpieser

import org.apache.poi.xssf.usermodel.*; import org.apache.poi.ss.usermodel.*; import org.apache.poi.openxml4j.exceptions.invalidformatexception;  import java.io.*;  import org.openxmlformats.schemas.drawingml.x2006.spreadsheetdrawing.cttwocellanchor; import org.openxmlformats.schemas.drawingml.x2006.chart.ctpiechart; import org.openxmlformats.schemas.drawingml.x2006.chart.ctpieser;  import java.util.list;  class insertrowsabovechart {   //a method shift rows , shift anchors in drawing below shifted rows  private static void insertrowsshiftshapes(sheet sheet, int startrow, int n) {   java.util.list<cttwocellanchor> drawinganchors = ((xssfdrawing)sheet.getdrawingpatriarch()).getctdrawing().gettwocellanchorlist();   (cttwocellanchor drawinganchor : drawinganchors) {    int fromrow = drawinganchor.getfrom().getrow();    int torow = drawinganchor.getto().getrow();    if (fromrow >= startrow) {     drawinganchor.getfrom().setrow(fromrow + n);     drawinganchor.getto().setrow(torow + n);    }   }   sheet.shiftrows(startrow, sheet.getlastrownum(), n);   correctdatarangesofcharts(sheet, startrow, n);  }   //a method correcting data ranges charts affected of shifted rows  //!!working draft, not ready yet!!  private static void correctdatarangesofcharts(sheet sheet, int startrow, int n) {   java.util.list<xssfchart> charts = ((xssfdrawing)sheet.getdrawingpatriarch()).getcharts();   (xssfchart chart : charts) {     //pie charts    java.util.list<ctpiechart> piecharts = chart.getctchart().getplotarea().getpiechartlist();    (ctpiechart piechart : piecharts) {     java.util.list<ctpieser> pieseries = piechart.getserlist();     (ctpieser pieserie : pieseries) {      boolean strrefchanged = false;      if (pieserie.getcat().issetmultilvlstrref()) {       string strref = pieserie.getcat().getmultilvlstrref().getf();       //todo: corrects end row of ranges, should correct start row if affected       int strrefendrow = integer.parseint(strref.substring(strref.lastindexof('$') + 1));       if (strrefendrow >= startrow) {        strref = strref.substring(0, strref.lastindexof('$') +1) + (strrefendrow + n);            pieserie.getcat().getmultilvlstrref().setf(strref);        strrefchanged = true;       }      } else if (pieserie.getcat().issetstrref()) {       string strref = pieserie.getcat().getstrref().getf();       int strrefendrow = integer.parseint(strref.substring(strref.lastindexof('$') + 1));       if (strrefendrow >= startrow) {        strref = strref.substring(0, strref.lastindexof('$') +1) + (strrefendrow + n);            pieserie.getcat().getstrref().setf(strref);        strrefchanged = true;       }      }      if (strrefchanged) {       string numref = pieserie.getval().getnumref().getf();       int numrefendrow = integer.parseint(numref.substring(numref.lastindexof('$') + 1));       if (numrefendrow >= startrow) {        numref = numref.substring(0, numref.lastindexof('$') +1) + (numrefendrow + n);            pieserie.getval().getnumref().setf(numref);       }      }     }    }    //pie charts end    }  }   public static void main(string[] args) {   try {     inputstream inp = new fileinputstream("workbook.xlsx");    workbook wb = workbookfactory.create(inp);     sheet sheet = wb.getsheetat(0);     //sheet.shiftrows(3, 5, 4);    insertrowsshiftshapes(sheet, 2, 4);     fileoutputstream fileout = new fileoutputstream("workbook.xlsx");    wb.write(fileout);    wb.close();    } catch (invalidformatexception ifex) {   } catch (filenotfoundexception fnfex) {   } catch (ioexception ioex) {   }  } }

Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more