excels

Documentation

Index

• func CloseAll()
• type Excel
  • func (this *Excel) Close()
  • func (this *Excel) Exist(name string) bool
  • func (this *Excel) Get(name string) (sheet *Sheet, err error)
  • func (this *Excel) GetLine(name string, line ...int) (result map[int][]string, err error)
  • func (this *Excel) IsOpen() bool
  • func (this *Excel) Open(name string) error
  • func (this *Excel) Sheets() []string
• type Sheet
  • func (this *Sheet) Close()
  • func (this *Sheet) Data() (result []string, err error)
  • func (this *Sheet) Line() int
  • func (this *Sheet) Next() bool
  • func (this *Sheet) Nextn(n int) bool

Functions

func CloseAll

func CloseAll()

CloseAll 關閉所有已開啟的excel

Types

type Excel

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

Excel excel資料

func (*Excel) Close

func (this *Excel) Close()

Close 關閉excel

func (*Excel) Exist

func (this *Excel) Exist(name string) bool

Exist sheet是否存在

func (*Excel) Get

func (this *Excel) Get(name string) (sheet *Sheet, err error)

Get 取得sheet

func (*Excel) GetLine

func (this *Excel) GetLine(name string, line ...int) (result map[int][]string, err error)

GetLine 取得sheet行資料

func (*Excel) IsOpen

func (this *Excel) IsOpen() bool

IsOpen 是否開啟excel

func (*Excel) Open

func (this *Excel) Open(name string) error

Open 開啟excel

func (*Excel) Sheets

func (this *Excel) Sheets() []string

Sheets 取得sheet列表

type Sheet

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

Sheet sheet資料

func (*Sheet) Close

func (this *Sheet) Close()

Close 關閉sheet資料

func (*Sheet) Data

func (this *Sheet) Data() (result []string, err error)

Data 取得行資料

func (*Sheet) Line

func (this *Sheet) Line() int

Line 取得目前行數

func (*Sheet) Next

func (this *Sheet) Next() bool

Next 往下一行

func (*Sheet) Nextn

func (this *Sheet) Nextn(n int) bool

Nextn 往下n行