How to handle dynamic colums in PhpExcel

Topics: Developer Forum, User Forum
Mar 27, 2009 at 8:51 AM

Im new in a discussion forums here...
i've been working on codeplex phpexcel for some month and today, i was asked to do a dynamic comparison table which needs me to handle a dynamic row and colums

i don't have any problems really in handling an X-Axis (row) data as i can loop in using number/integer

but i really come on stuck when i need to handle it VS dynamic colums as well as it is in an alphabetical order

could anyone suggest me the way of solving the problems?
Mar 27, 2009 at 9:05 AM
well, i can advice u to make an array like this (but with changed keys and value):
$colums = array(0=>"A",1=>"B",2=>"C",3=>"D",4=>"E",5=>"F",6=>"G",7=>"H",8=>"I",9=>"J",10=>"K",11=>"L",12=>"M",13=>"N",14=>"O",15=>"P",16=>"Q");

and to make a simple convertation by accessing it like it's a number
Mar 27, 2009 at 9:47 AM
You can easily loop the column with number/integer too.
Just use PHPExcel_Cell::stringFromColumnIndex($columnIndex)  method which convert a numeric index into the letter you need for your column ;-)
Mar 27, 2009 at 9:50 AM
Wow.. It's really cool!! thanks!! I had to write my own method that allows looping alphabetical cells )))