Excel 파일 처리 및 조작에 PHP를 사용하는 방법

getActiveSheet(); // 遍历每一行，并获取每一列的值 foreach ($sheet->getRowIterator() as $row) { $cellIterator = $row->getCellIterator(); $cellIterator->setIterateOnlyExistingCells(FALSE); foreach ($cellIterator as $cell) { echo $cell->getValue() . " "; } echo "
"; } ?>

setActiveSheetIndex(0); $sheet = $objPHPExcel->getActiveSheet(); // 设置表头 $sheet->setCellValue('A1', '编号'); $sheet->setCellValue('B1', '姓名'); $sheet->setCellValue('C1', '年龄'); // 查询数据库，获取数据 $conn = mysqli_connect("localhost", "root", "password", "database"); $result = mysqli_query($conn, "SELECT * FROM users"); // 将查询结果写入Excel文件 $i = 2; while ($row = mysqli_fetch_array($result)) { $sheet->setCellValue('A' . $i, $row['id']); $sheet->setCellValue('B' . $i, $row['name']); $sheet->setCellValue('C' . $i, $row['age']); $i++; } // 保存Excel文件 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('output.xlsx'); ?>

setActiveSheetIndex(0); $sheet = $objPHPExcel->getActiveSheet(); // 设置表头 $sheet->setCellValue('A1', '编号'); $sheet->setCellValue('B1', '姓名'); $sheet->setCellValue('C1', '年龄'); // 数组数据 $data = array( array('1', '张三', '20'), array('2', '李四', '25'), array('3', '王五', '30') ); // 将数组数据写入Excel文件 $i = 2; foreach ($data as $row) { $sheet->setCellValue('A' . $i, $row[0]); $sheet->setCellValue('B' . $i, $row[1]); $sheet->setCellValue('C' . $i, $row[2]); $i++; } // 保存Excel文件 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('output.xlsx'); ?>