The sort method is used to sort all the files in the list by modified date and time, and the file with the latest modified date and time is chosen using the compareTo() method in the portion of the code snippet shown below: listCSV.sort((CSV csv1, CSV csv2) -> csv1.getUpdateDateTime().compareTo(csv2.getUpdateDateTime())); The filename extension is then extracted with Java string manipulation, obtaining the portion of the string after the . of the filename. Part part = request.getPart(fileOpenButton); InputStream fileContent = part.getInputStream(); //Copy file first to Assets folder then do the comparison Path dest = Paths.get(System.getProperty(user.dir) + \\Assets\\ + part.getSubmittedFileName()); FileCopyUtils.copy(part.getInputStream(), Files.newOutputStream(dest)); return (uploadExcel.html); } //Extract the contents of the latest Excel CSV files for display in grid and chart @ResponseBody @CrossOrigin(origins = *) @RequestMapping(value= /readLatestFile, method= RequestMethod.GET) public List
readLatestFile() throws IOException, CsvException {. Running my own software company at mysoftware2u.com, Creating a fullstack Java app with AJAX HTML frontend using jsGrid datagrid and Apex Charts chart component calculating monthly averages from uploaded Excel data files on a Spring Boot REST backend running Apache Tomcat, https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css, https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js, https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js. Create static web app with serverless app - Azure | Microsoft Learn admin-ajax.php returns 0. Then, the js code (for my-script.js file in this example): It is a bad idea IMO to have one request that behave differently depending if the are executed from page A or page B. If you have ever visited a sit-down restaurant, then you can understand the difference between front-end and back-end in web development. Create static web app with serverless app - Azure | Microsoft Learn I teach web development a littttle differently than anyone else. I did it in javascript in the browers to keep it fast & save a round trip. The replace() method is used to replace the opening and closing square brackets found in each row of the CSV file with an empty string. The Java SpringBoot REST service backend runs on Tomcat 8.0 on a separate remote server which runs Windows Enterprise Server 2012. Learn more about Stack Overflow the company, and our products. Your code must help them accomplish that goal. I am trying to pass it to the backend code where I can store the data in my db The first HTML file involves the jsGrid data grid component to show tabular data of the latest Excel or CSV file uploaded into the default server folder (\Assets). Axios Why my admin-ajax url returns 0 even after adding echo and die() at the end of function? Here is the HTML client-side code to upload the Excel or CSV (comma-separated-values) file on the client to the server, , /* Clear floats after image containers */, , , , Upload The File
,