JS Excel read and write operations (template operations) implementation code_javascript skills

I figured out how to read and write Excel (template) data with JS in an actual project, including how to use JS to insert pictures into Excel.
First, add a public template address JS, as follows:
AddZDaddress.js

Copy code The code is as follows:

//////////////////////////////////// ///////////////////////////////////////////////////// //////////////
////DocName: Trust site address addition--AddZDaddress.js
////Author:lify
////Company :Wavenet
////Date:2009-11-04
////EditDate:2010-03-11
////MainContent:Findings,Ajax And So On;
/ ///////////////////////////////////////////////////// //////////////////////////////////////////////////
var BelieveAddress='172.18.1.25/psc1';////Configuration address required when configuring the address configuration program
////**************************************Excel imported into WEB interface template address collection********** **********************************//
//////// ////////////////////Flight detection excel template address configuration//////////////////////////// //////////////////////////////////////
var template_path_FxjcExcelDatasIntoSqlDatas = "http://" believeaddress "/ NewReports/xls_template/Flight detection of main pollutant concentrations in and out of urban sewage plants.xls";
///////////////////////////// ///////////////////////////////////////////////////// ///////////////////////////////////
////***********************************************************************************************************//
////*********************************Excel entry template import address collection**************** **********************************//
///////////////////////////Monthly report import excel address configuration/ ///////////////////////////////////
var template_path_month = "http://" believeaddress "/NewReports/ xls_template/Shanghai Wastewater Treatment Enterprise Production Operation Table.xls";
////////////////////////////////// //////////////////////////////////////////////////
/////////////////////////////Annual report import excel address configuration/////////////////// ////////////////
var template_path_year = "http://" believeaddress "/NewReports/xls_template/Shanghai Sewage Treatment Facilities Information Table.xls";
/ ///*******************************************************************************************************//
//Picture address
var pic_path="http://" believeaddress "/NewReports/";
//////////// ///////////////////////////////////////////////////// ///////////////////

Again, how to read the page data into JS in Excel, as follows:
YearReportLuRu.jsYearReportLuRu .js

Copy code The code is as follows:

////DocName:污水处理设施信息表(年报)-录入报表--YearReportLuRu.js
////Author:lify
////Company:Wavenet
////Date:2009-08-14
////EditDate:2009-08-14
////MainContent:Findings,Ajax And So On;
///////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////添加正则表达式类/////////////////////////////////////////////////////////////
document.write("

最后，如何读取到Excel模板中数据到页面上共客户编辑数据再保存到数据库中（此步可以用xml发送至后台交互，在此不进一步说明）JS，如下：
Fxjc_ExcelDatasIntoSqlDatas.js

复制代码 代码如下:

////DocName: Import template data function--Fxjc_ExcelDatasIntoSqlDatas.js
////Author:lify
////Company:Wavenet
////Date: 2010-03-12
////EditDate:2010-03-12
////MainContent:Findings,Ajax And So On;
//////////// ///////////////////////////////////////////////////// ///////////////////////////////////////
var excelFileName=""; //Local EXCEL address
var oWB;
var idTmr="";
function AutomateExcel3()
{
//Delete all rows except the first 2 rows of the PT table
DeleteTablePT();
//alert(pic_path document.getElementById("ImgUrl").value);//Test
var xls=null;
var newBook;
try{
xls = new ActiveXObject(" Excel.Application");
}catch(e){openBg(0);openTS(0);
alert("Please open the ActiveX control. Specific operation: click "Tools" in IE "Internet Options", click "Security", "Custom Level", "ActiveX Controls and Plug-ins", please select the third item to enable.Detailed error: " e.message);
return ;
}
if (xls == null){openBg(0);openTS(0);
alert("Failed to create Excel file, It may be that Microsoft Office Excel software is not installed correctly on your computer or the security level of the browser is set too high!");
return;
}
try{
newBook ​​= xls.Workbooks.Open (excelFileName);//The parameter in the Add method here is the path of the template
}catch(e){openBg(0);openTS(0);
alert("The path to the loaded Excel file is wrong! Details: " e.message);
return ;
}
var oSheet=newBook.ActiveSheet;
//////////////////// //////////////////////////The template writes data to the WEB page/////////////////// ////////////////////////////////////////////
var xhnum=0;
//alert("oSheet.Cells(3,18).value=" oSheet.Cells(3,18).value "|" (oSheet.Cells(3,5).value=="for(var i=3;i{
if(oSheet.Cells(i,1).value)
{
xhnum ;
var newRow = document.getElementById("PT").insertRow(-1);
var newCell;
newRow.align = "center";
newRow.height = "35px";
for(var j=0;j{
if(j== 4)
{
//Do nothing
}
else if(j{
newCell = newRow.insertCell(j);
if( j==0) newCell.innerHTML = (xhnum).toString();//Serial number
else if(j==1)
{
if(!oSheet.Cells(i,1). value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,1).value=="——"||oSheet.Cells(i,1).value=="- -")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,1).value==""?" ":oSheet.Cells(i,1 ).value);
}
else if(j==2)
{
if(!oSheet.Cells(i,2).value)
newCell.innerHTML = " " ;
else if(oSheet.Cells(i,2).value=="——"||oSheet.Cells(i,2).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,2).value==""?" ":oSheet.Cells(i,2).value);
//newCell .innerHTML = (oSheet.Cells(i,2).value==""?" ":oSheet.Cells(i,2).value);
}
else if(j==3)
{
if(!oSheet.Cells(i,4).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,4).value=="— —"||oSheet.Cells(i,4).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,4 ).value==""?" ":oSheet.Cells(i,4).value);
//newCell.innerHTML = (oSheet.Cells(i,4).value==""?" " :oSheet.Cells(i,4).value);
}
else if(j==9)
{
if(!oSheet.Cells(i,j 1).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,j 1).value=="newCell.innerHTML = "30";
else if(oSheet.Cells(i,j 1).value=="——"||oSheet.Cells(i,j 1).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,j 1).value==""?" ":oSheet.Cells(i,j 1).value);
}
else
{
if(!oSheet.Cells(i,j 1).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,j 1).value == "newCell.innerHTML = "30";
else if(oSheet.Cells(i,j 1).value=="

newCell.innerHTML = " ";
else if(oSheet.Cells(i,j 1).value=="——"||oSheet.Cells(i,j 1).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,j 1).value==""?" ":oSheet.Cells(i,j 1).value) ;
}
}
else
{
newCell = newRow.insertCell(j-1);//Just one less is enough, less sample number is inserted
if(j= =0) newCell.innerHTML = (xhnum).toString();//Serial number
else if(j==1)
{
if(!oSheet.Cells(i,1).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,1).value=="——"||oSheet.Cells(i,1).value=="--" )
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,1).value==""?" ":oSheet.Cells(i,1). value);
}
else if(j==2)
{
if(!oSheet.Cells(i,2).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,2).value=="——"||oSheet.Cells(i,2).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,2).value==""?" ":oSheet.Cells(i,2).value);
//newCell.innerHTML = (oSheet.Cells(i,2).value==""?" ":oSheet.Cells(i,2).value);
}
else if(j==3)
{
if(!oSheet.Cells(i,4).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,4).value=="——" ||oSheet.Cells(i,4).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,4). value==""?" ":oSheet.Cells(i,4).value);
//newCell.innerHTML = (oSheet.Cells(i,4).value==""?" ":oSheet .Cells(i,4).value);
}
else if(j==9)
{
if(!oSheet.Cells(i,j 1).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,j 1).value=="newCell.innerHTML = "30";
else if( oSheet.Cells(i,j 1).value=="——"||oSheet.Cells(i,j 1).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,j 1).value==""?" ":oSheet.Cells(i,j 1).value);
}
else
{
if(!oSheet.Cells(i,j 1).value)
newCell.innerHTML = " ";
else if(oSheet.Cells(i,j 1).value=="newCell.innerHTML = "30";
else if(oSheet.Cells(i,j 1).value=="

newCell.innerHTML = " ";
else if(oSheet.Cells(i,j 1).value=="——"||oSheet.Cells(i,j 1).value=="--")
newCell.innerHTML = " ";
else
newCell.innerHTML = (oSheet.Cells(i,j 1).value==""?" ":oSheet.Cells(i,j 1).value);
}
}
}
}
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
newBook.Close();
newBook=null;
xls = null;
openBg(0);openTS(0);
///////////////////////////////开启编辑和保存按钮功能///////////////////////////////////
OnOrOffBtn(1);
////////////////////////////////////////////////////////////////////////////////////////
idTmr = window.setInterval("Cleanup();",1);
////////////////////////////////表格数字和字符转化//////////////////////////////////////
TableIntoDatas();////表格数字和字符转化
////////////////////////////////////////////////////////////////////////////////////////
}

其实做报表很痛苦，但是从中也能经历不少。很高兴以此文章让那些报表高手前来指导和拍砖。谢谢了！
以上为针对excel模板总结的一些方法，欢迎各位前来拍砖！也欢迎大家来交流交流！