BIM-Monitor/excelToCsv.php

<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();

$reader->setLoadSheetsOnly(["ELP (增設)"]);
$spreadsheet = $reader->load("EOW_ELP_ELP_11.xlsx");
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Csv($spreadsheet);
$writer->save("ELP.csv");
$reader->setLoadSheetsOnly(["EOW-1(1230~"]);
$spreadsheet = $reader->load("EOW_ELP_ELP_11.xlsx");
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Csv($spreadsheet);
$writer->save("OW.csv");




?>