sheety

README

Sheety

Easily load csv or xlsx formats into a slice of structs

Installation

go get -u github.com/chriswalz/Sheety

Usage

    package main

    import (
    	"github.com/chriswalz/sheety"
    )

    type Student struct {
    	ID    float64
    	Grade float64
    }

    func main()  {
        s, err := sheety.OpenCSV("grades.csv")
    	if err != nil {
    		panic(err)
    	}
     
        // use pointer to struct
    	students := make([]*Student, 0, 3)
    
    	// map column index to struct field name
    	// First index starts at 1 NOT 0
    	err = s.ReadRows(1, &students, map[int]string{
    		1: "ID",
    		2: "Grade",
    	})
    	for _, v := range students {
    		// do work 
    	}
   }

See sheety_test.go for example usage

Documentation

Index

• type SpreadCSV
  • func OpenCSV(excelFileName string) (*SpreadCSV, error)
  • func (s *SpreadCSV) ReadRows(startIndex int, bb interface{}, m map[int]string) error
• type Spreadsheet
  • func OpenSpreadsheet(excelFileName string) (*Spreadsheet, error)
  • func (s *Spreadsheet) ReadRows(start int, bb interface{}, m map[int]string)
  • func (s *Spreadsheet) SaveRows(start int, bb interface{}, m map[int]string, path string)

Types

type SpreadCSV

type SpreadCSV struct {
	// contains filtered or unexported fields
}

func OpenCSV

func OpenCSV(excelFileName string) (*SpreadCSV, error)

func (*SpreadCSV) ReadRows

func (s *SpreadCSV) ReadRows(startIndex int, bb interface{}, m map[int]string) error

ReadRows takes a starting row index, a pointer to slice, and a mapping from spreadsheet to struct

type Spreadsheet

type Spreadsheet struct {
	// contains filtered or unexported fields
}

func OpenSpreadsheet

func OpenSpreadsheet(excelFileName string) (*Spreadsheet, error)

func (*Spreadsheet) ReadRows

func (s *Spreadsheet) ReadRows(start int, bb interface{}, m map[int]string)

ReadRows takes a starting row index, a pointer to slice, and a mapping from spreadsheet to struct

func (*Spreadsheet) SaveRows

func (s *Spreadsheet) SaveRows(start int, bb interface{}, m map[int]string, path string)

ReadRows takes a starting row index, a pointer to slice, and a mapping from spreadsheet to struct