英文:
Download modified excel file in react
问题
我正在开发REACT JavaScript和Java应用程序。
在一个React页面上，单击按钮（React按钮），它应该处理数据，追加到Excel（Java中），然后下载到本地计算机上。
在React中，我尝试过：
<Linkto="/files/DataList.xlsx"target="_blank"downloadclassName="limited-anchor text-muted small">Download Template</Link>
但在这里，我需要提供下载数据的路径（我不能硬编码路径以满足我的要求）。
从Java方面看：
JSONArray jsArray = new JSONArray(productData);File file = new File("C:\\Users\\ME\\Downloads\\OutputData.csv");String csv = CDL.toString(jsArray);FileUtils.writeStringToFile(file, csv);
这只是将数据存储在指定位置。
预期流程：单击React页面上的下载按钮，它应该自动创建文件并下载到Downloads文件夹中（Windows/MAC）。
是否有办法处理整个流程？
英文:
I am working on REACT JavaScript and Java application.
On a react page, onclick of a button (react), it should manipulate data, append in Excel (Java), and then download it on the local machine.
In React I tried:
<Linkto="/files/DataList.xlsx"target="_blank"downloadclassName="limited-anchor text-muted small">Download Template</Link>
But here I need to give a path to download the data. (I can't not hardcode the path with my requirement)
From Java side:
JSONArray jsArray = new JSONArray(productData);File file=new File("C:\\Users\\ME\\Downloads\\OutputData.csv");String csv = CDL.toString(jsArray);FileUtils.writeStringToFile(file, csv);
This just stores the data in the location.
Expected flow: Onclick of Download button on react page, it should create file and download automatically in Downloads (Windows/MAC).
Is there any way to handle this entire flow?
答案1
得分: 0
这是使用以下方法成功的：
download(){var re = this.state.ReportData; // 从Java API获取的带有标题和行数据的ArrayListvar csvStrings = re.join("%0A");var a = document.createElement("a");a.href = "data:attachment/csv," + csvStrings;a.target = "_Blank";a.download = "Report.csv";document.body.appendChild(a);a.click();}
英文:
It worked with following approach:
download(){var re = this.state.ReportData; // Arraylist fetched from java API with headers and row datavar csvStrings = re.join("%0A");var a = document.createElement("a");a.href = "data:attachment/csv," + csvStrings;a.target = "_Blank";a.download = "Report.csv";document.body.appendChild(a);a.click();}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论