如何通过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屋！