Home

What is SheetToObjects?

A simple library which aims to provide developers with an easy solution to map sheets (Google Sheets, Microsoft Excel, csv) to a model/POCO.

How does it work?

The overall idea is to create a SheetMapper which can be configured HOW to map each row in a sheet to a model. Currently the following sheet types are supported:

• Google Sheets, via nuget pakage SheetToObjects.Adapters.GoogleSheets
• Microsoft Excel, via nuget pakage SheetToObjects.Adapters.MicrosoftExcel
• Comma Seperated Value files (.csv), via nuget pakage SheetToObjects.Adapters.Csv

But... Why!?

Having solved the problem of creating a custom csv/excel import (including upload, validation, mapping etc.) a couple of times, it seemed about time to make something generic and reusable.