Dart

Update CSV File

See more CSV Examples

Demonstrates how to read a CSV, update some cells, and save.

The Chilkat CSV library/component/class is freeware. The downloads for .NET, C++, Perl, Java, Ruby, and Python contain all of the Chilkat classes, some of which are freeware and some of which require licensing.

Dart

import 'package:chilkat/chilkat.dart';

void main() {
  // This example program loads a file (sample.csv)
  // that contains this content:
  // 
  // year,color,country,food
  // 2001,red,France,cheese
  // 2005,blue,"United States",hamburger
  // 2008,green,Italy,pasta
  // 1998,orange,Japan,sushi
  // 
  // The first row contains the column names.
  // This file is available at:
  // http://www.chilkatsoft.com/testData/sample.csv

  final csv = CkCsv();

  // Prior to loading the CSV file, indicate that the 1st row
  // should be treated as column names:
  csv.hasColumnNames = true;

  // Load the CSV records from the file:

  try {
    csv.loadFile('sample.csv');
  } on ChilkatException catch (e) {
    print(e.lastErrorText);
    return;
  }

  // Change "cheese" to "baguette"
  // ("cheese" is at row=0, column=3
  csv.setCell(0, 3, 'baguette');

  // Change "blue" to "magenta"
  csv.setCell(1, 1, 'magenta');

  // Write the updated CSV to a string and display:
  final csvDoc = csv.saveToString();
  print(csvDoc);

  // Save the CSV to a file:
  try {
    csv.saveFile('out.csv');
  } on ChilkatException catch (e) {
    print(e.lastErrorText);
  }
}