using System;

using System.Collections;

using System.Collections.Generic;

using System.Data;

using System.IO;

using System.Linq;

using System.Xml.Linq;

​

public static class Program

{

    public static void Main(string[] args)

    {

        const string xml = @"<?xml version=""1.0"" encoding=""UTF-8"" standalone=""yes""?>

<DATAPACKET Version=""2.0"">

    <METADATA>

        <FIELDS>

            <FIELD attrname=""ALMO_Exercicio"" fieldtype=""string"" WIDTH=""4""/>

            <FIELD attrname=""ALMO_MesReferencia"" fieldtype=""string"" WIDTH=""2""/>

            <FIELD attrname=""ALMO_Saldo"" fieldtype=""string"" WIDTH=""17""/>

        </FIELDS>

        <PARAMS/>

    </METADATA>

    <ROWDATA>

        <ROW ALMO_Exercicio=""2016"" ALMO_MesReferencia=""01"" ALMO_Saldo=""0.00""/>

    </ROWDATA>

</DATAPACKET>";

​

        var doc = XDocument.Parse(xml);

​

        var columns = doc.Descendants("FIELD")

            .Attributes("attrname")

            .Select(fieldName => new DataColumn(fieldName.Value))

            .ToArray();

​

        var rows = doc.Descendants("ROW")

            .Select(row => columns.Select(column => (string) row.Attribute(column.ColumnName)).ToArray());

​

        var table = new DataTable();

​

        table.Columns.AddRange(columns);

​

        foreach (var row in rows)

        {

            table.Rows.Add(row);

        }

​

        Console.WriteLine(Line(columns.Select(x => x.ColumnName)));

​

        foreach (DataRow row in table.Rows)

        {

            Console.WriteLine(Line(row.ItemArray));

        }

    }

​

    private static string Line(IEnumerable<object> items)

    {

        return string.Concat(items.Select(x => $"{x,-20}"));

    }

}