xlsx

Documentation

Index

• func GetOutFile(outFilename string, outFilepath string) (file *os.File, err error)
• type File
  • func New(path string) (file *File, err error)
  • func (f *File) GenerateCSVFromSheet(w io.Writer, index int, csvOpts csvOptSetter) error
  • func (f *File) GenerateCSVsFromAllSheets(outFilepath string, csvOpts csvOptSetter, lowerCaseOutputfiles bool, ...) error
  • func (f *File) SheetCount() int

Functions

func GetOutFile

func GetOutFile(outFilename string, outFilepath string) (file *os.File, err error)

GetOutFile opens a file for writing at outFilename

Types

type File

type File struct {
	Path     string
	XLSXData *x.File
}

File provides access to the xslx data as well as the path

func New

func New(path string) (file *File, err error)

New provides an open xslx.File

func (*File) GenerateCSVFromSheet

func (f *File) GenerateCSVFromSheet(w io.Writer, index int, csvOpts csvOptSetter) error

GenerateCSVFromSheet outputs a delimited file based on the data at the sheet index

func (*File) GenerateCSVsFromAllSheets

func (f *File) GenerateCSVsFromAllSheets(outFilepath string, csvOpts csvOptSetter, lowerCaseOutputfiles bool, sheetNamePrefix string) error

GenerateCSVsFromAllSheets iterates through all sheets and saves them as CSVs using their name

func (*File) SheetCount

func (f *File) SheetCount() int

SheetCount provides the number of sheets found in the workbook