Java CSVRecord類代碼示例

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
@Override
public Iterator<String[]> iterator() throws Exception{
    Iterator<CSVRecord> iterCSVRecords = this.getCSVParser().iterator();
    
    Iterator<String[]> iterStringArrays = Iterators.transform(iterCSVRecords, (CSVRecord input) -> {
        Iterator<String> iterCols = input.iterator();
        
        List<String> cols = new ArrayList();
        while(iterCols.hasNext()){
            cols.add(iterCols.next());
        }
        
        String[] output = cols.toArray(new String[0]);
        
        return output;
    });
    
    return iterStringArrays;
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
@Override
public void write(String outputFilePath) throws Exception{            
   try(Writer out = new BufferedWriter(new FileWriter(outputFilePath));
           CSVPrinter csvPrinter = new CSVPrinter(out, CSVFormat.RFC4180)) {
        
        if(this.getHeaders() != null){
            csvPrinter.printRecord(this.getHeaders());
        }
        
        Iterator<CSVRecord> recordIter = this.getCSVParser().iterator();
        while(recordIter.hasNext()){
            CSVRecord record = recordIter.next();
            csvPrinter.printRecord(record);
        }
        
        csvPrinter.flush();
            
   }catch(Exception e){
        throw e;
   }
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
private ArrayList<Map<String, String>> parse()  {
	final ArrayList<Map<String, String>> list;
	final CSVParser parser;
	final URL resource;
	final CSVFormat csvFormat;
	final Charset charset;
	list = new ArrayList<Map<String, String>> ();
	try {
		resource = ResourceHelper.getResource(isFromGameResourceInput(),fileName);
		charset= FileEncodingDetectorHelper.guessEncodingAndGetCharset(resource);
		csvFormat = CSVFormatHelper.getDefaultCSVFormat();
		parser = CSVParser.parse(resource, charset, csvFormat);
		for (CSVRecord record : parser )
			list.add((Map<String, String>)record.toMap());
	}
	catch (IOException e) {
		log.error("Fail", e);
	}
	return list;
	
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
@Override
public void accept(CSVRecord theRecord) {
    String code = theRecord.get("LOINC_NUM");
    if (isNotBlank(code)) {
        String longCommonName = theRecord.get("LONG_COMMON_NAME");
        String shortName = theRecord.get("SHORTNAME");
        String consumerName = theRecord.get("CONSUMER_NAME");
        String display = firstNonBlank(longCommonName, shortName, consumerName);

        ConceptEntity concept = new ConceptEntity(myCodeSystemVersion, code);
        concept.setDisplay(display);

        Validate.isTrue(!myCode2Concept.containsKey(code));
        myCode2Concept.put(code, concept);
    }
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
private ArrayList<Map<String,String>> parse()  {

		ArrayList<Map<String,String>> list;
		CSVParser parser;
		URL resource;
		CSVFormat csvFormat;
		Charset charset;
		list = new ArrayList<Map<String,String>> ();
		try {
			resource = ResourceHelper.getResource(isFromGameResourceInput(),fileName);
			charset= FileEncodingDetectorHelper.guessEncodingAndGetCharset(resource);
			csvFormat = CSVFormatHelper.getDefaultCSVFormat();
			parser = CSVParser.parse(resource, charset, csvFormat);
			for (CSVRecord record : parser )
				list.add(record.toMap());
		}
		catch (IOException e) {
			log.error("Fail", e);
		}
		return list;
		
	}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
private List <Tag>  createTags(CSVParser parser, Course course) {
	tagMap = new HashMap<>();
	ArrayList<Tag> tagList = new ArrayList<Tag>();
	for (CSVRecord csvRecord : parser) {
		String name = csvRecord.get(TagPoolColumn.TAG.ordinal()).toString();
		if (!tagMap.containsKey(name)){
			Tag tag = new Tag();
    	    tag.setName(name);
    	    tag.setCourse(course);
    
    	    tagMap.put(name, tag);
    	    
    	    tag.setNumber(tagMap.size());
    	    tagList.add(tag);
    	    
		}

	 }
	
	return tagList;
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
public List<Map<String,String>> parse() throws BuenOjoCSVParserException {
	List<Map<String,String>> list = new ArrayList<>();
	CSVParser parser = null;
	try {
		parser = CSVFormat.RFC4180.withHeader()
								.withDelimiter(',')
								.withAllowMissingColumnNames(true)
								.parse(new InputStreamReader(this.inputStreamSource.getInputStream()));
	} catch (IOException e) {
		throw new BuenOjoCSVParserException(e.getMessage());
	}
	
	for (CSVRecord record :parser) {
		Map<String,String> map = record.toMap();
		list.add(map);
	}
	
	return list;
	
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
public List<PhotoLocationSightPair> parse () throws IOException, BuenOjoCSVParserException {
	CSVParser parser =  CSVFormat.RFC4180.withHeader().withDelimiter(',').withAllowMissingColumnNames(true).parse(new InputStreamReader(this.inputStreamSource.getInputStream()));
	
	
	List<CSVRecord> records = parser.getRecords();
	if (records.size() == 0 ) {
		throw new BuenOjoCSVParserException("El archivos de miras no contiene registros");
	}
	ArrayList<PhotoLocationSightPair> sightPairs = new ArrayList<>(records.size());
	for (CSVRecord record : records) {
		
		PhotoLocationSightPair sight = new PhotoLocationSightPair();
		sight.setNumber(new Integer(record.get(PhotoLocationSightPairCSVColumn.id)));
		sight.setSatelliteX(new Integer(record.get(PhotoLocationSightPairCSVColumn.satCol)));
		sight.setSatelliteY(new Integer(record.get(PhotoLocationSightPairCSVColumn.satRow)));
		sight.setSatelliteTolerance(new Integer(record.get(PhotoLocationSightPairCSVColumn.satTolerancia)));
		sight.setTerrainX(new Integer(record.get(PhotoLocationSightPairCSVColumn.terCol)));
		sight.setTerrainY(new Integer(record.get(PhotoLocationSightPairCSVColumn.terRow)));
		sight.setTerrainTolerance(new Integer(record.get(PhotoLocationSightPairCSVColumn.terTolerancia)));
		
		sightPairs.add(sight);
		
	}
	return sightPairs;
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
public List<TagPair> parse() throws IOException {
	
	CSVParser parser = CSVFormat.RFC4180.withHeader().withDelimiter(',').withAllowMissingColumnNames(true).parse(new InputStreamReader(this.inputStreamSource.getInputStream()));
	
	
	ArrayList<TagPair> tagPairs = new ArrayList<>(AVG_ITEMS);
	for (CSVRecord record : parser ){
		
		TagPair pair = new TagPair();
		Integer tagSlotId = new Integer(record.get("id"));
		Integer tagNumber = new Integer(record.get("etiqueta"));
		
		pair.setTagSlotId(tagSlotId);
		Optional<Tag> optionalTag = tagList.stream().filter(isEqualToTagNumber(tagNumber)).findFirst();
		if (optionalTag.isPresent()){
			Tag tag = optionalTag.get(); 
			pair.setTag(tag);
			tagPairs.add(pair);			
		}else {
			log.debug("Attempt to get invalid tag with number: "+tagNumber);
		}
	}
	
	return tagPairs;
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
public List<TagCircle> parse() throws IOException, BuenOjoCSVParserException {

		ArrayList<TagCircle> list = new ArrayList<>(MAX_CIRCLES);

		CSVParser parser = CSVFormat.RFC4180.withHeader().withDelimiter(',').withAllowMissingColumnNames(false).parse(new InputStreamReader(this.inputStream));
		
		for (CSVRecord record : parser ){
			TagCircle circle = new TagCircle();
			circle.setNumber(new Integer(record.get("id")));
			circle.setX(new Integer(record.get("col")));
			circle.setY(new Integer(record.get("row")));
			circle.setRadioPx(new Float(record.get("radioPx")));
			list.add(circle);

		}
		if (list.size()>MAX_CIRCLES){
			throw new BuenOjoCSVParserException("el archivo contiene mas de "+MAX_CIRCLES+ "áreas circulares");
		}
		return list;

	}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
public Integer[] parseLevels() throws BuenOjoCSVParserException, IOException{
	CSVRecord record = getRecords().get(0);
	String levels = record.get(PhotoLocationLandscapeLevelsCSVColumns.levels.ordinal());
	
	//Matcher m = Pattern.compile("(\\d*):(\\d*)").matcher(levels);
	String[] m = levels.split(":");
	if (m==null) {
		throw new BuenOjoCSVParserException("el formato del nivel es incorrecto: "+levels);
	}
	
	Integer[] n = new Integer[PhotoLocationLevelComponents.count.ordinal()];
	int lower = PhotoLocationLevelComponents.lowerLevel.ordinal();
	int higher = PhotoLocationLevelComponents.higherLevel.ordinal();
	n[lower] = new Integer(m[lower]);
	n[higher] = new Integer(m[higher]);

	return n;
	
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
/**
 * Creates a new dataset with column labels and data read from the given Reader, using a specified input format.
 *
 * @param reader       the Reader to read column labels and data from
 * @param input_format the format
 */
@SuppressWarnings("WeakerAccess")
public DataSet(final Reader reader, final CSVFormat input_format) {

    this();

    try (CSVParser parser = new CSVParser(reader, input_format.withHeader())) {

        labels.addAll(getColumnLabels(parser));

        for (final CSVRecord record : parser) {

            final List<String> items = csvRecordToList(record);
            final int size = items.size();

            // Don't add row if the line was empty.
            if (size > 1 || (size == 1 && items.get(0).length() > 0)) {
                records.add(items);
            }
        }

        reader.close();
    } catch (final IOException e) {
        throw new RuntimeException(e);
    }
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
/**
 * This method reads the file from @see {@link ReadFolder} and put into an array list the data we need.
 * We use here the API commons-csv.
 * Attention : tu run with the API you need to import him into the project @see README.
 * @param folderName.
 * @exception IOException | NumberFormatException : print error reading file.
 */
public void read(String folderName) {
	try {
		Reader in = new FileReader(folderName + "/" + file.getName());
		BufferedReader br = new BufferedReader(in);
		String firstLine = br.readLine();
		if (checkTheFile(firstLine)) {
			Iterable<CSVRecord> records = CSVFormat.RFC4180.withFirstRecordAsHeader().parse(br);	
			for (CSVRecord record : records) 
				if (record.get("Type").equals("WIFI") && !record.get("FirstSeen").contains("1970")) 
					inputWifi(record, firstLine);
			in.close();
			br.close();
		}
	}
	catch(IOException | NumberFormatException ex) { // If there is an error.
		System.out.println("Error reading file : " + ex);
		System.exit(0);
	}
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
@Override
public Iterator<Row> iterator() {
    return new Iterator<BulkUserImportReader.Row>() {
        Iterator<CSVRecord> i = csvParser.iterator();

        @Override
        public boolean hasNext() {
            return i.hasNext();
        }

        @Override
        public Row next() {
            CSVRecord record = i.next();
            return new Row(record);
        }

        @Override
        public void remove() {
            i.remove();
        }
    };
}
 

import org.apache.commons.csv.CSVRecord; //導入依賴的package包/類
private void compareCSVFiles(String actualPath, String expectedPath) {
    try (CSVParser parserTranslatedFile = createCsvParser(actualPath, ",")) {
        try (CSVParser parserExpectedFile = createCsvParser(expectedPath, ",")) {
            Iterator<CSVRecord> translatedIterator = parserTranslatedFile.iterator();
            Iterator<CSVRecord> expectedIterator = parserExpectedFile.iterator();
            while (translatedIterator.hasNext() && expectedIterator.hasNext()) {
                CSVRecord translatedRecord = translatedIterator.next();
                CSVRecord expectedRecord = expectedIterator.next();
                compareCSVRecords(translatedRecord, expectedRecord);
            }
            if (translatedIterator.hasNext()) {
                fail("Actual file is longer (has more lines) than expected file");
            }
            if (expectedIterator.hasNext()) {
                fail("Expected file is longer (has more lines) than actual file");
            }
        }
    } catch (Exception e) {
        fail("Exception while iterating over files");
    }
}