代码拉取完成,页面将自动刷新
在windows下,实现通过命令行调用模板引擎并生成excel
git clone 后 要记得 npm install
node make_Excel.js data_String template_Path output_Path
data_String : 把对应的数据JSON字符串的所有双引号变成连续的三个双引号后的字符串。因为windows命令行中需要把双引号转义后才能作为参数传递进去。
template_Path : 模板xlsx路径
output_Path : 输出的xlsx路径
node ./make_Excel.js [{"""item""":"""Monday""","""run""":"""1""","""bicycle""":"""1.5""","""aerobic""":"""0.5"""," ""swim""":"""-""","""aerobics""":"""0.5""","""tennis""":"""1""","""brisk_walk""":"""-""","""dance""":"""2"""},{"""item""":"""Tuesday""","""run""":"""1""","""bicycle""":"""1.5""","""aerobic""":"""0.5""","""swim""":"""2""","""aerobics""":"""0.5""","""tennis""":"""1""","""brisk_walk""":"""-""","""dance""":"""-"""},{"""item""":"""Wednesday""","""run""":"""1""","""bicycle""":"""1.5""","""aerobic""":"""0.5""","""swim""":"""-""","""aerobics""":"""0.5""","""tennis""":"""1""","""brisk_walk""":"""-""","""dance""":"""2"""},{"""item""":"""Thursday""","""run""":"""2""","""bicycle""":"""1.5""","""aerobic""":"""0.5""","""swim""":"""-""","""aerobics""":"""0.6""","""tennis""":"""1""","""brisk_walk""":"""2""","""dance""":"""-"""},{"""item""":"""Friday""","""run""":"""1""","""bicycle""":"""1.5""","""aerobic""":"""0.5""","""swim""":"""-""","""aerobics""":"""0.5""","""tennis""":"""1""","""brisk_walk""":"""-""","""dance""":"""2"""},{"""item""":"""Saturday""","""run""":"""3""","""bicycle""":"""1.5""","""aerobic""":"""0.5""","""swim""":"""1""","""aerobics""":"""0.7""","""tennis""":"""2""","""brisk_walk""":"""4""","""dance""":"""-"""},{"""item""":"""Sunday""","""run""":"""1""","""bicycle""":"""1.5""","""aerobic""":"""0.5""","""swim""":"""-""","""aerobics""":"""0.5""","""tennis""":"""1""","""brisk_walk""":"""-""","""dance""":"""2"""}] "./test/template_1.xlsx" "./output.xlsx"
用的是Sail大神搞的ejsExcel的模板引擎,因此模板写法请参考下面链接。
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。