/**
* Detect payments column.
*
* @return variable with column index.
*/
private function detectPayments()
{
foreach ($this->sheet->getActiveSheet()->getRowIterator() as $row) {
foreach ($row->getCellIterator() as $cell) {
if (strcasecmp($cell->getValue(), 'pagamento') === 0 || strcasecmp($cell->getValue(), 'pago') === 0 || strcasecmp($cell->getValue(), 'valor') === 0) {
$this->paymentColumn = PHPExcel_Cell::columnIndexFromString($cell->getColumn());
$this->firstRow = $cell->getRow() + 1;
return;
}
}
}
$columns = array_fill(1, PHPExcel_Cell::columnIndexFromString($this->sheet->getActiveSheet()->getHighestColumn()), 0);
foreach ($this->sheet->getActiveSheet()->getRowIterator() as $row) {
foreach ($row->getCellIterator() as $cell) {
if (preg_match("/[0-9]/", $cell->getValue())) {
$string = Helper::mb_str_split($cell->getValue());
foreach ($string as $char) {
if (ctype_digit($char)) {
$columns[PHPExcel_Cell::columnIndexFromString($cell->getColumn())]++;
}
}
}
}
}
$this->paymentColumn = array_keys($columns, max($columns))[0];
}
