var xlsx = require('node-xlsx');
var fs = require('fs');// read
var obj = xlsx.parse('APPString.xls');
console.log("读取开始......");
function dealSpaceChar(oldChar){
oldChar=oldChar.replace("'","&apos");///替换单引号
oldChar=oldChar.replace("\"",""");///替换双引号
oldChar=oldChar.replace(" "," ");///替换空格号
oldChar=oldChar.replace("<","<");
oldChar=oldChar.replace(">",">");
oldChar=oldChar.replace("-","–");
oldChar=oldChar.replace("&","&#amp");///替换空格号
return oldChar;
}
for (var i = 0; i < obj.length; i++) {
if (i==0) {
var sheet=obj[i];
var jsonData=JSON.stringify(obj[i]);
var arr= JSON.parse(jsonData);
var fileName="";
for (var index = 2; index < arr.data.length; index++) {
for (var columnindex = 8; columnindex < arr.data[index].length; columnindex++) {
生成xml节点名称
if (index>1&&columnindex>7) {
var str=arr.data[index][columnindex];
if (str!=null&&str!="") {
str=dealSpaceChar(str);
var xmlNode=arr.data[index][0].replace("S:AppCenter:","");
fileName=("string-"+arr.data[0][columnindex].toLowerCase()+".xml");
xmlNode="<string name=\""+xmlNode+"\">"+str+"<\/string>\n";
fs.appendFile(fileName,xmlNode,'utf8',function(){});
}
}
}
}
}
}
var fs = require('fs');// read
var obj = xlsx.parse('APPString.xls');
console.log("读取开始......");
function dealSpaceChar(oldChar){
oldChar=oldChar.replace("'","&apos");///替换单引号
oldChar=oldChar.replace("\"",""");///替换双引号
oldChar=oldChar.replace(" "," ");///替换空格号
oldChar=oldChar.replace("<","<");
oldChar=oldChar.replace(">",">");
oldChar=oldChar.replace("-","–");
oldChar=oldChar.replace("&","&#amp");///替换空格号
return oldChar;
}
for (var i = 0; i < obj.length; i++) {
if (i==0) {
var sheet=obj[i];
var jsonData=JSON.stringify(obj[i]);
var arr= JSON.parse(jsonData);
var fileName="";
for (var index = 2; index < arr.data.length; index++) {
for (var columnindex = 8; columnindex < arr.data[index].length; columnindex++) {
生成xml节点名称
if (index>1&&columnindex>7) {
var str=arr.data[index][columnindex];
if (str!=null&&str!="") {
str=dealSpaceChar(str);
var xmlNode=arr.data[index][0].replace("S:AppCenter:","");
fileName=("string-"+arr.data[0][columnindex].toLowerCase()+".xml");
xmlNode="<string name=\""+xmlNode+"\">"+str+"<\/string>\n";
fs.appendFile(fileName,xmlNode,'utf8',function(){});
}
}
}
}
}
}