josdeweger-zz/sheettoobjects

Simple library which aims to provide developers with an easy solution to map sheets (Google Sheets, Microsoft Excel, csv) to models

sheettoobjects's Issues

Add 'IsUniqueInColumn' validation

Add base64 encoded string as input for CSV and Excel adapter

Configuring default values for non-nullables

when a property is:

• not nullable
• not required

then in the column config a default value should be obligatory, otherwise there is no way to know to what value the property should be set (0? MinValue? MaxValue?)

Protected Sheets as separate nuget package

I think it would be better to create a separate package for the protected sheets because it uses different nuget packages as reference: especially the google packages, I would not want them in my project if I didn't use them. Either way for the Refit package, which is not used for the protected sheets.

Any comments on this?

Stop parsing when cell x has value y

I am importing product data but when importing I do not know the number of rows so I provide a large value (for Excel), e.g. 100000 rows. It takes a serious amout of time to parse the document while there are only 10 rows available.

It should be nice to have a StopParsingRule, e.g.:

var sheetMapper = new SheetMapper()
                .AddConfigFor<AdditionExcelImport>(cfg => cfg
.MapColumn(column => column
                        .WithHeader("Code")
                        .MapTo(m => m.Code)
.StopParsingWhen(x => x == null)
)

I might try and implement something like this but would like to know if anyone else have an interest in this feature.

Add min/max validation

Add 'IsUniqueRow' validation

Documentation for the adapters

Better documentation of the adapters will help people to quickly understand how to use this library.

Regex which allows empty strings fails while it shouldn't

Create Excel adapter

Make internals in Core and Lib public

It is impossible to extend the library with new adapters unless it's done in the same codebase. The classes in both the core and lib project needed to create a new adapter should be public for better extendability.

Add as dotnet package

I would like to be able to do dotnet add package SheetToObjects.Providers.Excel

Add nested objects support

Multiple configurations by Type

The SheetMapper already contains a Dictionary<Type, MappingConfig>, which stores MappingConfigs per Type

Easier registering of configurations

Create something similar like AutoMapper Profiles, that can be discovered via assembly scanning.
This will also allow for a services.AddSheetToObjects() extension method that will handle all registrations

Custom data mapper

It would be nice to have a simple data converter to be able to some simple transformation e.g. 0/1 => false/true. I created a test to try some different ideas but would like to know if a PR with some kind of solution in this direction would be accepted.

Sample tests: https://github.com/jacobduijzer/Spielerei/blob/master/Spielerei.Tests/CustomMapper/CustomMapperShould.cs

Add comments to MappingConfigBuilder and underlying methods for better Intellisense experience

Facilitating custom validation rules

Resolved by #22

DateTime parsing with format

Configuration validation

Add validation for several parts of the fluent configuration, provide developer with proper feedback about their config

Make Mapping Sheet extension for nicer chaining