xlsx

README

xlsx/csv列提取器

1. 根据指定标题列表提取列字段
2. 标题行前可以有空行
3. 正确转化日期

使用方法

import (
	"github.com/rosbit/xlsx-extractor"
	"os"
	"fmt"
)

func main() {
	// --- reading xlsx book sheet ----
	book, err := os.Open("somebook.xlsx")
	if err != nil {
		// error
		return
	}
	defer book.Close()

	rows, err := xlsx.XlsxRows(book, "Sheet1", []string{"title1", "title2", "title3"})
	if err != nil {
		// error
	}
	for row := range rows {
		fmt.Printf("%#v\n", row)
	}

	// --- reading csv ----
	fpCsv, err := os.Open("somename.csv")
	if err != nil {
		// error
	}
	defer fpCsv.Close()
	lines, err := xlsx.CsvRows(fpCsv, []string{"title1", "title2"})
	if err != nil {
		// error
	}
	for line := range lines {
		fmt.Printf("%#v\n", line)
	}
}

Documentation

Index

• func CsvRows(book io.Reader, titles []string) (<-chan []string, error)
• func CsvRowsWithTitles(book io.Reader, titles []string) ([]string, <-chan []string, error)
• func Rows(book io.Reader, sheet string, titles []string, o ...Option) (<-chan []string, error)
• func RowsWithTitles(book io.Reader, sheet string, titles []string, o ...Option) ([]string, <-chan []string, error)
• func XlsRows(book io.ReadSeeker, charset, sheet string, titles []string, o ...Option) (<-chan []string, error)
• func XlsRowsWithTitles(book io.ReadSeeker, charset, sheet string, titles []string, o ...Option) ([]string, <-chan []string, error)
• type Option
  • func SetDateFields(dateFields []string) Option
  • func SkipLines(linesBeforeTitles, linesAfterTitles int) Option
• type Options

Functions

func CsvRows

func CsvRows(book io.Reader, titles []string) (<-chan []string, error)

func CsvRowsWithTitles

func CsvRowsWithTitles(book io.Reader, titles []string) ([]string, <-chan []string, error)

func Rows

func Rows(book io.Reader, sheet string, titles []string, o ...Option) (<-chan []string, error)

func RowsWithTitles

func RowsWithTitles(book io.Reader, sheet string, titles []string, o ...Option) ([]string, <-chan []string, error)

func XlsRows

func XlsRows(book io.ReadSeeker, charset, sheet string, titles []string, o ...Option) (<-chan []string, error)

func XlsRowsWithTitles

func XlsRowsWithTitles(book io.ReadSeeker, charset, sheet string, titles []string, o ...Option) ([]string, <-chan []string, error)

Types

type Option

type Option func(*Options)

func SetDateFields

func SetDateFields(dateFields []string) Option

func SkipLines

func SkipLines(linesBeforeTitles, linesAfterTitles int) Option

type Options

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