Skip to content
Jos de Weger edited this page Mar 22, 2020 · 14 revisions

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.

Getting started

Click here

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.