ExcelExporterClosedXML 1.0.6

Very often you need to quickly convert an IEnumerable<T> to an .xlsx file I made a small package to help.

If you have any questions, post them here: donleon314@gmail.com

What's new:

• 1.0.6 NEWS: SetTextColor, SetBackgroundColor, Stream, Bytes

• 1.0.5 The first version that is exposed to everyone!

How to use?

1. We have some kind of class

    public class Person
    {
        public int Id { get; }
        public string FirstName { get; }
        public string SecondName { get; }
        public DateTime BirthDay { get; }
        public Person( int id, string firstName, string secondName, DateTime birthDay )
        {
            this.Id = id;
            this.FirstName = firstName;
            this.SecondName = secondName;
            this.BirthDay = birthDay;
        }
    }

2. We write the export configuration method

    public static class ExcelConfiguration
    {
        public static void PersonConfig( ExcelExporterEngine<Person, ClosedXMLWorksheetPayload> engine )
        {
            // Column ID
            engine.BuildColumn( ( iCell, data ) =>
            {
                iCell.SetCellValue( data.Id );
            },
            "id",
            ( iCell, headName ) =>
            {
               iCell.SetCellValue( headName );
            } )

            // Column First Name
            .BuildColumn( ( iCell, data ) =>
            {

                iCell.SetCellValue( data.FirstName );
                iCell.SetBackgroundColor( 155, 155, 255); // Background white-blue

            }, "First Name",
            ( iCell, headName ) =>
            {

                iCell.SetCellValue( headName );
                iCell.SetTextColor( 0,0,0 ); // text BLACK

            } );
        }
    }

3. Use ExcelExporterClosedXML

    List<Person> data = new List<Person>();

    data.Add( new Person( 1, "John", "Smith", new DateTime( 1990, 12, 31 ), 10000.01m ) );
    data.Add( new Person( 2, "Billy", "Bons", new DateTime( 1971, 10, 3 ), 1.00m ) );


    ExcelExporterClosedXML.ExcelExporterClosedXML exporter =
                    new ExcelExporterClosedXML.ExcelExporterClosedXML();

    exporter.GenerateWorkSheet( data, "Men in black", ExcelConfiguration.PersonConfig );

    exporter.SaveAs( "Persons.xlsx" );
    // byte[] bytes = exporter.Bytes;
    // Stream stream = exporter.Stream; // WArning - Dispose