Skip to content

Instantly share code, notes, and snippets.

@ydenissov

ydenissov/parse_xlsx.php

Created December 1, 2022 04:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ydenissov/e23baea62cc0b36ecd661fd48007948a to your computer and use it in GitHub Desktop.
Save ydenissov/e23baea62cc0b36ecd661fd48007948a to your computer and use it in GitHub Desktop.
Download ZIP
Parse XLSX
Raw
parse_xlsx.php
<?php
function parseFile($inputFileName) {
$inputFileType = \PhpOffice\PhpSpreadsheet\IOFactory::identify($inputFileName);
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
$spreadsheet = $reader->load($inputFileName);
$data = $spreadsheet->getActiveSheet()->toArray();
// Remove header
unset($data[0]);
return $data;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment