@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(); } }
@Override public void exportStream(OutputStream outputStream, Iterator<T> iterator) throws IOException, ClassNotFoundException, IllegalAccessException { if (iterator == null) throw new NullPointerException("List can not be null or empty."); Writer writer = new OutputStreamWriter(outputStream, "UTF-8"); ICsvBeanWriter beanWriter = new CsvBeanWriter(writer, preference); while (iterator.hasNext()) { T entry = iterator.next(); beanWriter.write(entry, fieldNames, processors); } beanWriter.flush(); } }
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); }
@Override public String convert(Object tuple) { incomingTuplesCount++; if (tuple == null) { errorTupleCount++; logger.error(" Null tuple", tuple); return null; } try { StringWriter stringWriter = new StringWriter(); ICsvBeanWriter beanWriter = new CsvBeanWriter(stringWriter, preference); beanWriter.write(tuple, nameMapping, processors); beanWriter.flush(); beanWriter.close(); emittedObjectCount++; return stringWriter.toString(); } catch (SuperCsvException e) { logger.error("Error while converting tuple {} {}", tuple, e.getMessage()); errorTupleCount++; } catch (IOException e) { DTThrowable.rethrow(e); } return null; }
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 public String convert(Object tuple) { incomingTuplesCount++; if (tuple == null) { errorTupleCount++; logger.error(" Null tuple", tuple); return null; } try { StringWriter stringWriter = new StringWriter(); ICsvBeanWriter beanWriter = new CsvBeanWriter(stringWriter, preference); beanWriter.write(tuple, nameMapping, processors); beanWriter.flush(); beanWriter.close(); emittedObjectCount++; return stringWriter.toString(); } catch (SuperCsvException e) { logger.error("Error while converting tuple {} {}", tuple, e.getMessage()); errorTupleCount++; } catch (IOException e) { DTThrowable.rethrow(e); } return null; }
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", "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); } } }
beanWriter.writeHeader(champsChoisis); beanWriter.write(ligneListePrepa, champsChoisis); beanWriter.close();
beanWriter.writeHeader(template.getHeaders().toArray(new String[template.getHeaders().size()])); Iterator<?> it = col.iterator(); while (it.hasNext()) { beanWriter.write(it.next(), fields, processors); beanWriter.write(model, fields, processors);
/** * @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(); }
beanWriter.writeHeader(template.getHeaders().toArray(new String[template.getHeaders().size()])); Iterator<?> it = col.iterator(); while (it.hasNext()) { beanWriter.write(it.next(), fields, processors); beanWriter.write(model, fields, processors);
if(writeHeader) csvWriter.writeHeader(header); csvWriter.write(aStudent, header); csvWriter.close();
csvWriter.writeHeader(header); icbw.close(); fileWriter.close(); icbw.write(aStudent, header);
try { final String[] nameMapping = new String[]{"name", "age"}; writer.writeHeader(nameMapping); for (Person p : people) { writer.write(p, nameMapping); writer.close();
beanWriter.writeHeader(header); event.setText(null); beanWriter.write(event, header, eventProcessors); if (beanWriter != null) { try { beanWriter.close(); } catch (IOException e) {