ICsvBeanWriter beanWriter = new CsvBeanWriter(new FileWriter(csvFileName), CsvPreference.STANDARD_PREFERENCE); String[] header = {"isbn", "title", "author", "publisher", "published", "price"}; beanWriter.writeHeader(header); for (Book aBook : listBooks) { beanWriter.write(aBook, header, processors); }
public static void export2CSV(HttpServletResponse response, String[] header, String filePrefix, List<? extends Object> dataObjs) { ICsvBeanWriter writer; try{ response.setContentType("text/csv;charset=utf-8"); response.setHeader("Content-Disposition", "attachment; filename="+filePrefix+"_Data.csv"); OutputStreamWriter outputwriter = new OutputStreamWriter(response.getOutputStream()); writer = new CsvBeanWriter(outputwriter, CsvPreference.EXCEL_PREFERENCE); // the actual writing writer.writeHeader(header); for(Object anObj : dataObjs){ writer.write(anObj, header); } } catch (Exception e) { e.printStackTrace(); } finally { try { writer.close(); // closes writer and underlying stream } catch (Exception e){} } };
private static void writePartial() throws IOException { Person person1 = new Person("John", "K", "Smith"); Person person2 = new Person("Sally", "T", "Brown"); CsvPreference csvPrefs = new CsvPreference.Builder('"', ';', "\n").build(); String[] nameMapping = new String[] { "firstName", null, "lastName" }; try (ICsvBeanWriter writer = new CsvBeanWriter(new FileWriter("output.csv"), csvPrefs)) { writer.writeHeader("firstName", "middleName", "lastName"); for( Person p : Arrays.asList(person1, person2) ) { writer.write(p, nameMapping); } } }
@Override protected void buildCsvDocument(Map<String, Object> model, HttpServletRequest request, HttpServletResponse response) throws Exception { response.setHeader("Content-Disposition", "attachment; filename=\"my-csv-file.csv\""); List<User> users = (List<User>) model.get("users"); String[] header = {"FirstName", "LastName", "LastName", "JobTitle", "Company", "Address", "City", "Country", "PhoneNumber"}; ICsvBeanWriter csvWriter = new CsvBeanWriter(response.getWriter(), CsvPreference.STANDARD_PREFERENCE); csvWriter.writeHeader(header); for (User user : users) { csvWriter.write(user, header); } csvWriter.close(); } }
beanWriter.writeHeader(champsChoisis);
/** * @param header * the header elements are used to map the bean values to each column (names must match!) */ private String createCsv(List<TimeSumsHolder> dataToWrite, String[] header, CellProcessor[] processors) { ICsvBeanWriter beanWriter = null; StringWriter resultWriter = new StringWriter(); try { beanWriter = new CsvBeanWriter(resultWriter, CsvPreference.EXCEL_NORTH_EUROPE_PREFERENCE); beanWriter.writeHeader(header); for (TimeSumsHolder timeSumsHolder : dataToWrite) { beanWriter.write(timeSumsHolder, header, processors); } } catch (IOException e) { Logger.error("error while writing: {0}", e.getMessage()); } finally { if (beanWriter != null) { try { beanWriter.close(); } catch (IOException e) { // do nothing } } } return resultWriter.toString(); }
private static void writePartial() throws IOException { Person person1 = new Person("John", "K", "Smith"); Person person2 = new Person("Sally", "T", "Brown"); CsvPreference csvPrefs = new CsvPreference.Builder('"', ';', "\n").build(); String[] nameMapping = new String[] { "firstName", "middleName", "lastName" }; CellProcessor[] processors = new CellProcessor[] { new Optional(), new Ignore(), new Optional() }; try (ICsvBeanWriter writer = new CsvBeanWriter(new FileWriter("output.csv"), csvPrefs)) { writer.writeHeader(nameMapping); for( Person p : Arrays.asList(person1, person2) ) { writer.write(p, nameMapping, processors); } } }
try { final String[] nameMapping = new String[]{"name", "age"}; writer.writeHeader(nameMapping); for (Person p : people) { writer.write(p, nameMapping);
if(writeHeader) csvWriter.writeHeader(header);
csvWriter.writeHeader(header);
beanWriter.writeHeader(template.getHeaders().toArray(new String[template.getHeaders().size()]));
beanWriter.writeHeader(template.getHeaders().toArray(new String[template.getHeaders().size()]));
beanWriter.writeHeader(header);