Global row read type

Function Prototype

setType(array $type)

Test data preparation

$config = ['path' => './tests'];
$excel = new \Vtiful\Kernel\Excel($config);

$filePath = $excel->fileName('tutorial.xlsx')
    ->header(['Name', 'Age', 'Date'])
    ->data([
        ['Viest', 24]
    ])
    ->insertDate(1, 2, 1568877706)
    ->output();

Example

$data = $excel->openFile('tutorial.xlsx')
    ->openSheet()
    ->setType([
        \Vtiful\Kernel\Excel::TYPE_STRING,
        \Vtiful\Kernel\Excel::TYPE_INT,
        \Vtiful\Kernel\Excel::TYPE_TIMESTAMP,
    ])
    ->getSheetData();

var_dump($data);

Sample output

array(2) {
   [0]=>
   Array(3) {
     [0]=>
     String(4) "Name"
     [1]=>
     String(3) "Age"
     [2]=>
     String(4) "Date"
   }
   [1]=>
   Array(3) {
     [0]=>
     String(5) "Viest"
     [1]=>
     Int(24)
     [2]=>
     Int(1568877706)
   }
}