I have an excel file suppose with column value "A B" what i want is to separate the values after the first space i.e A in another column and B in other. I used PHPEXCEL
<?php
class SampleReadFilter implements PHPExcel_Reader_IReadFilter {
public function readCell($column, $row, $worksheetName = '') {
// Read rows 1 to 10 and columns A to C only
if ($row >= 1 && $row <= 7) {
if (in_array($column,range('A','C'))) {
return true;
}
}
return false;
}
}