excelutil

Documentation

Index

• func FindExcelContentForRowIndex(f *excelize.File, sheetName string, content string, column int) (result int, err error)
• func InitTitleColumnIndex(f *excelize.File, sheetName string, rowIndex int, startCols ...int) (result map[string]int, err error)
• func ReadPureData(f *excelize.File, sheetName string, markInts ...int) (result []map[string]string, err error)

Functions

func FindExcelContentForRowIndex

func FindExcelContentForRowIndex(f *excelize.File, sheetName string, content string, column int) (result int, err error)

func InitTitleColumnIndex

func InitTitleColumnIndex(f *excelize.File, sheetName string, rowIndex int, startCols ...int) (result map[string]int, err error)

func ReadPureData

func ReadPureData(f *excelize.File, sheetName string, markInts ...int) (result []map[string]string, err error)

对于有明确的标题栏，且标题栏中所有标题都是不一样的，可以统一提取所有数据 markInts为可先参数，第一个位置放可以通过判空确定最后一行的列号，第二个位置为标题所在行号