@Override protected String assemble(List<PolicyStats> results) { StringWriter output = new StringWriter(); CsvWriter writer = new CsvWriter(output, new CsvWriterSettings()); writer.writeHeaders(headers()); for (PolicyStats policyStats : results) { Object[] data = new Object[] { policyStats.name(), String.format("%.2f", 100 * policyStats.hitRate()), policyStats.hitCount(), policyStats.missCount(), policyStats.requestCount(), policyStats.evictionCount(), String.format("%.2f", 100 * policyStats.admissionRate()), (policyStats.operationCount() == 0) ? null : policyStats.operationCount(), policyStats.stopwatch().elapsed(TimeUnit.MILLISECONDS) }; writer.writeRow(data); } writer.close(); return output.toString(); } }
public String tableToCsv(String url) throws IOException { Document doc = Jsoup.connect(url).get(); Elements tables = doc.select("table"); if (tables.size() != 1) { throw new IllegalStateException( "Reading html to table currently works if there is exactly 1 html table on the page. " + " The URL you passed has " + tables.size() + ". You may file a feature request with the URL if you'd like your pagae to be supported"); } Element table = tables.get(0); CsvWriterSettings settings = new CsvWriterSettings(); StringWriter stringWriter = new StringWriter(); CsvWriter csvWriter = new CsvWriter(stringWriter, settings); for (Element row : table.select("tr")) { Elements headerCells = row.getElementsByTag("th"); Elements cells = row.getElementsByTag("td"); String[] nextLine = Stream.concat(headerCells.stream(), cells.stream()) .map(Element::text).toArray(String[]::new); csvWriter.writeRow(nextLine); } return stringWriter.toString(); } }
public static <T> void writeBeans(String filePath, CsvWriterSettings csvWriterSettings, Iterable<T> records, Class<T> cls) throws FileNotFoundException{ BufferedOutputStream bos = new BufferedOutputStream(new FileOutputStream(filePath)); csvWriterSettings.setRowWriterProcessor(new BeanWriterProcessor<T>(cls)); CsvWriter csvWriter = new CsvWriter(bos, csvWriterSettings); csvWriter.writeHeaders(); csvWriter.processRecords(records); csvWriter.close(); }
/** * {@inheritDoc} */ @Override public void open(final Writer writer) { final CsvWriterSettings csvWriterSettings = new CsvWriterSettings(); csvWriterSettings.setQuoteAllFields(true); csvWriter = new CsvWriter(writer, csvWriterSettings); if (headers == null) { headers = HEADERS; } //We need the null reference check since the config may be null when called from JUnit tests //if (config.getProperties() != null) { // String hashName = config.getProperties().getProperty("profile.hashAlgorithm").toString().toUpperCase(); // headers[HASH_ARRAY_INDEX] = String.format(headers[HASH_ARRAY_INDEX], hashName); //} csvWriter.writeHeaders(headers); }
CsvWriterSettings settings = new CsvWriterSettings(); //many options here. Check the documentation settings.getFormat().setDelimiter('|'); CsvWriter writer = new CsvWriter(new FileWriter(new File("path/to/output.csv")), settings); writer.writeHeaders("Header A", "Header B"); //write rows individually writer.writeRow("string 1", "string 2"); writer.writeRow(234, new BigDecimal(111)); //or write a list of rows in bulk List<Object[]> yourRows = yourMethodToBuildRowsWithData(); writer.writeRowsAndClose(yourRows);
/** * {@inheritDoc} */ @Override protected CsvWriter createWriter(Writer writer, CsvWriterSettings settings) { return new CsvWriter(writer, settings); }
/** * Closes the CSV writer. */ @Override public void close() { csvWriter.close(); }
@Override protected CsvWriter createWriter(Writer output, CsvWriterSettings writerSettings) { return new CsvWriter(output, writerSettings); }
public void write() { com.univocity.parsers.csv.CsvWriter csvWriter = null; // Creates a writer with the above settings; try { csvWriter = new com.univocity.parsers.csv.CsvWriter(writer, settings); if (header) { String[] header = new String[table.columnCount()]; for (int c = 0; c < table.columnCount(); c++) { header[c] = table.column(c).name(); } csvWriter.writeHeaders(header); } for (int r = 0; r < table.rowCount(); r++) { String[] entries = new String[table.columnCount()]; for (int c = 0; c < table.columnCount(); c++) { table.get(r, c); entries[c] = table.getUnformatted(r, c); } csvWriter.writeRow(entries); } } finally { if (csvWriter != null) { csvWriter.flush(); csvWriter.close(); } } }
public void writeToStream(DataFrame df, Writer out) throws IOException { String[] columnNames = df.getSchema().getColumnNames().toArray(new String[0]); final CsvWriterSettings settings = new CsvWriterSettings(); settings.setFormat(format); CsvWriter writer = new CsvWriter(out, settings); writer.writeHeaders(columnNames); List<Row> rows = df.getRows(); for (Row curRow : rows) { List<Object> rowValues = curRow.getVals(); writer.writeRow(rowValues); } writer.close(); } }
public void write() { com.univocity.parsers.csv.CsvWriter csvWriter = null; // Creates a writer with the above settings; try { csvWriter = new com.univocity.parsers.csv.CsvWriter(writer, settings); if (header) { String[] header = new String[table.columnCount()]; for (int c = 0; c < table.columnCount(); c++) { header[c] = table.column(c).name(); } csvWriter.writeHeaders(header); } for (int r = 0; r < table.rowCount(); r++) { String[] entries = new String[table.columnCount()]; for (int c = 0; c < table.columnCount(); c++) { table.get(r, c); entries[c] = table.getUnformatted(r, c); } csvWriter.writeRow(entries); } } finally { if (csvWriter != null) { csvWriter.flush(); csvWriter.close(); } } }
@Override protected String assemble(List<PolicyStats> results) { StringWriter output = new StringWriter(); CsvWriter writer = new CsvWriter(output, new CsvWriterSettings()); writer.writeHeaders(headers()); for (PolicyStats policyStats : results) { Object[] data = new Object[] { policyStats.name(), String.format("%.2f", 100 * policyStats.hitRate()), policyStats.hitCount(), policyStats.missCount(), policyStats.requestCount(), policyStats.evictionCount(), String.format("%.2f", 100 * policyStats.admissionRate()), (policyStats.operationCount() == 0) ? null : policyStats.operationCount(), policyStats.stopwatch().elapsed(TimeUnit.MILLISECONDS) }; writer.writeRow(data); } writer.close(); return output.toString(); } }
output = new FileOutputStream(this.fileName); CsvWriter writer = new CsvWriter(output, settings); writer.writeHeaders(data); IRowIterator rowIter = table.getMembershipSet().getIterator(); int nextRow = rowIter.getNextRow(); data[index] = d; writer.writeRow(data); nextRow = rowIter.getNextRow(); writer.close(); output.close(); if (fs != null)