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){} } };
@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.close();
@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; }
/** * @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; }
writer.close();
csvWriter.write(aStudent, header); csvWriter.close();
writeToCSV(sList, csvWriter); icbw.close(); fileWriter.close();
if (beanWriter != null) { try { beanWriter.close(); } catch (IOException e) {