CsvParser parser = new CsvParserBuilder()
.withSeparator(',')
.withQuoteChar('"')
.withEscapeChar('\\')
.build();
try (CsvReader reader = new CsvReader(new FileReader("data.csv"), parser)) {
CsvRow row;
while ((row = reader.readLine()) != null) {
}
} catch (IOException e) {
e.printStackTrace();
}
CsvTable table = CsvTable.create("data.csv");
List<CsvRow> rows = table.readAll();
CsvRow newRow = table.createRow();
newRow.setCellValue("Name", "John");
newRow.setCellValue("Age", 30);
table.addRow(newRow);
CsvRow rowToUpdate = table.findFirstRow("Name", "John");
if (rowToUpdate != null) {
rowToUpdate.setCellValue("Age", 35);
table.updateRow(rowToUpdate);
}
CsvRow rowToDelete = table.findFirstRow("Name", "John");
if (rowToDelete != null) {
table.deleteRow(rowToDelete);
}
CsvTable table = CsvTable.create("data.csv");
table.createIndex("Name");
List<CsvRow> rows = table.findRows("Name", "John");
