我想將 xlsx 檔案顯示為 html，但它總是回傳檔案的第一頁。我想要的是讓作者僅在有多個作業表時才顯示一個活動作業表（作業表的名稱和順序是隨機的）。這是我的代碼：
public function view_excel($path){
$file = realpath(FCPATH)."/uploads/PKB/".$path;
$reader = IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load($file);
// $spreadsheet = $spreadsheet->getActiveSheet();
$writer = IOFactory::createWriter($spreadsheet, 'Html');
$message = $writer->save('php://output');
}
有沒有辦法做到這一點 ？謝謝
uj5u.com熱心網友回復：
我設法做到了：
public function view_excel($path){
$file = realpath(FCPATH)."/uploads/PKB/".$path;
$reader = IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load($file);
$active_sheet = $spreadsheet->getActiveSheet()->getTitle();
$reader->setLoadSheetsOnly($active_sheet); //only load active sheet
$worksheet = $reader->load($file);
$writer = IOFactory::createWriter($worksheet, 'Html');
$message = $writer->save('php://output');
}
必須加載檔案兩次
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/423042.html
標籤：