使用phpExcel库将新行追加到excel文件 [英] Append new row to excel file using phpExcel library

问题描述

我也是php和phpExcel的新手.我只想每次将发布数据保存到现有的Excel工作表到新行.

I am new to php as well to phpExcel . I just want to save post data to a existing excel sheet every time to a new row.

在 Stackoverflow.com 中进行搜索时，我得到了库phpExcel的引用.

As i searched on Stackoverflow.com i got the reference of library phpExcel.

我从一些示例中写下以下代码.

I write down the following code from taking some samples.

<?php 

/** Include PHPExcel */
require_once 'Classes/PHPExcel.php';

$objPHPExcel = new PHPExcel();

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row, $_POST['name']);
$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row, $_POST['email']);
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$row, $_POST['phone']);
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$row, $_POST['city']);
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$row, $_POST['kid1']);
$objPHPExcel->getActiveSheet()->SetCellValue('F'.$row, $_POST['kid2']);
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('myfile.xlsx');    

?>

但是我面临的问题是我不知道如何在Excel工作表中追加新行，因此每次将发布的数据保存到新行中.

but the problem i am facing that i don't have idea how to append new row to excel sheet so every time posted data saved to new row.

我知道我的这段代码每次都只将文件保存到磁盘上，但是我需要在最后的Excel工作表中追加新行.

I know my this code is only saving file to disk everytime with a single row, but i need to append new row to last excel sheet.

推荐答案

<?php 

/** Include PHPExcel */
require_once 'Classes/PHPExcel.php';
require_once 'Classes/PHPExcel/IOFactory.php';

$objPHPExcel = PHPExcel_IOFactory::load("myfile.xlsx");
$objPHPExcel->setActiveSheetIndex(0);
$row = $objPHPExcel->getActiveSheet()->getHighestRow()+1;
//echo $row;
$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row, $_POST['name']);
$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row, $_POST['email']);
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$row, $_POST['phone']);
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$row, $_POST['city']);
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$row, $_POST['kid1']);
$objPHPExcel->getActiveSheet()->SetCellValue('F'.$row, $_POST['kid2']);
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('myfile.xlsx');
?>

这篇关于使用phpExcel库将新行追加到excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！