@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(); } }
@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(); } }
public void writeWithHeaders(List<?> beans, OutputStream outputStream, Integer delimiterChar, String... headers) throws IOException { try (BufferedWriter csvWriter = new BufferedWriter(new OutputStreamWriter(outputStream))) { CsvPreference csvPreference = CsvPreference.STANDARD_PREFERENCE; if (delimiterChar != null) { csvPreference = new CsvPreference.Builder('"', delimiterChar, "\n").build(); } try (CsvBeanWriter csvBeanWriter = new CsvBeanWriter(csvWriter, csvPreference)) { csvBeanWriter.writeHeader(headers); for (Object bean : beans) { csvBeanWriter.write(bean, headers); } } } }
StringWriter sw = new StringWriter(); try { beanWriter = new CsvBeanWriter(sw, CsvPreference.EXCEL_NORTH_EUROPE_PREFERENCE);
/** * @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(); }
@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; }
@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; }
beanWriter = new CsvBeanWriter(new OutputStreamWriter(outputStream, template.getCharsetName()), template.getPreferences());
beanWriter = new CsvBeanWriter(new OutputStreamWriter(outputStream, template.getCharsetName()), template.getPreferences());
StringWriter resultWriter = new StringWriter(); try { beanWriter = new CsvBeanWriter(resultWriter, CsvPreference.EXCEL_NORTH_EUROPE_PREFERENCE);