excels

Documentation

Overview

Package excels Package internal Time : 2022/9/3 15:26 Author : xushiyin contact : yuqingxushiyin@gmail.com

Index

• func GetDaysReports(startDate string, rangeCnt int, onlyContent bool, logger *log.Entry) (string, error)
• type DailyReport
• type Excels
  • func NewExcels(filePath, filePassword, sheet string, logger *log.Entry) *Excels
  • func (e *Excels) FindDateCell(date string) ([]string, error)
  • func (e *Excels) FindValidRowNumber() int
  • func (e *Excels) GetOneDayDailyReport(month string, date string) ([][]string, error)
  • func (e *Excels) GetRowAxis(axis string, line int) ([]string, error)
  • func (e *Excels) GetRowData(axis []string) ([]string, error)
  • func (e *Excels) GetSheetMonth() []string
  • func (e *Excels) IsExcelExists() (bool, error)
  • func (e *Excels) LogErr(err error, message string, args ...interface{}) error
  • func (e *Excels) MergeDateCell(date string) error
  • func (e *Excels) OpenFile() error
  • func (e *Excels) ReadOneDayDailyReportFromExcel(dateFlag string, rangeFlag int, stdOutFlag, onlyContent bool) (string, error)
  • func (e *Excels) RenderData(ds [][][]string, stdOutFlag, onlyContent bool) (string, error)
  • func (e *Excels) WriteDailyReport(rowNum int, dr *DailyReport) error
  • func (e *Excels) WriteDailyReport2Excel(dr *DailyReport) error

Functions

func GetDaysReports

func GetDaysReports(startDate string, rangeCnt int, onlyContent bool, logger *log.Entry) (string, error)

Types

type DailyReport

type DailyReport struct {
	DateStr     string
	ReportStr   string
	CategoryStr string
	CompleteStr string
	ProgressStr string
	Remarks     string
}

type Excels

type Excels struct {
	FilePath     string
	Sheet        string
	FilePassword string
	File         *excelize.File
	Logger       *log.Entry
}

func NewExcels

func NewExcels(filePath, filePassword, sheet string, logger *log.Entry) *Excels

func (*Excels) FindDateCell

func (e *Excels) FindDateCell(date string) ([]string, error)

func (*Excels) FindValidRowNumber

func (e *Excels) FindValidRowNumber() int

FindValidRowNumber return the number of valid rows in the sheet

func (*Excels) GetOneDayDailyReport

func (e *Excels) GetOneDayDailyReport(month string, date string) ([][]string, error)

func (*Excels) GetRowAxis

func (e *Excels) GetRowAxis(axis string, line int) ([]string, error)

func (*Excels) GetRowData

func (e *Excels) GetRowData(axis []string) ([]string, error)

func (*Excels) GetSheetMonth

func (e *Excels) GetSheetMonth() []string

func (*Excels) IsExcelExists

func (e *Excels) IsExcelExists() (bool, error)

func (*Excels) LogErr

func (e *Excels) LogErr(err error, message string, args ...interface{}) error

func (*Excels) MergeDateCell

func (e *Excels) MergeDateCell(date string) error

func (*Excels) OpenFile

func (e *Excels) OpenFile() error

func (*Excels) ReadOneDayDailyReportFromExcel

func (e *Excels) ReadOneDayDailyReportFromExcel(dateFlag string, rangeFlag int, stdOutFlag, onlyContent bool) (string, error)

func (*Excels) RenderData

func (e *Excels) RenderData(ds [][][]string, stdOutFlag, onlyContent bool) (string, error)

func (*Excels) WriteDailyReport

func (e *Excels) WriteDailyReport(rowNum int, dr *DailyReport) error

WriteDailyReport writes the daily report to the valid row of Excel file

func (*Excels) WriteDailyReport2Excel

func (e *Excels) WriteDailyReport2Excel(dr *DailyReport) error