Java CSVPrinter类代码示例

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
public static String exportMetaDataToCSV(List<StandaloneArgument> arguments)
        throws IOException
{
    StringWriter sw = new StringWriter();
    CSVPrinter csvPrinter = new CSVPrinter(sw, CSVFormat.DEFAULT.withHeader(
            "id", "author", "annotatedStance", "timestamp", "debateMetaData.title",
            "debateMetaData.description", "debateMetaData.url"
    ));

    for (StandaloneArgument argument : arguments) {
        csvPrinter.printRecord(
                argument.getId(),
                argument.getAuthor(),
                argument.getAnnotatedStance(),
                argument.getTimestamp(),
                argument.getDebateMetaData().getTitle(),
                argument.getDebateMetaData().getDescription(),
                argument.getDebateMetaData().getUrl()
        );
    }

    sw.flush();

    return sw.toString();
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的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.CSVPrinter; //导入依赖的package包/类
private void logResults() {
	logger.info("Action frequency distribution:\n" + FrequencyUtils.formatFrequency(actionDistribution));
	logger.info("Action frequency distribution of rollback-reverted revisions:\n" + FrequencyUtils.formatFrequency(rollbackRevertedActionDistribution));
	logger.info("Action frequency distribution of non-rollback-reverted revisions:\n" + FrequencyUtils.formatFrequency(nonRollbackRevertedActionDistribution));
	
	try {
		Writer writer = new PrintWriter(path, "UTF-8");
		CSVPrinter csvWriter = CSVFormat.RFC4180.withQuoteMode(QuoteMode.ALL)
				.withHeader("month", "action", "count").print(writer);
		
		for (Entry<String, HashMap<String, Integer>> entry: getSortedList(monthlyActionDistribution)) {
			String month = entry.getKey();
			
			for (Entry<String, Integer> entry2: getSortedList2(entry.getValue())) {
				String action = entry2.getKey();
				Integer value = entry2.getValue();

				csvWriter.printRecord(month, action, value);
			}
		}
		csvWriter.close();
	} catch (IOException e) {
		logger.error("", e);
	}
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
@Override
public void toCSVLine(CSVPrinter rec, Object obj) throws IOException {
	if(this.taxent == null) {
		rec.print("");
		return;
	}
	Map<String,InferredStatus> tStatus = this.inferNativeStatus();
	@SuppressWarnings("unchecked")
	List<String> allTerritories=(List<String>) obj;
	rec.print(this.taxent.getCurrent() ? "yes" : "no");
	rec.print(this.taxent.getID());
	rec.print((this.isLeaf ==null ? "" : (this.isLeaf ? "" : "+")) + this.taxent.getNameWithAnnotationOnly(false));
	rec.print(this.taxent.getAuthor());
	if(this.territories==null) return;

	for(String t : allTerritories) {
		if(tStatus.containsKey(t))
			rec.print(tStatus.get(t).getStatusSummary());
		else
			rec.print("");
	}
	rec.print(this.taxent.getComment());
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
/**
 * Create csv files for a VertexType
 * @param type a vertex type
 * @param outputDirectory the output folder to write the csv file
 */
void writeVertexCSV(VertexTypeBean type, String outputDirectory ){
    String csvFile = outputDirectory + "/" + type.name + ".csv";
    ArrayList<String> header = new ArrayList<String>();
    header.add("node_id");
    header.addAll(type.columns.keySet());
    int botId = idFactory.getMinId(type.name);
    int topId = idFactory.getMaxId(type.name);
    try {
        CSVPrinter csvFilePrinter = new CSVPrinter(new FileWriter(csvFile), csvFileFormat);
        csvFilePrinter.printRecord(header);
        for (int i = botId; i<=topId; i++){
            ArrayList<Object> record = new ArrayList<Object>();
            record.add(i);
            record.addAll(generateOneRecord(type.columns));
            csvFilePrinter.printRecord(record);
        }
        csvFilePrinter.close();
        System.out.println("Generated vertex file: "+ csvFile);
    } catch (Exception e) {
        throw new RuntimeException(e.toString());
    }
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
void writeVertexCSV(VertexTypeBean type, String outputDirectory ){
    String csvFile = outputDirectory + "/" + type.name + ".csv";
    ArrayList<String> header = new ArrayList<String>();
    header.add("node_id");
    header.addAll(type.columns.keySet());
    int botId = idFactory.getMinId(type.name);
    int topId = idFactory.getMaxId(type.name);
    try {
        CSVPrinter csvFilePrinter = new CSVPrinter(new FileWriter(csvFile), csvFileFormat);
        csvFilePrinter.printRecord(header);
        for (int i = botId; i<=topId; i++){
            ArrayList<Object> record = new ArrayList<Object>();
            record.add(i);
            record.addAll(generateOneRecord(type.columns));
            csvFilePrinter.printRecord(record);
        }
        csvFilePrinter.close();
        System.out.println("Generated vertex file: "+ csvFile);
    } catch (Exception e) {
        throw new RuntimeException(e.toString());
    }
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
@Override
public void run() {
	log.info("Start exporting labels");
	List<Label> labels = repo.findAllByOrderByName();
	File outputFile = exportDirPath.resolve("labels.csv").toFile();
	CSVFormat csvFormat = CSVFormat.DEFAULT.withHeader("name", "imageUrl").withRecordSeparator('\n');
	try (FileWriter writer = new FileWriter(outputFile);
		 CSVPrinter csvPrinter = new CSVPrinter(writer, csvFormat)
	) {
		for (Label label : labels) {
			csvPrinter.printRecord(label.getName(), label.getImageUrl());
		}
		log.info("Finished exporting {} labels to file {}", labels.size(), outputFile);
	} catch (IOException e) {
		log.error("Failed to export labels to file {} due to error: {}", outputFile.getAbsolutePath(), e.getMessage());
	}

}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
@Override
public void run() {
	log.info("Start exporting allergens");
	List<Allergen> allergens = repo.findAllByOrderByNumberAsc();
	File outputFile = exportDirPath.resolve("allergens.csv").toFile();
	CSVFormat csvFormat = CSVFormat.DEFAULT.withHeader("number", "name").withRecordSeparator('\n');
	try (FileWriter writer = new FileWriter(outputFile);
		 CSVPrinter csvPrinter = new CSVPrinter(writer, csvFormat)
	) {
		for (Allergen allergen : allergens) {
			csvPrinter.printRecord(allergen.getNumber(), allergen.getName());
		}
		log.info("Finished exporting {} allergens to file {}", allergens.size(), outputFile);
	} catch (IOException e) {
		log.error("Failed to export allergens to file {} due to error: {}", outputFile.getAbsolutePath(), e.getMessage());
	}

}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
@Override
public void run() {
	log.info("Start exporting mensas");
	List<Mensa> mensas = repo.findAllByOrderByName();
	File outputFile = exportDirPath.resolve("mensas.csv").toFile();
	CSVFormat csvFormat = CSVFormat.DEFAULT.withHeader("id", "mainUrl", "name", "nextWeekUrl", "thisWeekUrl", "todayUrl", "tomorrowUrl", "longitude", "latitude", "address", "zipcode", "city").withRecordSeparator('\n');
	try (FileWriter writer = new FileWriter(outputFile);
		 CSVPrinter csvPrinter = new CSVPrinter(writer, csvFormat)
	) {
		for (Mensa mensa : mensas) {
			String longitude = mensa.getPoint() == null ? StringUtils.EMPTY : Double.toString(mensa.getPoint().getX());
			String latitude = mensa.getPoint() == null ? StringUtils.EMPTY : Double.toString(mensa.getPoint().getY());
			csvPrinter.printRecord(mensa.getId(), mensa.getMainUrl(), mensa.getName(), mensa.getNextWeekUrl(), mensa.getThisWeekUrl(), mensa.getTodayUrl(), mensa.getTomorrowUrl(), longitude, latitude, mensa.getAddress(), mensa.getZipcode(), mensa.getCity());
		}
		log.info("Finished exporting {} mensas to file {}", mensas.size(), outputFile);
	} catch (IOException e) {
		log.error("Failed to export mensas to file {} due to error: {}", outputFile.getAbsolutePath(), e.getMessage());
	}

}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
public void convertScenarios(File file, List<Scenario> scenarios) {
    if (scenarios != null && !scenarios.isEmpty()) {
        try (FileWriter out = new FileWriter(file);
                CSVPrinter printer = new CSVPrinter(out, CSVFormat.EXCEL.withIgnoreEmptyLines());) {
            printer.printRecord(HEADERS);
            for (Scenario scenario : scenarios) {
                for (TestCase testCase : scenario.getTestCases()) {
                    convertTestCase(testCase, printer);
                    printer.println();
                }
                printer.println();
            }
        } catch (Exception ex) {
            Logger.getLogger(StepMap.class.getName()).log(Level.SEVERE, "Error while converting", ex);
        }
    }
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
public static void saveChanges(GlobalDataModel globalData) {
    createIfNotExists(globalData.getLocation());
    try (FileWriter out = new FileWriter(new File(globalData.getLocation()));
            CSVPrinter printer = new CSVPrinter(out, CSVFormat.EXCEL.withIgnoreEmptyLines());) {
        for (String header : globalData.getColumns()) {
            printer.print(header);
        }
        printer.println();
        globalData.removeEmptyRecords();
        for (List<String> record : globalData.getRecords()) {
            for (String value : record) {
                printer.print(value);
            }
            printer.println();
        }
    } catch (Exception ex) {
        Logger.getLogger(CSVUtils.class.getName()).log(Level.SEVERE, "Error while saving", ex);
    }
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
public void save() {
    if (!isSaved()) {
        createIfNotExists();
        try (FileWriter out = new FileWriter(new File(getLocation())); CSVPrinter printer = new CSVPrinter(out, CSVFormat.EXCEL.withIgnoreEmptyLines());) {
            printer.printRecord(HEADERS.getValues());
            removeEmptySteps();
            autoNumber();
            for (TestStep testStep : testSteps) {
                printer.printRecord(testStep.stepDetails);
            }
            setSaved(true);
        } catch (Exception ex) {
            Logger.getLogger(TestCase.class.getName()).log(Level.SEVERE, "Error while saving", ex);
        }
    }
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
public void save() {
    if (!isSaved()) {
        createIfNotExists();
        try (FileWriter out = new FileWriter(new File(getLocation())); CSVPrinter printer = new CSVPrinter(out, CSVFormat.EXCEL.withIgnoreEmptyLines());) {
            printer.printRecord(HEADERS.getValues());
            removeEmptySteps();
            for (ExecutionStep testStep : testSteps) {
                printer.printRecord(testStep.exeStepDetails);
            }
            setSaved(true);
        } catch (Exception ex) {
            Logger.getLogger(TestSet.class.getName()).log(Level.SEVERE, "Error while saving", ex);
        }
    }
    execSettings.save();
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
public static List processRecordY(CSVPrinter printer, GenericRecord record, List<Column> columns)
		throws IOException {
	List r = new ArrayList<>();
	columns.forEach(c -> {
		try {
			r.add(record.get(c.getField().name()));
		} catch (Exception e) {

			try {
				r.add(c.getDefaultValue());
			} catch (Exception e2) {
				r.add("NULL");
			}
		}
	});

	printer.printRecord(r);
	printer.flush();
	return r;
}
 

import org.apache.commons.csv.CSVPrinter; //导入依赖的package包/类
/**
 * this method is used to append pending transactions to the csv file
 * @param trans
 */
public void appendCSV(UserStockTransaction trans){
	try{
		
		filePath = servletContext.getRealPath("WEB-INF/csv/pending.csv");
		File f = new File(filePath);
		//System.out.println(trans.getStock().getSymbol() + " " + trans.getUser().getUsername() + " " + trans.getPrice());
		
		FileWriter fw = new FileWriter(f, true);			
		CSVPrinter cp = new CSVPrinter(fw, CSVFormat.DEFAULT);
		System.out.println("Appending a transaction");
		System.out.println(trans.toString());
		cp.printRecord((Object[]) trans.toString().split(","));
		fw.flush();
		fw.close();
		cp.close();
	}catch (Exception e){
		e.printStackTrace();
	}
}