react 去除空行 filter
对于handsontable保存数据后,会出现:
[["第<span style="color:#ffd700">n</span>年<span style="color:#abe338">","</span>初次灌装排放率(EF_ini)<span style="color:#abe338">","</span>单位设备初始充填量(m_ini)<span style="color:#abe338">","</span>运行排放率(EF_ope)<span style="color:#abe338">","</span>维修排放率(EF_ser)<span style="color:#abe338">","</span>维修充填率(m_ser)<span style="color:#abe338">","</span>逐年维修率(r)<span style="color:#abe338">","</span>报废排放率(EF_dis)<span style="color:#abe338">","</span>逐年报废率(f)<span style="color:#abe338">"],["</span><span style="color:#f5ab35">1</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">2</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">3</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">4</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">5</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">6</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">7</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">8</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">9</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#f5ab35">10</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">","</span><span style="color:#f5ab35">0</span>.<span style="color:#f5ab35">02</span><span style="color:#abe338">"],["</span><span style="color:#abe338">","</span>null<span style="color:#abe338">","</span>null<span style="color:#abe338">","</span>null<span style="color:#abe338">","</span>null<span style="color:#abe338">","</span>null<span style="color:#abe338">","</span>null<span style="color:#abe338">","</span>null<span style="color:#abe338">","</span>null<span style="color:#abe338">"]]
</span>这样的数据可以使用:(
filter
if (this.tableRefs.refrigerationParamsData) {
const refrigerationDefaultDataRef = this.tableRefs.refrigerationParamsData.hot.getData();
refrigerationParamsData = refrigerationDefaultDataRef
.filter((row) => row.some((cell) => cell !== null && cell !== ""))
.map((row) => row.map((cell) => String(cell)));
}