List of ExpandoObjects in Util.WriteCsv

BandiG · October 2013

Hi Joe,

The latest version handles ExpandoObjects well with Dump, which is sweet as I had to do a nasty select with them to get the proper results before. However what works well with Dump still does not work well with Util.WriteCsv. The result is this:
Value
System.Dynamic.ExpandoObject
System.Dynamic.ExpandoObject
System.Dynamic.ExpandoObject...

Any ideas how to get the same output as Dump?

Thanks,

Gergely

Omnius · March 2019

I was hoping for an answer to this question as well.

In the end I just wrote my own, so for anyone looking for this, just cast your ExpandoObjects to IDictionary and pass the list:


    private void WriteLine(StreamWriter outputFile, IEnumerable<string> items)
    {
        var first = true;
        foreach (var item in items)
        {
            if (!first) outputFile.Write(",");
            
            if (null != item)
                outputFile.Write(item);
            else
                outputFile.Write(string.Empty);
                
            first = false;
        }

        outputFile.WriteLine();
    }

    public void WriteCsv(IList<IDictionary<string, object>> results, string outputFilePath)
    {
        using (var outputFile = new StreamWriter(outputFilePath))
        {
            // First write the headers
            WriteLine(outputFile, results.First().Keys);
            
            // Now write the data rows
            foreach (var result in results)
            {
                WriteLine(outputFile, result.Values.Select(v => v.ToString()));
            }
        }
    }

JoeAlbahari · March 2019

Good call - I'll fix this for the next build.

JoeAlbahari · April 2019

A new beta has now been released:
https://www.linqpad.net/download.aspx#beta

List of ExpandoObjects in Util.WriteCsv

Comments