π Convert JSON to Excel XLSX with offloading the constructing the data using a worker thread
Utility to convert json to an excel file, based on Node-Excel-Export using a worker thread by not blocking the NodeJs event loop using async functions and options.
This is a totally fork of the json2xls , but the XLSX constructing can be CPU intensive so we are offloading the XLSX constructing using a worker thread.
Of course, when using a worker thread, the execution is about 20-25ms longer, than when we are in the event loop, so the worker thread is valid when we are generating a big dataset.
Installation
npm install p3x-json2xls-worker-threadUsage
Use to save as file:
const json2xls = require('p3x-json2xls-worker-thread')
const fs = require('fs').promises
const json = {
foo: 'bar',
qux: 'moo',
poo: 123,
stux: new Date()
}
const executAsync = async() => {
try {
//
let nodeExcelOptions = undefined
/*
The following options are supported:
- style: a styles xml file, see <https://github.com/functionscope/Node-Excel-Export>
- fields: either an array or map containing field configuration:
- array: a list of names of fields to be exported, in that order
- object: a map of names of fields to be exported and the types of those fields. Supported types are 'number','string','bool'
*/
if (ifSomeConditionIsTrue) {
nodeExcelOptions = {
fields: ['poo']
}
}
const options = {
output: 'binary' /* default */ || 'base64',
nodeExcel: nodeExcelOptions
}
const xlsBinary = await json2xls(json, options)
await fs.writeFile('data.xlsx', xlsBinary, 'binary');
} catch(e) {
// handle error
console.error(e)
}
}
executAsync()Or use as express middleware. It adds a convenience xls method to the response object to immediately output an excel as download.
const json2xls = require('p3x-json2xls-worker-thread')
const jsonArr = [{
foo: 'bar',
qux: 'moo',
poo: 123,
stux: new Date()
},
{
foo: 'bar',
qux: 'moo',
poo: 345,
stux: new Date()
}];
app.use(json2xls.middleware);
app.get('/',function(req, res) {
res.xls('data.xlsx', jsonArr);
});It is possible to block the event loop by using the sync function eg.:
const json2xls = require('p3x-json2xls-worker-thread')
const json = {
foo: 'bar',
qux: 'moo',
poo: 123,
stux: new Date()
}
const xlsBinary = json2xls.sync(json, {
output: 'base64' // can be binary as well, just sugar...
})
console.log(xlsBinary)Corifeus Network
AI-powered network & email toolkit β free, no signup.
Web Β· network.corifeus.com MCP Β· npm i -g p3x-network-mcp
- AI Network Assistant β ask in plain language, get a full domain health report
- Network Audit β DNS, SSL, security headers, DNSBL, BGP, IPv6, geolocation in one call
- Diagnostics β DNS lookup & global propagation, WHOIS, reverse DNS, HTTP check, my-IP
- Mail Tester β live SPF/DKIM/DMARC + spam score + AI fix suggestions, results emailed (localized)
- Monitoring β TCP / HTTP / Ping with alerts and public status pages
- MCP server β 17 tools exposed to Claude Code, Codex, Cursor, any MCP client
- Install β
claude mcp add p3x-network -- npx p3x-network-mcp - Try β "audit example.com", "why do my emails land in spam? test me@example.com "
- Source β patrikx3/network Β· patrikx3/network-mcp
- Contact β patrikx3.com Β· donate
Support Our Open-Source Project
If you appreciate our work, consider starring this repository or
making a donation to support server maintenance and ongoing development. Your support means the world to usβthank you!
About My Domains
All my domains, including patrikx3.com , corifeus.eu , and corifeus.com, are developed in my spare time. While you may encounter minor errors, the sites are generally stable and fully functional.
Versioning Policy
Version Structure: We follow a Major.Minor.Patch versioning scheme:
- Major:
Corresponds to the current year.
- Minor:
Set as 4 for releases from January to June, and 10 for July to December.
- Patch:
Incremental, updated with each build.
Important Changes: Any breaking changes are prominently noted in the readme to keep you informed.
P3X-JSON2XLS-WORKER-THREAD Build v2026.4.123