如何解析HTML中的数据并在Excel中导出 [英] How to parse data from HTML and export in Excel in PHP
本文介绍了如何解析HTML中的数据并在Excel中导出的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请建议我,我是新来的。
JS :
function write_to_excel(){
str =;
var mytable = document.getElementsByTagName(table)[0];
var rowCount = mytable.rows.length;
var colCount = mytable.getElementsByTagName(tr)[0] .getElementsByTagName(td)。
var ExcelApp = new ActiveXObject(Excel.Application);
var ExcelSheet = new ActiveXObject(Excel.Sheet);
ExcelSheet.Application.Visible = true; (var i = 0; i< rowCount; i ++)
{
for(var j = 0; j< colCount; j ++)
{
str = mytable.getElementsByTagName(tr)[i] .getElementsByTagName(td)[j] .innerHTML;
ExcelSheet.ActiveSheet.Cells(i + 1,j + 1).Value = str;
}
}
}
解决方案
从PHP:
$ objReader = PHPExcel_IOFactory :: createReader('HTML');
$ objPHPExcel = $ objReader-> load(myHtmlFile.html);
$ objWriter = PHPExcel_IOFactory :: createWriter($ objPHPExcel,'Excel2007');
$ objWriter-> save(myExcelFile.xlsx);
I want to read HTML table data from HTML page (without using of data base) and Export into Excel file . I am using this Javascript cede but it is not working. Please Suggest me, I am new here.
JS:
function write_to_excel() {
str="";
var mytable = document.getElementsByTagName("table")[0];
var rowCount = mytable.rows.length;
var colCount = mytable.getElementsByTagName("tr")[0].getElementsByTagName("td").length;
var ExcelApp = new ActiveXObject("Excel.Application");
var ExcelSheet = new ActiveXObject("Excel.Sheet");
ExcelSheet.Application.Visible = true;
for(var i=0; i<rowCount; i++)
{
for(var j=0; j<colCount; j++)
{
str= mytable.getElementsByTagName("tr")[i].getElementsByTagName("td")[j].innerHTML;
ExcelSheet.ActiveSheet.Cells(i+1,j+1).Value = str;
}
}
}
解决方案
From PHP :
$objReader = PHPExcel_IOFactory::createReader('HTML');
$objPHPExcel = $objReader->load("myHtmlFile.html");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save("myExcelFile.xlsx");
这篇关于如何解析HTML中的数据并在Excel中导出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文