How can i pass "array.length" to {{#xlsxReplace "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row[6].c[0]"}}
-
How can i pass "array.length" to "{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}"? or pass some variable to {{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}
So, need someone like : "
var rowCnt = 5;
var cellCnt = 3;
{{#xlsxReplace "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row[rowCnt].c[cellCnt ]"}}
"
or pass from data.json array.length to xlsxReplace
-
Try to create your own
myXlsxReplace
helper function, do the computations you need there and call the xlsxReplace at the end.