toCsv static method

Implementation

static Future<String> toCsv(Data data) async
{
    final buffer = StringBuffer();
    String string = "";

    int i = 0;
    try
    {
      // Build Header
      List<String> header = [];
      List<String> columns = [];
      if (data.isNotEmpty){
      if (data.first is Map) {
        (data.first as Map).forEach((key, value)
      {
        columns.add(key);
        String h = key.toString();
        h.replaceAll('"', '""');
        h = h.contains(',') ? '"$h"' : h;
        header.add(h);
      });
      }}

      // Output Header
      buffer.write('${header.join(", ")}\n');

      // Output Data
      if (columns.isNotEmpty) {
        for (var map in data) {
        i++;
        List<String> row = [];
        for (var column in columns) {
          String value = map.containsKey(column) ? map[column].toString() : '';
          value.replaceAll('"', '""');
          value = value.contains(',') ? '"$value"' : value;
          row.add(value);
        }
        buffer.write('${row.join(", ")}\n');
      }
      }

      // eof
      string = buffer.toString();
      string = string.replaceFirst('\n', '\r\n', string.lastIndexOf('\n'));
    }
    catch(e)
    {
      Log().debug('Error - Creating CSV column[$i]');
      Log().exception(e);
    }
    return string;
}