@Override public List<Object> read(CellProcessor... processors) throws IOException { if( processors == null ) { throw new NullPointerException("Processors should not be null"); } if( readRow() ) { super.executeProcessors(new ArrayList<Object>(getColumns().size()), processors); return new ArrayList<Object>(getColumns()); } return null; // EOF }
@Override public ICsvListReader createCsvListReader(Reader reader){ return new CsvListReader(reader, CsvPreference.EXCEL_PREFERENCE); } }
CsvListReader reader = new CsvListReader(new FileReader(file), CsvPreference.STANDARD_PREFERENCE); final String[] header = reader.getHeader(true); LOGGER.info(" file header: " + Arrays.toString(header)); while ((record = reader.read()) != null) { reader.close();
throw new IllegalArgumentException("Separator: " + separator + " is not currently supported"); try (CsvListReader reader = new CsvListReader(new InputStreamReader(input), csvPreference)) { final List<String> header; final DataFrame<Object> df; final CellProcessor[] procs; if(hasHeader) { header = Arrays.asList(reader.getHeader(true)); procs = new CellProcessor[header.size()]; df = new DataFrame<>(header); } else { reader.read(); header = new ArrayList<String>(); for (int i = 0; i < reader.length(); i++) { header.add("V"+i); df = new DataFrame<>(header); df.append(reader.executeProcessors(procs)); for (List<Object> row = reader.read(procs); row != null; row = reader.read(procs)) { df.append(new ArrayList<>(row));
String[] getColumns(Map<String, String> query) throws IOException, InterruptedException { Objects.requireNonNull(query, "query is null"); Map<String, String> queryMap = new LinkedHashMap<>(); queryMap.put("headers", "true"); queryMap.put("count", "1"); if (query != null) { queryMap.putAll(query); } try (InputStream is = httpClient.getHttpRequest(new HistoDbUrl(config, "itesla/" + HistoQueryType.data + ".csv", queryMap)); CsvListReader reader = new CsvListReader(new InputStreamReader(is), CsvPreference.STANDARD_PREFERENCE)) { return reader.getHeader(true); } }
public static String addTimestampColumnFromCsv(String timeStr, String inputPath, String outputPath) { File inputFile = new File(inputPath); File outputFile = new File(outputPath); CsvListReader reader = null; CsvListWriter writer = null; try { CsvPreference csvPreference = new CsvPreference.Builder('"', ',', "\r\n") .ignoreEmptyLines(false) .build(); reader = new CsvListReader(new FileReader(inputFile), csvPreference); writer = new CsvListWriter(new FileWriter(outputFile), csvPreference); List<String> columns; while ((columns = reader.read()) != null) { columns.add(timeStr); writer.write(columns); } } catch (IOException e) { throw new MetatronException("Fail to transform csv file :" + e.getMessage()); } finally { try { if (reader != null) reader.close(); if (writer != null) writer.close(); } catch (IOException e) {} } return outputFile.getAbsolutePath(); }
public static List<String> parseHintedHandoffEnabledDCs(final String dcNames) throws IOException { final CsvListReader csvListReader = new CsvListReader(new StringReader(dcNames), STANDARD_SURROUNDING_SPACES_NEED_QUOTES); return csvListReader.read(); }
static private boolean checkFormat(BufferedReader reader, CsvPreference format) throws IOException { CsvListReader parser = new CsvListReader(reader, format){ @Override public void close(){ } }; int columns = 0; // Check the header line and the first ten lines for(int line = 0; line < (1 + 10); line++){ List<String> row = parser.read(); if(row == null){ break; } int rowColumns = row.size(); if((rowColumns > 1) && (columns == 0 || columns == rowColumns)){ columns = rowColumns; } else { return false; } } parser.close(); return (columns > 1); }
private List<String> read(CsvListReader reader) throws CsvImportException { try { return reader.read(); } catch (IOException e) { throw new ReadValuesException(this, e); } }
/** * {@inheritDoc} */ public List<Object> read(final CellProcessor... processors) throws IOException { if( processors == null ) { throw new NullPointerException("processors should not be null"); } if( readRow() ) { return executeProcessors(processors); } return null; // EOF }
/** * Close the reader, then close the shadow writer and replace the original * file if necessary. */ @Override public void close() throws IOException { try { if (reader != null) { reader.close(); } } finally { if (writer != null) { // dump the last row to the writer try { writeRow(); writer.flush(); } finally { try { writer.close(); } finally { renameFiles(); } } } } }
@Override public ICsvListReader createCsvListReader(Reader reader){ return new CsvListReader(reader, CsvPreference.TAB_PREFERENCE); } }
CsvListReader reader = new CsvListReader(new FileReader(file), CsvPreference.STANDARD_PREFERENCE); final String[] header = reader.getHeader(true); LOGGER.info(" file header: " + Arrays.toString(header)); while ((record = reader.read()) != null) { SamplerRecord value = new SamplerRecord(record); values.add(value); reader.close();
throw new IllegalArgumentException("Separator: " + separator + " is not currently supported"); try (CsvListReader reader = new CsvListReader(new InputStreamReader(input), csvPreference)) { final List<String> header; final DataFrame<Object> df; final CellProcessor[] procs; if(hasHeader) { header = Arrays.asList(reader.getHeader(true)); procs = new CellProcessor[header.size()]; df = new DataFrame<>(header); } else { reader.read(); header = new ArrayList<String>(); for (int i = 0; i < reader.length(); i++) { header.add("V"+i); df = new DataFrame<>(header); df.append(reader.executeProcessors(procs)); for (List<Object> row = reader.read(procs); row != null; row = reader.read(procs)) { df.append(new ArrayList<>(row));
CsvListReader csvListReader = new CsvListReader(reader, pref); String[] headers = csvListReader.getHeader(true); int offset = 0; for (int i = 0 ; i < headers.length; i++) {
CsvListReader reader = new CsvListReader(new FileReader(inputCsv), CsvPreference.STANDARD_PREFERENCE); CsvListWriter writer = new CsvListWriter(new FileWriter(outputCsv), CsvPreference.STANDARD_PREFERENCE); List<String> columns; while ((columns = reader.read()) != null) { System.out.println("Input: " + columns); // Add new columns columns.add(1, "Column_2"); columns.add("Last_column"); System.out.println("Output: " + columns); writer.write(columns); } reader.close(); writer.close();
private void readRow() { if (writer != null && row != null) { // flush the current row to the writer, before advancing try { writer.write(row); } catch (IOException e) { throw new PaxmlRuntimeException("Cannot write to shadow csv file: " + writerFile.getAbsolutePath(), e); } } try { row = reader.read(); } catch (IOException e) { throw new PaxmlRuntimeException("Cannot read next line from csv file: " + getResourceIdentifier(), e); } }
@Override public ICsvListReader createCsvListReader(Reader reader){ return new CsvListReader(reader, CsvPreference.EXCEL_NORTH_EUROPE_PREFERENCE); } }
reader = new CsvListReader(new InputStreamReader(new BOMInputStream(res.getInputStream()), opt.getEncoding()), pref); } catch (IOException e) { throw new PaxmlRuntimeException("Cannot read csv file: " + PaxmlUtils.getResourceFile(res), e); String[] h; try { h = reader.getHeader(true); } catch (IOException e) { throw new PaxmlRuntimeException("Cannot read csv file header: " + PaxmlUtils.getResourceFile(res), e); reader.getHeader(true); } catch (IOException e) { throw new PaxmlRuntimeException("Cannot read csv file header: " + PaxmlUtils.getResourceFile(res), e);
@Override public List<Object> read(CellProcessor... processors) throws IOException { if( processors == null ) { throw new NullPointerException("Processors should not be null"); } if( readRow() ) { super.executeProcessors(new ArrayList<Object>(getColumns().size()), processors); return new ArrayList<Object>(getColumns()); } return null; // EOF }