excel

Documentation

Index

• func SetPageLayout(t *TemplateExcel, layoutDto *dto.TLayoutDto)
• func SetPageLayoutDefault(t *TemplateExcel)
• type ParseData
  • func (p *ParseData) ParseList(f *excelize.File, cellName string, colCell string, ...)
  • func (p *ParseData) ParseSingle(f *excelize.File, cellName string, colCell string, ...)
• type TemplateExcel
  • func (t *TemplateExcel) FindListRowNumber(f *excelize.File) int
  • func (t *TemplateExcel) GetPageLayout()
  • func (t *TemplateExcel) HandleBody(msgHelper *httphelper.HttpHelper, delHeader bool) (*excelize.File, error)
  • func (t *TemplateExcel) HandleBodyIO(reader io.Reader, msgHelper *httphelper.HttpHelper, genfile bool) (*bytes.Buffer, error)
  • func (t *TemplateExcel) HandleBodyPreview(reader io.Reader, layoutDto *dto.TLayoutDto, genfile bool) (*bytes.Buffer, error)
  • func (t *TemplateExcel) Merge(MergeCells []excelize.MergeCell, f *excelize.File)
  • func (t *TemplateExcel) Open(reader io.Reader) (*excelize.File, error)
  • func (t *TemplateExcel) SetPageLayout(layoutDto *dto.TLayoutDto)
  • func (t *TemplateExcel) SetPageLayoutDefault()
  • func (t *TemplateExcel) Unmerge(f *excelize.File) ([]excelize.MergeCell, error)

Functions

func SetPageLayout

func SetPageLayout(t *TemplateExcel, layoutDto *dto.TLayoutDto)

func SetPageLayoutDefault

func SetPageLayoutDefault(t *TemplateExcel)

Types

type ParseData

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

func (*ParseData) ParseList

func (p *ParseData) ParseList(f *excelize.File, cellName string, colCell string,
	httpHelper *httphelper.HttpHelper, irow int)

func (*ParseData) ParseSingle

func (p *ParseData) ParseSingle(f *excelize.File, cellName string, colCell string, msgHelper *httphelper.HttpHelper)

type TemplateExcel

type TemplateExcel struct {
	SheetNameBody string
	InFile        string
	OutFile       string
	DataCount     int

	OutTempFile bool

	File          *excelize.File
	HasHeadFooter bool
	// contains filtered or unexported fields
}

func (*TemplateExcel) FindListRowNumber

func (t *TemplateExcel) FindListRowNumber(f *excelize.File) int

func (*TemplateExcel) GetPageLayout

func (t *TemplateExcel) GetPageLayout()

func (*TemplateExcel) HandleBody

func (t *TemplateExcel) HandleBody(msgHelper *httphelper.HttpHelper, delHeader bool) (*excelize.File, error)

func (*TemplateExcel) HandleBodyIO

func (t *TemplateExcel) HandleBodyIO(reader io.Reader, msgHelper *httphelper.HttpHelper, genfile bool) (*bytes.Buffer, error)

func (*TemplateExcel) HandleBodyPreview

func (t *TemplateExcel) HandleBodyPreview(reader io.Reader, layoutDto *dto.TLayoutDto, genfile bool) (*bytes.Buffer, error)

func (*TemplateExcel) Merge

func (t *TemplateExcel) Merge(MergeCells []excelize.MergeCell, f *excelize.File)

MergeCells

func (*TemplateExcel) Open

func (t *TemplateExcel) Open(reader io.Reader) (*excelize.File, error)

func (*TemplateExcel) SetPageLayout

func (t *TemplateExcel) SetPageLayout(layoutDto *dto.TLayoutDto)

入参

func (*TemplateExcel) SetPageLayoutDefault

func (t *TemplateExcel) SetPageLayoutDefault()

func (*TemplateExcel) Unmerge

func (t *TemplateExcel) Unmerge(f *excelize.File) ([]excelize.MergeCell, error)

UnmergeCells