@Override public ICsvListReader createCsvListReader(Reader reader){ return new CsvListReader(reader, CsvPreference.EXCEL_PREFERENCE); } }
@Override public ICsvListReader createCsvListReader(Reader reader){ return new CsvListReader(reader, CsvPreference.TAB_PREFERENCE); } }
@Override public ICsvListReader createCsvListReader(Reader reader){ return new CsvListReader(reader, CsvPreference.EXCEL_NORTH_EUROPE_PREFERENCE); } }
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(); }
/** * Return an iterator over this source. * * @return a source iterator */ public Iterator iterator() { CsvPreference preferences = new CsvPreference.Builder(m_quoteChar, m_delimiterChar, m_endOfLineSymbols).build(); return new CsvIterator(new CsvListReader(m_reader, preferences), m_header); }
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); } }
@Override public void setup(OperatorContext context) { super.setup(context); parseMapping(); lineListReader = new CsvListReader(lineSr,CsvPreference.STANDARD_PREFERENCE); }
@Override public void setup(OperatorContext context) { super.setup(context); parseMapping(); lineListReader = new CsvListReader(lineSr,CsvPreference.STANDARD_PREFERENCE); }
@Override public void setup(OperatorContext context) { super.setup(context); parseMapping(); lineListReader = new CsvListReader(lineSr, CsvPreference.STANDARD_PREFERENCE); }
@Override public void setup(OperatorContext context) { super.setup(context); parseMapping(); lineListReader = new CsvListReader(lineSr, CsvPreference.STANDARD_PREFERENCE); }
try { sr = new StringReader(mappingString); listReader = new CsvListReader(sr,CsvPreference.STANDARD_PREFERENCE); csvList = (ArrayList<String>) listReader.read(); } catch (IOException e) {
public FetchTableRowItem(String path, String tableName) { super(true); try { this.tableName = tableName; this.table = new Table(); this.table.setName(tableName); listReader = new CsvListReader( new FileReader(path + tableName + ".csv"), CsvPreference.EXCEL_NORTH_EUROPE_PREFERENCE ); List<String> list = listReader.read(); for (String columnName : list) { table.getColumns().add(new Column(columnName)); } } catch (FileNotFoundException ex) { Logger.getLogger(FetchTableRowItem.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(FetchTableRowItem.class.getName()).log(Level.SEVERE, null, ex); } }
try { sr=new StringReader(mapping); listReader = new CsvListReader(sr,CsvPreference.STANDARD_PREFERENCE); csvList = (ArrayList<String>) listReader.read(); } catch (IOException e) {
try { sr = new StringReader(mapping); listReader = new CsvListReader(sr,CsvPreference.STANDARD_PREFERENCE); csvList = (ArrayList<String>)listReader.read(); } catch (IOException e) {
try { sr = new StringReader(mappingString); listReader = new CsvListReader(sr,CsvPreference.STANDARD_PREFERENCE); csvList = (ArrayList<String>)listReader.read(); } catch (IOException e) {
CsvListReader csvListReader = new CsvListReader(reader, pref); String[] headers = csvListReader.getHeader(true); int offset = 0;
@Override public List<SalaryYear> read(InputStream is) throws Exception { List<SalaryYear> elements = new ArrayList<SalaryYear>(); ICsvListReader reader = new CsvListReader(new InputStreamReader(is), CsvPreference.EXCEL_PREFERENCE); try { reader.getHeader(true); List<String> element; while ((element = reader.read()) != null) { String[] tokens = element.toArray(new String[element.size()]); SalaryYear salaryYear = new SalaryYear(); salaryYear.setEmail(tokens[0]); salaryYear.setYear(2013); List<SalaryMonth> months = new ArrayList<SalaryMonth>(12); for (int i = 1; i < 13; i++) { months.add(buildSalaryMonth(i, tokens[i])); } salaryYear.setMonths(months); elements.add(salaryYear); } } finally { reader.close(); } return elements; }
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(); }
private static void format(InputStream is, boolean zipped, PrintStream out) throws IOException { Table table; CsvPreference prefs = new CsvPreference.Builder('"', ',', "\r\n").build(); try (ICsvListReader reader = new CsvListReader(createReader(is, zipped), prefs)) { String[] header = reader.getHeader(true); table = new Table(header.length, BorderStyle.CLASSIC_WIDE); for (String cell : header) { table.addCell(cell); } List<String> row; while ((row = reader.read()) != null) { for (int i = 0; i < row.size(); i++) { String cell = row.get(i); if (header[i].equals(HistoDbMetaAttributeId.datetime.toString())) { DateTime datetime = new DateTime(Long.parseLong(cell) * 1000L); table.addCell(datetime.toString()); } else { table.addCell(cell); } } } } out.println(table.render()); }
private CsvListReader createReader() throws CsvImportException { char quote = properties.getQuote(); int separator = properties.getSeparator(); String end = properties.getEndOfLineSymbols(); return new CsvListReader(openFile(), new CsvPreference.Builder(quote, separator, end).build()); }