在我的站點中，用戶填寫數據時有一個表格，數據將寫入一個 .xls 文件并存儲在我的電腦中。但是，所有數據都存儲在一個 .xls 文件下，該文件最終會變得非常長且不整潔。我想讓我的系統每周生成一個新的 .xls 文件，以便可以按周存儲數據。這是我當前的代碼，我想知道有沒有辦法讓它發生？謝謝你！$objPHPExcel = PHPExcel_IOFactory::load("hii.xls");$objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setCellValue('A1','Name of Stakeholder(s)'); $objPHPExcel->getActiveSheet()->setCellValue('B1','NRIC No./Passport No./Company No.'); $objPHPExcel->getActiveSheet()->setCellValue('C1','Email'); $objPHPExcel->getActiveSheet()->setCellValue('D1','Contact Number'); $objPHPExcel->getActiveSheet()->setCellValue('E1','CDS Account No.'); $objPHPExcel->getActiveSheet()->setCellValue('F1','Correspondence Address'); $objPHPExcel->getActiveSheet()->setCellValue('G1','Date Submitted');$row = $objPHPExcel->getActiveSheet()->getHighestRow()+1;$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row, $_POST['name']);$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row, $_POST['ic']);$objPHPExcel->getActiveSheet()->SetCellValue('C'.$row, $_POST['email']);$objPHPExcel->getActiveSheet()->SetCellValue('D'.$row, $_POST['phone']);$objPHPExcel->getActiveSheet()->SetCellValue('E'.$row, $_POST['cds']);$objPHPExcel->getActiveSheet()->SetCellValue('F'.$row, $_POST['address']);$objPHPExcel->getActiveSheet()->SetCellValue('G'.$row, $_POST['date']);$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $from = "A1"; $to = "G1";$objPHPExcel->getActiveSheet()->getStyle("$from:$to")->getFont()->setBold(true);$objWriter->save('hii.xls');
1 回答
白衣非少年
TA貢獻1155條經驗 獲得超0個贊
您可以使用它存檔DateTime()以確定一年中的當前周。
這應該如下所示。
// Get the current week of year
$date = new DateTime('now');
$week = $date->format("W");
// Path to the file storage (in this case the same folder as this script)
$path = __DIR__;
// Set file name for excel file and combine with the path
$file = $path . '/week-' . $week . '.xls';
// Determine if file exists
if (!is_file($file)) {
// File doesn't exists, so we create a new file
$objPHPExcel = new PHPExcel();
} else {
// File exists, so we load this file
$objPHPExcel = PHPExcel_IOFactory::load($file);
}
// Your existing code to write the data
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1','Name of Stakeholder(s)');
$objPHPExcel->getActiveSheet()->setCellValue('B1','NRIC No./Passport No./Company No.');
$objPHPExcel->getActiveSheet()->setCellValue('C1','Email');
$objPHPExcel->getActiveSheet()->setCellValue('D1','Contact Number');
$objPHPExcel->getActiveSheet()->setCellValue('E1','CDS Account No.');
$objPHPExcel->getActiveSheet()->setCellValue('F1','Correspondence Address');
$objPHPExcel->getActiveSheet()->setCellValue('G1','Date Submitted');
$row = $objPHPExcel->getActiveSheet()->getHighestRow()+1;
$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row, $_POST['name']);
$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row, $_POST['ic']);
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$row, $_POST['email']);
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$row, $_POST['phone']);
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$row, $_POST['cds']);
$objPHPExcel->getActiveSheet()->SetCellValue('F'.$row, $_POST['address']);
$objPHPExcel->getActiveSheet()->SetCellValue('G'.$row, $_POST['date']);
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$from = "A1";
$to = "G1";
$objPHPExcel->getActiveSheet()->getStyle("$from:$to")->getFont()->setBold(true);
// Save the excel file
$objWriter->save($file);
- 1 回答
- 0 關注
- 133 瀏覽
添加回答
舉報
0/150
提交
取消