Skip to content

hudeany/vcf

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Java CSV-Reader and CSV-Writer

CsvReader can read .csv files and streams in any characterset encoding (also with BOM) and with configurable separator and optional stringquote (delimiter).

CsvWriter can write .csv files and streams and supports the same features as CsvReader.

General features:

  • Using data streams instead of files only
  • Handles linebreaks within quoted data
  • Handles string quote character within quoted data
  • Configurable separator character
  • Configurable optional string quote character
  • Configurable allows too short csvdata lines (trailing empty columns)
  • Read line by line or all data at once

Format features:

  • Separating character can be configured
  • Character for string quotes can be configured
  • Character to escape the string quote character within quoted strings can be configured. By default this is the stringquote character itself, so it is doubled in quoted strings, but may also be configured to a backslash ''
  • Allow linebreaks in data texts without the effect of a new data set line or use "\n" to escape linebreaks on csv output
  • Allow escaped stringquotes to use them as a character in data text. May be turned off for data consistency checks
  • Allow lines with less than the expected number of data entries per line can be configured
  • Allow lines with more than the expected number of data entries per line, if those are empty
  • Trim all data values
  • Quote data entries: NO_QUOTE, QUOTE_IF_NEEDED, QUOTE_STRINGS, QUOTE_ALL_DATA
  • Linebreak character for output can be configured
  • Ignore empty lines can be configured
  • Use headers in first csv line can be configured

CsvReader example:

	final String csvData =
		"abc;def;123\n"
		+ "ghi;jkl;456";

	final CsvFormat csvFormat = new CsvFormat().setSeparator(';');

	List<List<String>> dataLines;
	try (CsvReader readerForAllAtOnce = new CsvReader(new ByteArrayInputStream(csvData.getBytes("UTF-8")), csvFormat)) {
		dataLines = readerForAllAtOnce.readAll();
	}
	System.out.println(dataLines);

	try (CsvReader readerForLineByLine = new CsvReader(new ByteArrayInputStream(csvData.getBytes("UTF-8")), csvFormat)) {
		final List<String> nextDataLine = readerForLineByLine.readNextCsvLine();
		System.out.println(nextDataLine);
	}

CsvWriter example:

	final CsvFormat csvFormat = new CsvFormat().setSeparator(';').setStringQuote('\"');
	try (CsvWriter writer = new CsvWriter(new FileOutputStream("MyFile.csv"), csvFormat)) {
		writer.writeValues(new Object[] {
			"abc",
			"def",
			"123"
		});
		
		writer.writeValues(new Object[] {
			"ghi",
			"jkl",
			"456"
		});
	}