Answer the question
In order to leave comments, you need to log in
How to get the parent of a grouping in PHPExcel?
I am using the PHPExcel library.
The .xlsx structure is shown in the photo
. I use the following code:
// Подключаю библиотеку
require_once ($_SERVER['DOCUMENT_ROOT'].'Classes/PHPExcel.php');
$pExcel = PHPExcel_IOFactory::load($_SERVER['DOCUMENT_ROOT'].'/out.xlsm');
foreach ($pExcel->getWorksheetIterator() as $worksheet) {
foreach ($worksheet->getRowDimensions() as $rowDimension) {
$level = $rowDimension->getOutlineLevel();
echo '<pre>';
print_r($level);
echo '</pre>';
}
}
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question