private static CsvPOJO readWithCsvMapReader(String file) throws Exception { CsvPOJO csvPojo = new CsvPOJO(); Map<String, String> readMap = null; ICsvMapReader mapReader = null; try { mapReader = new CsvMapReader(new FileReader(file), CsvPreference.STANDARD_PREFERENCE); String[] headers = mapReader.getHeader(true); List<CsvRow> rows = new ArrayList<CsvRow>(); while ((readMap = mapReader.read(headers)) != null) { CsvRow row = new CsvRow(); List<String> columns = new ArrayList<String>(); for (String h : headers) { if (!StrUtil.isEmpty(h)) { columns.add(readMap.get(h)); } } row.setCols(columns); rows.add(row); } csvPojo.setHeaders(headers); csvPojo.setRows(rows); } finally { if (mapReader != null) { mapReader.close(); } } return csvPojo; }
private Map<String, String> readWithCsvMapReader(Path mappingFile) throws IOException { Map<String, String> retMap = new HashMap<>(); try (ICsvMapReader mapReader = new CsvMapReader(Files.newBufferedReader(mappingFile, StandardCharsets.UTF_8), CsvPreference.STANDARD_PREFERENCE)) { final String[] header = mapReader.getHeader(true); log.info(" cvsheader length: " + header.length); final CellProcessor[] rowProcessors = new CellProcessor[header.length];
final String[] header = mapReader.getHeader(true); LOGGER.debug(" cvsheader length: " + header.length); final CellProcessor[] rowProcessors = new CellProcessor[header.length];
try (ICsvMapReader mapReader = new CsvMapReader(new InputStreamReader(is), new CsvPreference.Builder('"', ',', "\r\n").build())) { final String[] header = mapReader.getHeader(true);
@Override public List<CSVRepresentation> parse(InputStream inputStream, Class<CSVRepresentation> clazz) { if (inputStream == null || clazz == null) { throw new NullPointerException(); } ICsvMapReader mapReader = null; InputStreamReader inputStreamReader = null; List<CSVRepresentation> CSVRepresentations = new ArrayList<>(); try { inputStreamReader = new InputStreamReader(inputStream, template.getCharsetName()); mapReader = new CsvMapReader(inputStreamReader, template.getPreferences()); String[] headers = mapReader.getHeader(true); if (fileIsNotEmpty(headers)) { CSVRepresentations = parseLines(mapReader, headers); } } catch (IOException e) { LOGGER.error(e.getMessage(), e); } finally { closeQuietly(inputStreamReader); closeQuietly(mapReader); } return CSVRepresentations; }
try { csvMapReader = new CsvMapReader(new FileReader(historicalDataCsvFile.toFile()), CsvPreference.STANDARD_PREFERENCE); final String[] headers = csvMapReader.getHeader(true); final CellProcessor[] rowProcessors = new CellProcessor[headers.length]; Map<String, Object> componentMap;
try{ ICsvMapReader reader = new CsvMapReader(r, CsvPreference.STANDARD_PREFERENCE); final String[] header = reader.getHeader(true); Map<String, Object> headerMap; DynamicSurveyResponse sr = null;
try{ ICsvMapReader reader = new CsvMapReader(r, CsvPreference.STANDARD_PREFERENCE); final String[] header = reader.getHeader(true); Map<String, Object> headerMap; SurveyResponse sr = null;
public List<Map<String, Object>> readCsv(String fileName, List<Field> fieldList, int index, int length) { ICsvMapReader mapReader = null; List<Map<String, Object>> returnList = new ArrayList<>(); try { mapReader = new CsvMapReader(new FileReader(fileName) , new CsvPreference.Builder('"', ',', "\r\n") .ignoreEmptyLines(false) .build()); // the header columns are used as the keys to the Map final String[] header = mapReader.getHeader(true); Map<String, Object> rowMap; while( (rowMap = mapReader.read(header, getProcessors(fieldList))) != null && mapReader.getRowNumber() - 1 < index + length + 1) { if(mapReader.getRowNumber() - 1 > index){ returnList.add(rowMap); } } } catch (FileNotFoundException e){ throw new WorkbenchException(CSV_FILE_NOT_FOUND, "CSV File Not Founded.", e); } catch (IOException e){ throw new WorkbenchException(CSV_FILE_NOT_FOUND, "read CSV IOException.", e); } finally { try { if(mapReader != null) mapReader.close(); } catch (Exception e){} } return returnList; }