Want to use 3 queries and feed 3 sheets in excel all the time I have an error
var require = global.get('require');
I corrected in settings file
Nothing helped
or maybe some quick solution what to change in code ?
[
{
"id": "184a71d3.6af50e",
"type": "function",
"z": "47d8dd38b03906ea",
"name": "",
"func": "\nmsg.attachments= [\n { \n filename: msg.filename,\n content: msg.excel,\n encoding: 'base64'\n }\n ]\n\n// if (msg.ZalaczRaportDoTresci === true)\n// {\n// msg.body = msg.payload;\n// }\n// else \n// {\n// msg.body = msg.wiadomosc;\n// }\n\nmsg.before= msg.wiadomosc;\n\n\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"x": 1065,
"y": 180,
"wires": [
[]
],
"l": false
},
{
"id": "33bd0017.24fa4",
"type": "tableify",
"z": "47d8dd38b03906ea",
"name": "",
"before": "",
"after": "",
"tableStyle": "",
"theadStyle": "",
"tbodyStyle": "",
"trStyle": "",
"tdStyle": "",
"x": 1005,
"y": 180,
"wires": [
[
"184a71d3.6af50e"
]
],
"l": false
},
{
"id": "2206a863.9f2928",
"type": "function",
"z": "47d8dd38b03906ea",
"name": "config",
"func": "msg.to = msg.mail[0].email;\nmsg.cc = 'test@test.com';\n\n\nmsg.topic='Test join xlsx to scheet nr:' ;\nmsg.filename = 'Test.xlsx';\n\nmsg.wiadomosc = 'Test Raports'; \nmsg.scheet1 = 'scheet1';\nmsg.scheet2 = 'scheet2';\nmsg.scheet3 = 'scheet3';\n\nmsg.before= \n\n`\nTest Raports\n\n\n`\n\n \n\n\nreturn msg;",
"outputs": 1,
"timeout": "",
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 780,
"y": 180,
"wires": [
[
"2515b35f.ff580c"
]
]
},
{
"id": "7549c41c.03690c",
"type": "function",
"z": "47d8dd38b03906ea",
"name": "",
"func": "msg.tableStyle=`{\n border: 1px solid #1C6EA4;\n background-color: #EEEEEE;\n width: 100%;\n text-align: left;\n border-collapse: collapse;\n}`\n\nmsg.theadStyle=` background: #1C6EA4;\n background: -moz-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);\n background: -webkit-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);\n background: linear-gradient(to bottom, #5592bb 0%, #327cad 66%, #1C6EA4 100%);\n border-bottom: 2px solid #444444;`;\n\nmsg.tbodyStyle=`font-size: 13px;`\n\nmsg.trStyle=`border: 1px solid #AAAAAA; padding: 3px 2px;`;\n\nmsg.tdStyle=`border: 1px solid #AAAAAA; padding: 3px 2px;`;\n\nreturn msg;",
"outputs": 1,
"timeout": "",
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 945,
"y": 180,
"wires": [
[
"33bd0017.24fa4"
]
],
"l": false
},
{
"id": "c46a7807.a07ad8",
"type": "MSSQL",
"z": "47d8dd38b03906ea",
"mssqlCN": "",
"name": "",
"outField": "raport02",
"returnType": "0",
"throwErrors": "0",
"query": "\nselect \n Test 1 \nFrom Test 1",
"modeOpt": "",
"modeOptType": "query",
"queryOpt": "",
"queryOptType": "editor",
"paramsOpt": "queryParams",
"paramsOptType": "msg",
"rows": "",
"rowsType": "msg",
"parseMustache": true,
"params": [],
"x": 305,
"y": 180,
"wires": [
[
"10186f43.66ff81"
]
],
"l": false
},
{
"id": "10186f43.66ff81",
"type": "MSSQL",
"z": "47d8dd38b03906ea",
"mssqlCN": "",
"name": "",
"outField": "raport03",
"returnType": "0",
"throwErrors": "0",
"query": "\nselect \n Test 2\nFrom Test 2",
"modeOpt": "",
"modeOptType": "query",
"queryOpt": "",
"queryOptType": "editor",
"paramsOpt": "queryParams",
"paramsOptType": "msg",
"rows": "",
"rowsType": "msg",
"parseMustache": true,
"params": [],
"x": 365,
"y": 180,
"wires": [
[
"31d0d7cc.138488"
]
],
"l": false
},
{
"id": "31d0d7cc.138488",
"type": "MSSQL",
"z": "47d8dd38b03906ea",
"mssqlCN": "",
"name": "",
"outField": "raport04",
"returnType": "0",
"throwErrors": "0",
"query": "\nselect \n Test 3 \nFrom Test 3",
"modeOpt": "",
"modeOptType": "query",
"queryOpt": "",
"queryOptType": "editor",
"paramsOpt": "queryParams",
"paramsOptType": "msg",
"rows": "",
"rowsType": "msg",
"parseMustache": true,
"params": [],
"x": 425,
"y": 180,
"wires": [
[
"2206a863.9f2928"
]
],
"l": false
},
{
"id": "2515b35f.ff580c",
"type": "function",
"z": "47d8dd38b03906ea",
"name": "exceljs",
"func": "msg.payload = msg.raport02;\n\nvar require = global.get('require');\nvar xl = require('exceljs');\nvar workbook = new xl.Workbook();\n\nworkbook.creator = 'NodeRed exceljs';\nworkbook.lastModifiedBy = 'NodeRed exceljs';\nworkbook.created = new Date();\nworkbook.modified = new Date();\nworkbook.lastPrinted = new Date();\n\n// create a sheet with the first row and column frozen\nvar worksheet = workbook.addWorksheet(msg.arkusz1, {views:[{state: 'frozen', ySplit:1}]});\n\n\n\nworksheet.getColumn(1).width =20;\nworksheet.getColumn(2).width =60;\nworksheet.getColumn(3).width =25;\nworksheet.getColumn(4).width =12;\nworksheet.getColumn(5).width =35;\nworksheet.getColumn(6).width =20;\nworksheet.getColumn(7).width =15;\nworksheet.getColumn(8).width =20;\nworksheet.getColumn(9).width =15;\nworksheet.getColumn(10).width =15;\nworksheet.getColumn(11).width =15;\nworksheet.getColumn(12).width =20;\nworksheet.getColumn(13).width =15;\n\n// Nazwy kolumn\nvar columns = [];\nvar col = Object.keys(msg.raport02[0]);\n\nfor(var c in col)\n{\n columns.push({\"name\": col[c], \"filterButton\": true});\n}\n\n\n\n\n\nvar table={\n name: 'Raport_inwentury_Wew',\n ref: 'A1',\n headerRow: true,\n totalsRow: false,\n style: {\n theme: 'TableStyleMedium3',\n showRowStripes: true,\n },\n columns:columns,\n rows: [],\n};\n\n\nfor(var r in msg.raport02)\n{\n table.rows.push(Object.values(msg.raport02[r]));\n}\n\n\n//worksheet.autoFilter = 'A1:Z1';\n\nif(typeof msg.raport02!== undefined && msg.raport02 !== null && msg.raport02.length>0)\n worksheet.addTable(table);\n\n\n/////////////////////////////////////////////////////\nvar worksheet2 = workbook.addWorksheet(msg.arkusz2, {views:[{state: 'frozen', ySplit:1}]});\n\nworksheet2.getColumn(1).width =50;\nworksheet2.getColumn(2).width =60;\nworksheet2.getColumn(3).width =25;\n\nvar columns2 = [];\nvar col2 = Object.keys(msg.raport01[0]);\n\nfor(var c2 in col2)\n{\n columns2.push({\"name\": col2[c2], \"filterButton\": true});\n}\n\nvar table2={\n name: 'Raport2',\n ref: 'A1',\n headerRow: true,\n totalsRow: false,\n style: {\n theme: 'TableStyleMedium3',\n showRowStripes: true,\n },\n columns:columns2,\n rows: [],\n};\n\nfor(var r2 in msg.raport01)\n{\n table2.rows.push(Object.values(msg.raport01[r2]));\n}\n\n if(typeof msg.raport01!== undefined && msg.raport01 !== null && msg.raport01.length>0)\n worksheet2.addTable(table2);\n\n\n\n\n\n/////////////////////////////////////////////////////\nvar worksheet3 = workbook.addWorksheet(msg.arkusz3, {views:[{state: 'frozen', ySplit:1}]});\n\nworksheet3.getColumn(1).width =20;\nworksheet3.getColumn(2).width =20;\nworksheet3.getColumn(3).width =75;\nworksheet3.getColumn(4).width =85;\nworksheet3.getColumn(5).width =25;\nworksheet3.getColumn(6).width =25;\nworksheet3.getColumn(7).width =15;\n\nvar columns3 = [];\nvar col3 = Object.keys(msg.raport03[0]);\n\nfor(var c3 in col3)\n{\n columns3.push({\"name\": col3[c3], \"filterButton\": true});\n}\n\n\n\n\n\nvar table3={\n name: 'Raport3',\n ref: 'A1',\n headerRow: true,\n totalsRow: false,\n style: {\n theme: 'TableStyleMedium3',\n showRowStripes: true,\n },\n columns:columns3,\n rows: [],\n};\n\n\n\n\nfor(var r3 in msg.raport03)\n{\n table3.rows.push(Object.values(msg.raport03[r3]));\n}\n\n\n\n\n\nif(typeof msg.raport03 !== undefined && msg.raport03 !== null && msg.raport03.length>0)\n worksheet3.addTable(table3);\n\n\n////////////////////////////\n//////////////////////////\n/////////////////////////////\n\nvar worksheet4 = workbook.addWorksheet(msg.arkusz4, {views:[{state: 'frozen', ySplit:1}]});\n\nworksheet4.getColumn(1).width =20;\nworksheet4.getColumn(2).width =20;\nworksheet4.getColumn(3).width =75;\nworksheet4.getColumn(4).width =85;\nworksheet4.getColumn(5).width =25;\nworksheet4.getColumn(6).width =25;\nworksheet4.getColumn(7).width =15;\n\nvar columns4 = [];\nvar col4 = Object.keys(msg.raport04[0]);\n\nfor(var c4 in col4)\n{\n columns4.push({\"name\": col4[c4], \"filterButton\": true});\n}\n\n\n\n\n\nvar table4={\n name: 'Raport4',\n ref: 'A1',\n headerRow: true,\n totalsRow: false,\n style: {\n theme: 'TableStyleMedium3',\n showRowStripes: true,\n },\n columns:columns4,\n rows: [],\n};\n\n\n\n\nfor(var r4 in msg.raport04)\n{\n table4.rows.push(Object.values(msg.raport04[r4]));\n}\n\n\n\n\n\nif(typeof msg.raport04 !== undefined && msg.raport04 !== null && msg.raport04.length>0)\n worksheet4.addTable(table4);\n\n\n\n////////////\n\n////////////////////////////\n//////////////////////////\n/////////////////////////////\n\nvar worksheet5 = workbook.addWorksheet(msg.arkusz5, {views:[{state: 'frozen', ySplit:1}]});\n\nworksheet5.getColumn(1).width =20;\nworksheet5.getColumn(2).width =20;\nworksheet5.getColumn(3).width =75;\nworksheet5.getColumn(4).width =85;\nworksheet5.getColumn(5).width =25;\nworksheet5.getColumn(6).width =25;\nworksheet5.getColumn(7).width =15;\n\nvar columns5 = [];\nvar col5 = Object.keys(msg.raport05[0]);\n\nfor(var c5 in col5)\n{\n columns5.push({\"name\": col5[c5], \"filterButton\": true});\n}\n\n\n\n\n\nvar table5={\n name: 'Raport5',\n ref: 'A1',\n headerRow: true,\n totalsRow: false,\n style: {\n theme: 'TableStyleMedium3',\n showRowStripes: true,\n },\n columns:columns5,\n rows: [],\n};\n\n\n\n\nfor(var r5 in msg.raport05)\n{\n table5.rows.push(Object.values(msg.raport05[r5]));\n \n \n}\n\n\n\n\n\nif(typeof msg.raport05 !== undefined && msg.raport05 !== null && msg.raport05.length>0)\n worksheet5.addTable(table5);\n\n\n \n\nvar worksheet6 = workbook.addWorksheet(msg.arkusz6, {views:[{state: 'frozen', ySplit:1}]});\n\nworksheet5.getColumn(1).width =20;\nworksheet5.getColumn(2).width =20;\nworksheet5.getColumn(3).width =75;\nworksheet5.getColumn(4).width =85;\nworksheet5.getColumn(5).width =25;\nworksheet5.getColumn(6).width =25;\nworksheet5.getColumn(7).width =15;\n\nvar columns6 = [];\nvar col6 = Object.keys(msg.raport06[0]);\n\nfor(var c6 in col6)\n{\n columns6.push({\"name\": col6[c6], \"filterButton\": true});\n}\n\n\n\n\n\nvar table6={\n name: 'Raport6',\n ref: 'A1',\n headerRow: true,\n totalsRow: false,\n style: {\n theme: 'TableStyleMedium3',\n showRowStripes: true,\n },\n columns:columns6,\n rows: [],\n};\n\n\n\n\nfor(var r6 in msg.raport06)\n{\n table6.rows.push(Object.values(msg.raport06[r6]));\n \n \n}\n\n\n\n\n\nif(typeof msg.raport06 !== undefined && msg.raport06 !== null && msg.raport06.length>0)\n worksheet6.addTable(table6);\n\n\n\nvar worksheet7 = workbook.addWorksheet(msg.arkusz7, {views:[{state: 'frozen', ySplit:1}]});\n\nworksheet5.getColumn(1).width =20;\nworksheet5.getColumn(2).width =20;\nworksheet5.getColumn(3).width =75;\nworksheet5.getColumn(4).width =85;\nworksheet5.getColumn(5).width =25;\nworksheet5.getColumn(6).width =25;\nworksheet5.getColumn(7).width =15;\n\nvar columns7 = [];\nvar col7 = Object.keys(msg.raport07[0]);\n\nfor(var c7 in col7)\n{\n columns7.push({\"name\": col7[c7], \"filterButton\": true});\n}\n\n\n\n\n\nvar table7={\n name: 'Raport7',\n ref: 'A1',\n headerRow: true,\n totalsRow: false,\n style: {\n theme: 'TableStyleMedium3',\n showRowStripes: true,\n },\n columns:columns7,\n rows: [],\n};\n\n\n\n\nfor(var r7 in msg.raport07)\n{\n table7.rows.push(Object.values(msg.raport07[r7]));\n \n \n}\n\n\n\n\n\nif(typeof msg.raport07 !== undefined && msg.raport07 !== null && msg.raport07.length>0)\n worksheet7.addTable(table7);\n\n\n\n\n\n\nworkbook.xlsx.writeBuffer()\n .then(function(buffer) {\n msg.excel=buffer;\n node.send(msg);\n});\n\n",
"outputs": 1,
"timeout": "",
"noerr": 3,
"initialize": "",
"finalize": "",
"libs": [],
"x": 885,
"y": 280,
"wires": [
[
"7549c41c.03690c"
]
],
"l": false
}
]
ADMIN EDIT: Wrap flows in triple backticks to make it importable
icon.