react 下载CSV, 处理object、array
对于某个参数可以下载CSV:
const consumption = '{"R41022":[["2010","999"],["2011","777"],["2012","999"],["2013","777"],["2014","999"],["2015","777"],["2016","999"],["2017","777"],["2018","999"],["2019","777"],["2020","999"]],"R888":[["2010","908"],["2011","45"],["2012","908"],["2013","45"],["2014","908"],["2015","45"],["2016","908"],["2017","45"],["2018","908"],["2019","45"],["2020","908"]]}';
const parsedConsumption = JSON.parse(consumption);
// 遍历解析后的对象,并显示数据
for (const key in parsedConsumption) {
const data = parsedConsumption[key];
console.log(`Key: ${key}`);
data.forEach(([year, value]) => {
console.log(`Year: ${year}, Value: ${value}`);
});
}运行后会显示这样的数据:
Key: <span style="color:#abe338">R41022</span>
Year: <span style="color:#f5ab35">2010</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">999</span>
Year: <span style="color:#f5ab35">2011</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">777</span>
Year: <span style="color:#f5ab35">2012</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">999</span>
Year: <span style="color:#f5ab35">2013</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">777</span>
Year: <span style="color:#f5ab35">2014</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">999</span>
Year: <span style="color:#f5ab35">2015</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">777</span>
Year: <span style="color:#f5ab35">2016</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">999</span>
Year: <span style="color:#f5ab35">2017</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">777</span>
Year: <span style="color:#f5ab35">2018</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">999</span>
Year: <span style="color:#f5ab35">2019</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">777</span>
Year: <span style="color:#f5ab35">2020</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">999</span>
Key: <span style="color:#abe338">R888</span>
Year: <span style="color:#f5ab35">2010</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">908</span>
Year: <span style="color:#f5ab35">2011</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">45</span>
Year: <span style="color:#f5ab35">2012</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">908</span>
Year: <span style="color:#f5ab35">2013</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">45</span>
Year: <span style="color:#f5ab35">2014</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">908</span>
Year: <span style="color:#f5ab35">2015</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">45</span>
Year: <span style="color:#f5ab35">2016</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">908</span>
Year: <span style="color:#f5ab35">2017</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">45</span>
Year: <span style="color:#f5ab35">2018</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">908</span>
Year: <span style="color:#f5ab35">2019</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">45</span>
Year: <span style="color:#f5ab35">2020</span><span style="color:#abe338">,</span> Value: <span style="color:#f5ab35">908</span>