excels

package

v0.20.1 Latest Latest Go to latest Published: Jan 13, 2024 License: MIT Imports: 11 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

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

This section is empty.

This section is empty.

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

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

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

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

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

func (e *Excels) FindValidRowNumber() int

FindValidRowNumber return the number of valid rows in the sheet

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

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

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