exceljs
exceljs copied to clipboard
_xlnm._FilterDatabase has oversized JavaScript heap out of memory
I'm having a problem at work, I don't know how create _FilterDatabase but Area size is (8752-3) * (16364 - 1)
definedName = {
"name": "_xlnm._FilterDatabase",
"ranges": ["Sheet1!$A$3:$XEJ$8752"]
}
address = {
top: 3,
left: 1,
bottom: 8752,
right: 16364,
sheetName: "Sheet1",
tl: {
address: "A3",
col: 1,
row: 3,
$col$row: "$A$3",
sheetName: "Sheet1",
},
br: {
address: "XEJ8752",
col: 16364,
row: 8752,
$col$row: "$XEJ$8752",
sheetName: "Sheet1",
},
dimensions: "A3:XEJ8752",
}
error:
<--- Last few GCs --->
[2747:0x7fdbb8008000] 18040 ms: Mark-Compact (reduce) 4062.9 (4141.5) -> 4062.5 (4141.5) MB, 3109.8 / 0.0 ms (+ 3.7 ms in 1 steps since start of marking, biggest step 3.7 ms, walltime since start of marking 3118 ms) (average mu = 0.215, current mu = 0[2747:0x7fdbb8008000] 20755 ms: Mark-Compact 4065.4 (4143.4) -> 4064.6 (4144.6) MB, 2712.8 / 0.0 ms (average mu = 0.112, current mu = 0.001) allocation failure; scavenge might not succeed
<--- JS stacktrace --->
FATAL ERROR: Reached heap limit Allocation failed - JavaScript heap out of memory
How to skip _xlnm._FilterDatabase in defined-names.js?