Home > Web Front-end > JS Tutorial > body text

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

WBOY
Release: 2016-05-16 18:29:46
Original
1236 people have browsed it

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("
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template