readCSV function

Future readCSV(String fileName, { String delimiter = ';', int skipHeader = 0, int skipFooter = 0, bool convertToArray2d = false, Encoding encoding = utf8, })

Read a CSV file and return a List where each element is a row of the file fileName : file name baseDir : optional, base directory to the file, if not informed, get current script path. delimiter : optional, string used to separate values, by default is ";" skipHeader : optional, the number of lines to skip at the beginning of the file, default is 0 skipFooter : optional, the number of lines to skip at the end of the file, default is 0 convertToArray2d : optional, try convert the dynamic list to a Array2d list, if don't have success, throw a exception, default is false. The conditions to a success conversion is: all the information read in the csv file has to be parseble to a number. If you have header or footer, use skipHeader or skipFooter parameters to ignore this info from conversion. encoding : optional, the encoding of the file, default is utf8 Return a List

.. 1 "nupyio". https://github.com/numpy/numpy/blob/v1.16.1/numpy/lib/npyio.py#L1536-L2219. Retrieved 2019-07-26. .. 2 "read csv file by dart". https://flutterframework.com/read-csv-file-by-dart/. Retrieved 2019-07-26. .. 3 "how to stream a file line by line in dart". https://stackoverflow.com/questions/20815913/how-to-stream-a-file-line-by-line-in-dart. Retrieved 2019-07-26. .. 4 "Dart file class". https://api.dartlang.org/stable/2.4.0/dart-io/File-class.html. Retrieved 2019-07-26. Examples

var data = await readCSV('stock_data.csv', delimiter: ',', skipHeader: 1, skipFooter: 1);

Implementation

Future<dynamic> readCSV(String fileName,
    {String delimiter = ';',
    int skipHeader = 0,
    int skipFooter = 0,
    bool convertToArray2d = false,
    Encoding encoding = utf8}) async {
  final lines = await readLinesTxt(fileName, encoding: encoding);
  var data = <List>[];

  for (var l = skipHeader; l < lines.length - skipFooter; l++) {
    // Process results.
    List rows = lines[l].split(delimiter); // split by delimiter
    var rows2 = [];
    for (var row in rows) {
      var aux = num.tryParse(row);
      rows2.add(aux ?? row);
    }
    data.add(rows2);
  }

  if (convertToArray2d) {
    var dataArray2d = Array2d.empty();

    for (var row in data) {
      var arrayRow = Array.empty();
      row.forEach((i) => arrayRow.add(i));
      dataArray2d.add(arrayRow);
    }

    return dataArray2d;
  } else {
    return data;
  }
}