查看“Widget:TemplateToExcel”的源代码

<includeonly><textarea id="TTEpage" style="width:100%;height:300px"></textarea>
<button id="TTEsubmit" style="padding:0.5em 1em">确认</button>
<textarea id="TTEexcel" style="width:100%;height:300px" readonly></textarea>
<script>
TTEMeta={
	"page":[],
	"state":"ready",
	"data":[],
	"table":[],
}
TTEFun={
	"initialize":function(){
		TTEMeta.wiki=mw.config.values.wgScriptPath
		document.getElementById("TTEpage").oninput=function(){
			TTEMeta.page=this.value.split("\n")
		}
		document.getElementById("TTEsubmit").onclick=function(){
			if(TTEMeta.state=="ready"){
				TTEMeta.state=TTEMeta.page.length
				document.getElementById("TTEpage").readOnly=true
				TTEFun.sendPage()
			}
		}
	},
	"sendPage":function(){
		document.getElementById("TTEexcel").value="生成中…（"+(TTEMeta.state-TTEMeta.page.length)+"/"+TTEMeta.state+"）"
		let page=TTEMeta.page.shift()
		if(page){
			let url="https://wiki.biligame.com"+TTEMeta.wiki+"/api.php?action=parse&format=json&prop=wikitext"
			url+="&page="+page
			getApi(url,function(json){
				let wikitext=JSON.parse(json).parse.wikitext["*"]
				TTEMeta.data.push(wikitext)
				TTEFun.sendPage()
			})
		}
		else{
			TTEMeta.page=document.getElementById("TTEpage").value.split("\n")
			TTEMeta.table.push([])
			let head=TTEMeta.data[0]
			TTEMeta.table[0].push(head.match(/\{\{(.*)\n/)[1])
			let key=[...head.matchAll(/\|(.*)=/g)]
			key.forEach(function(e){TTEMeta.table[0].push(e[1])})
			for(let i=0,ilen=TTEMeta.data.length;i<ilen;i++){
				let row=[]
				row.push(TTEMeta.page[i])
				let value=[...TTEMeta.data[i].matchAll(/\=(.*)/g)]
				value.forEach(function(e,i){row.push(e[1])})
				TTEMeta.table.push(row)
			}
			let result=""
			for(let i=0,ilen=TTEMeta.table.length;i<ilen;i++){
				for(let j=0,jlen=TTEMeta.table[i].length;j<jlen;j++){
					result+=TTEMeta.table[i][j]+"\t"
				}
				result+="\n"
			}
			document.getElementById("TTEexcel").value=result
			document.getElementById("TTEexcel").readOnly=false
		}
	},
}
function getApi(url,callback=false,callbackE=false){
	let ajax=new XMLHttpRequest()
	if(!callback){
		ajax.open("GET",url,false)
		ajax.send()
		let json=JSON.parse(ajax.responseText)
		return json
	}
	ajax.open("GET",url)
	ajax.send()
	ajax.onreadystatechange=function(){
		if(ajax.readyState==4){
			if(ajax.status==200){
				callback(ajax.responseText)
			}
			else if(ajax.status==404&&callbackE){
				callbackE(true)
			}
		}
	}
}
window.addEventListener("load",function(){
	TTEFun.initialize()
})
</script>
<style>
textarea[readonly]{
	color:lightgray;
}
</style></includeonly><noinclude>{{#widget:{{PAGENAME}}}}</noinclude>