SpreadSheetParser 0.0.4

SpreadSheetParser

Convert your .xlsx file to a C# object and them, do what you want!

This package can help read and parse a SpreadSheet/Excel .xlsx file and return a object.

1. Choose a .xlsx file:

Image Book.xlsx

2. Make a class to represent this sheet

    [DisplayName("First Sheet")]
    public class SampleSheet : SheetObject
    {
        [DisplayName("First Column")]
        public Double FirstColumn { get; set; }

        [DisplayName("Second Column")]
        public Double SecondColumn { get; set; }

        public SampleSheet(SheetHeader header, SheetRow row) : base(header, row)
        {
            if (TryBuildObject<SampleSheet>(this) is false)
                throw new ArgumentException("Could not create a sample object");
        }

    }

Pay attention to the DisplayNameAttribute, we are using this to infer the sheet name and the table header columns name.

Make sure the type of the properties is exactly the same of the spread sheet column.

The first row in the sheet is used as a Header, each column must always be a string in this row.

3. In the constructor, you have to use the base method "TryBuildObject<YourClass>(this)", it will try to create a object using reflection.

4. Now, you can create a SheetFile<YourClass>:

using SpreadSheetParser.Models;
using SpreadSheetParser.Extensions;

var sheet = new SheetFile<SampleSheet>(new FileInfo("Book.xlsx"));

List<SampleSheet> sampleObjects = sheet.BuildSheet<SampleSheet>();

5. The result should be like this:

Image VS Code

This component reads just one sheet per builder, if you want to read multiple sheet, use a builder to each one.