using System;

using System.Data.SqlClient;

using System.IO;

using System.Linq;

using Dapper;

using MiniExcelLibs;

public class Program

{

    public static void Main()

    {

        var path = "demo.xlsx";

        var values = new[] { new { A = "Github", B = DateTime.Parse("2021-01-01") }, new { A = "Microsoft", B = DateTime.Parse("2021-02-01") } };

​

        // create 

        using (var stream = File.Create(path))

            stream.SaveAs(values);

​

        // query dynamic

        {

            var rows = MiniExcel.Query(path,useHeaderRow: true).ToList();

            Console.WriteLine(rows[0].A); //Github

            Console.WriteLine(rows[0].B); //2021-01-01 12:00:00 AM

            Console.WriteLine(rows[1].A); //Microsoft

            Console.WriteLine(rows[1].B); //2021-02-01 12:00:00 AM      

        }

        // or by stream

        using (var stream = File.OpenRead(path))

        {

            var rows = stream.Query(useHeaderRow: true).ToList();

            Console.WriteLine(rows[0].A); //Github

            Console.WriteLine(rows[0].B); //2021-01-01 12:00:00 AM

            Console.WriteLine(rows[1].A); //Microsoft

            Console.WriteLine(rows[1].B); //2021-02-01 12:00:00 AM      

        }

​

        // query type mapping

        using (var stream = File.OpenRead(path))

        {

            var rows = stream.Query<Demo>().ToList();

            Console.WriteLine(rows[0].A); //Github

            Console.WriteLine(rows[0].B); //2021-01-01 12:00:00 AM

            Console.WriteLine(rows[1].A); //Microsoft

            Console.WriteLine(rows[1].B); //2021-02-01 12:00:00 AM          

        }

​

        File.Delete(path);

​

        // Create by DapperRows

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))

        {

            var rows = connection.Query(@"select 'MiniExcel' as Column1,1 as Column2 union all select 'Github',2");

            MiniExcel.SaveAs(path, rows);

        }

​

        using (var stream = File.OpenRead(path))

        {

            var rows = stream.Query(useHeaderRow:true).ToList();

            Console.WriteLine(rows[0].Column1); //MiniExcel

            Console.WriteLine(rows[0].Column2); //1

            Console.WriteLine(rows[1].Column1); //Github

            Console.WriteLine(rows[1].Column2); //2         

        }

    }

​

    public class Demo

    {

        public string A { get; set; }

        public string B { get; set; }

    }

}

​