read csv in java in spring
//head auto detection
Reader in = new FileReader("path/to/file.csv");
Iterable<CSVRecord> records = CSVFormat.RFC4180.withFirstRecordAsHeader().parse(in);
for (CSVRecord record : records) {
String id = record.get("ID");
String customerNo = record.get("CustomerNo");
String name = record.get("Name");
}
//add dependemcy too
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-csv</artifactId>
<version>1.8</version>
</dependency>download csv file spring boot
package net.codejava;
import java.io.IOException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.supercsv.io.CsvBeanWriter;
import org.supercsv.io.ICsvBeanWriter;
import org.supercsv.prefs.CsvPreference;
@Controller
public class UserController {
@Autowired
private UserServices service;
@GetMapping("/users/export")
public void exportToCSV(HttpServletResponse response) throws IOException {
response.setContentType("text/csv");
DateFormat dateFormatter = new SimpleDateFormat("yyyy-MM-dd_HH-mm-ss");
String currentDateTime = dateFormatter.format(new Date());
String headerKey = "Content-Disposition";
String headerValue = "attachment; filename=users_" + currentDateTime + ".csv";
response.setHeader(headerKey, headerValue);
/*This is where you receive the data which you wanna export to csv*/
List<User> listUsers = service.listAll();
ICsvBeanWriter csvWriter = new CsvBeanWriter(response.getWriter(), CsvPreference.STANDARD_PREFERENCE);
String[] csvHeader = {"User ID", "E-mail", "Full Name", "Roles", "Enabled"};
String[] nameMapping = {"id", "email", "fullName", "roles", "enabled"};
csvWriter.writeHeader(csvHeader);
for (User user : listUsers) {
csvWriter.write(user, nameMapping);
}
csvWriter.close();
}
}Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
