java - Generating xml graphs using POI -


i using poi create report in xls format. enhanced show graphs data in report. per limitation of poi, cannot create graphs in excel. so, using template , rewriting data in everytime , graph gets refreshed.

cell cell = row.getcell(columnsarray[j1]); cell.setcellvalue(integer.valueof(count));

bad practice, have hardcode position of cells in array.

int columnsarray[] = {     1,2,3,4,5,6,7,8,9,10 };

anyone using better approach or other alternative of poi achieve this?

thanks in advance, gv

till apache poi limitation saying "you can not create charts. can create chart in excel, modify chart data values using hssf , write new spreadsheet out. possible because poi attempts keep existing records intact far possible".

however in same case, have created chart manually on excel sheet using named ranges , using java, updating named ranges per requirement. since chart based on named ranges updated.

you can update existing reference of named ranges , set per requirement. suppose reference contains mysheet!$a$1:$b$8and want change mysheet!$b$5:$c$12

for cell, "b5", @ runtime,

cell.getreference();

will give cell reference (like in example... return "b5")

char startcellcolref = cell.getreference().tostring().charat(0);

will give column reference (will give "b" if current cell b5). now

int startcellrowref = cell.getreference().tostring().charat(1);

will give row index (will give "5" if current cell b5).

by same way can start , end cell references (say b5 , c12).

now comes how can update existing references. update value newly created reference string

name reference = wb.getname("namereferenceinexcelsheet"); referencestring = sheetname+"!$"+startcellcolref+"$"+startcellrowref+":$"+endcellcolref+"$"+endcellrowref; reference.setreferstoformula(referencestring);

by way need create name ranges manually , graph/chart want manually based on named ranges, , need update named ranges... since chart/graph based on that, updated automatically.


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more