如何通过Web表单将数据输入Excel表格 [英] How to enter data to excel sheet through web form
问题描述
我正在尝试创建webform并将提交的数据存储在excel表中
以下是保存为update1.html的HTML代码
I am trying to create webform and storing submitted data in excel sheet
below is the HTML code saved as"update1.html"
<form action=xcel.php method="post">
<p>
<lable>ENTER SAMPLE NAME</lable>
<input type="text" name="so">
<p>
<lable>ENTER STATUS</lable>
<input type="text" name="status">
</p>
<p><button>UPDATE</button></p>
</form>
和PHP脚本为xcel.php
and PHP script as "xcel.php"
<?php
$SO_ID=$_POST['so'];
$Status=$_POST['status'];
require_once 'Classes/PHPExcel.php';
require_once 'Classes/PHPExcel/IOFactory.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->PHPExcel_IOFactory::load("asheet.xlsx");
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', $SO_ID);
$objPHPExcel->getActiveSheet()->setCellValue('B1', $Status);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save("asheet.xlsx");
在excel表中ieasheet.xlsx2列有so和status 。
我需要从Web表单中获取用户输入,并将其存储在excel表格中,就像我们如何将数据存储在数据库中一样。
i在Excel表格中没有正确的格式化数据。 br>
任何进一步的信息随意问
提前感谢
and in excel sheet i.e "asheet.xlsx" 2 column are there "so" and "status".
I need to take user input from web form and store that in the excel sheet like how we store data in database.
i am not getting proper formatted data in excel sheet.
any further information feel free to ask
thanks in advance
推荐答案
OK,勺子喂养时间
EITHER
<?php
$SO_ID=$_POST['so'];
$Status=$_POST['status'];
$fp=fopen("/var/www/html/apps/asheet.xlsx","w");
fputcsv($fp, array($SO_ID, $Status), ';');
fclose($fp);
echo"thanks";
编写一个带有的csv文件;
分隔符,并假装它是一个Excel文件
to write a csv file with a ;
delimiter, and pretend that it's an Excel file
或
<?php
$SO_ID=$_POST['so'];
$Status=$_POST['status'];
require_once 'Classes/PHPExcel.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->setCellValue('A1', $SO_ID);
$objPHPExcel->getActiveSheet()->setCellValue('B1', $Status);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save("/var/www/html/apps/asheet.xlsx");
这篇关于如何通过Web表单将数据输入Excel表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!