csvWriter.write(row);
@Test public void writeHashMapToCsv() throws Exception { Map<String, String> map = new HashMap<>(); map.put("abc", "aabbcc"); map.put("def", "ddeeff"); StringWriter output = new StringWriter(); try (ICsvListWriter listWriter = new CsvListWriter(output, CsvPreference.STANDARD_PREFERENCE)){ for (Map.Entry<String, String> entry : map.entrySet()){ listWriter.write(entry.getKey(), entry.getValue()); } } System.out.println(output); }
csvWriter.write(values);
private void writeBody(List<QueryResult> results, String epoch) throws IOException { List<Object> alignedResults = alignResults(results, epoch); try { csv.write(alignedResults); } finally { csv.flush(); } }
@SuppressWarnings("unchecked") private void writeTableAsCsv(File directory, String filename, Table table, WorkbookFileType workbookFileType) throws IOException{ File file=new File(directory, filename+"."+workbookFileType.getFileExtension()); try(FileOutputStream fos = new FileOutputStream(file); OutputStreamWriter writer = new OutputStreamWriter(fos, getCsvEncoding()); BufferedWriter bw=new BufferedWriter(writer); ICsvListWriter csvWriter=workbookFileType.createCsvListWriter(bw)){ List<String> headers=table.getColumns().stream().map(c->c.getName()).collect(Collectors.toList()); csvWriter.writeHeader(headers.toArray(new String[0])); String[] values=new String[table.getColumns().size()]; for(Row row:table.getRows()){ int i=0; for(Column column:table.getColumns()){ Object value=row.get(column); values[i++]=column.getConverter().convertString(value); } csvWriter.write(values); } } }
@SuppressWarnings("unchecked") private void writeTableAsCsv(File file, Table table, WorkbookFileType workbookFileType) throws IOException{ try(FileOutputStream fos = new FileOutputStream(file); OutputStreamWriter writer = new OutputStreamWriter(fos, getCsvEncoding()); BufferedWriter bw=new BufferedWriter(writer); ICsvListWriter csvWriter=workbookFileType.createCsvListWriter(bw)){ List<String> headers=table.getColumns().stream().map(c->c.getName()).collect(Collectors.toList()); csvWriter.writeHeader(headers.toArray(new String[0])); String[] values=new String[table.getColumns().size()]; for(Row row:table.getRows()){ int i=0; boolean set=false; for(Column column:table.getColumns()){ Object value=row.get(column); String text=column.getConverter().convertString(value); if (!CommonUtils.isEmpty(text)){ values[i++]=text; set=true; } } if (set){ csvWriter.write(values); } } } }