using OfficeOpenXml;

using OfficeOpenXml.Table;

using System;

using System.Collections;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Reflection;

using System.Text;

using System.Threading.Tasks;

using System.Xml.Linq;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

        leer("");

    }

      public static void leer(string archivo)

        {

            StringBuilder result = new StringBuilder();

            //Load xml

            XDocument xdoc = XDocument.Load(archivo);

            XNamespace cfdi = "http://www.sat.gob.mx/cfd/3";

            string folio = xdoc.Element(cfdi + "Comprobante").Attribute("Folio").Value;

            //Run Query

            var lv1s = from lvl in xdoc.Descendants(cfdi + "Comprobante")

                       select new

                       {

                           Sello = lvl.Attribute("Sello").Value,

                           ChildEmisor = from e in lvl.Descendants(cfdi + "Emisor")

                                         select new

                                         {

                                             RFC = e.Attribute("Rfc").Value,

                                             Nombre = e.Attribute("Nombre").Value,

                                             RegimenFiscal = e.Attribute("RegimenFiscal").Value

                                         },

                           ChildReceptor = from r in lvl.Descendants(cfdi + "Receptor")

                                           select new

                                           {

                                               RFC = r.Attribute("Rfc").Value,

                                               Nombre = r.Attribute("Nombre").Value,

                                               UsoCFDI = r.Attribute("UsoCFDI").Value,

                                           },

                           ChildConcepts = from r in lvl.Descendants(cfdi + "Conceptos")

                                           select new

                                           {

                                               ChildConcept = from c in r.Descendants(cfdi + "Concepto")

                                                              select new

                                                              {

                                                                  ClaveProdServ = c.Attribute("ClaveProdServ").Value,

                                                                  Cantidad = c.Attribute("Cantidad").Value,

                                                                  ClaveUnidad = c.Attribute("ClaveUnidad").Value,

                                                                  Unidad = c.Attribute("Unidad").Value

                                                              }

                                           }

                       };

​

            var d = from x in lv1s.ToList().Select(c => c.ChildEmisor).ToList()

                    select new

                    {

                        Sello = lv1s.Select(f => f.Sello).FirstOrDefault(),

                        rfcE = x.Select(g => g.RFC).FirstOrDefault(),

                        rfcR = lv1s.Select(c => c.ChildReceptor.ToList().Select(o => o.RFC).FirstOrDefault()).FirstOrDefault()

                    };

​

​

            Export(archivo, d.ToList());

        }

​

​

        private static void Export(string FileName, IEnumerable<object> list)

        {

            var lista = list.Cast<Object>().ToList();

​

            // Create the file'

            // Dim newFile As FileInfo = New FileInfo(FileName)

            string filePath = "C:\\XML\\Articho.xlsx"; // Ruta del Archivo

​

            FileInfo file = new FileInfo(filePath);

            if (file.Exists)

                file.Delete();

​

            ExcelPackage pck = new ExcelPackage(file);

            // Add the first sheet'

            ExcelWorksheet worksheet = pck.Workbook.Worksheets.Add("Hoja1");

            worksheet.Cells.LoadFromCollection(lista,true);

            // Export Each Row End

​

            //or if you use asp.net, get the relative path

​

​

            //Write the file to the disk

            FileInfo fi = new FileInfo(filePath);

            pck.Save();

​

            //pck.Save();

        }

​

}