nodejs excel template engine. node export excel, ejsExcel
npm install ejsexcel
执行 test/test.bat
test/test.bat
test/test.xlsx 为完整示例 demo
e.g
const ejsexcel = require("ejsexcel");
const fs = require("fs");
const util = require("util");
const readFileAsync = util.promisify(fs.readFile);
const writeFileAsync = util.promisify(fs.writeFile);
(async function() {
//获得Excel模板的buffer对象
const exlBuf = await readFileAsync("./test.xlsx");
//数据源
const data = [];
//用数据源(对象)data渲染Excel模板
const exlBuf2 = await ejsexcel.renderExcel(exlBuf, data);
await writeFileAsync("./test2.xlsx", exlBuf2);
console.log("生成test2.xlsx");
})();
| Syntax | Description |
|---|---|
| data | data 为内置对象, 数据源 |
| <%forRow | 循环一行 |
| <%# | 输出动态公式 |
| <%~ | 输出数字类型格式 |
| <%= | 输出字符串 |
| <%forCell | 循环单元格 |
| <%forRBegin | 循环多行 |
| <%forCBegin | 循环多个单元格 |
| <%hideSheet()%> | 隐藏所在工作表 |
| <%showSheet()%> | 显示所在工作表 |
| <%deleteSheet()%> | 删除所在工作表 |
| <% %> | 内部可执行 任意 javascript,可以用 <%console.log(data)%> 打印临时变量到控制台,进行调试 |
做一个这样的模版
加数据渲染之后,导出结果
FAQs
Intelligent report system, nodejs node export excel, ejsExcel
The npm package ejsexcel receives a total of 199 weekly downloads. As such, ejsexcel popularity was classified as not popular.
We found that ejsexcel demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Deno 2.2 enhances Node.js compatibility, improves dependency management, adds OpenTelemetry support, and expands linting and task automation for developers.
Security News
React's CRA deprecation announcement sparked community criticism over framework recommendations, leading to quick updates acknowledging build tools like Vite as valid alternatives.
Security News
Ransomware payment rates hit an all-time low in 2024 as law enforcement crackdowns, stronger defenses, and shifting policies make attacks riskier and less profitable.