The use of function getHighestDataColumn()

Topics: Developer Forum, Project Management Forum, User Forum
Aug 22, 2012 at 4:13 PM

I'm having a problem using this function and I'd like u to help me.

 

I have a sheet filled with data until the  column "AL". What I need is to get this value automatically, but when I do this:

$objPHPExcel->setActiveSheetIndex(0);
$latestTemplateColumn = $objPHPExcel->getActiveSheet()->getHighestDataColumn();

The index of the sheet I want to get is '0' and the $latestTemplateColumn returns 'C'.

Do you have any idea of what I could possibly be doing wrong?

Aug 22, 2012 at 4:17 PM

Problem solved! I just discovered I was calling this before filling the sheet with all data... So, it was being incomplete until the call of this function.