# ejs_Excel_Commendline

**Repository Path**: gzmmc/ejs_Excel_Commendline

## Basic Information

- **Project Name**: ejs_Excel_Commendline
- **Description**: 在windows下，实现通过命令行调用模板引擎并生成excel
- **Primary Language**: JavaScript
- **License**: WTFPL
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2018-05-28
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# ejs_Excel_Commendline

---

#### 概述

在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的模板引擎，因此模板写法请参考下面链接。

[https://gitee.com/ccteams/ejsExcel](https://gitee.com/ccteams/ejsExcel)