Versions in this module Expand all Collapse all v1 v1.0.2201 Jul 1, 2022 v1.0.2109 Aug 20, 2021 v1.0.2108 Aug 6, 2021 Changes in this version + func ExcelToSql(cfg string) ([]string, error) + type Cells struct + Axismaps map[string]string + DbDest *DbDestination + type Column struct + DbDest *DbDestination + FirstCol string + IgnoreCols []string + LastCol string + LoadCols []string + Rowmaps map[string]string + type DataBaseSet struct + DbName string + DbType string + Host string + Password string + Port int + UserName string + type DbDestination struct + Consts map[string]string + TableName string + TimeColumns *TimeColumns + Wheres []*Wheres + type DbValues struct + ColNames []string + TableName string + Values [][]string + func (dbv *DbValues) FormatInsertSql() string + func (dbv *DbValues) Print() + type ExcelFile struct + Cells []*Cells + Column *Column + FileName string + Password string + Row *Row + Sheets []string + func NewExcelFile(cfg string) (*ExcelFile, error) + func (ef *ExcelFile) GetValues() ([]*DbValues, error) + func (ef *ExcelFile) OpenFile() error + type GetValueMethod struct + Format string + Method string + func NewGetValueMethod(method, format string) *GetValueMethod + func (g *GetValueMethod) GetValue(ef *ExcelFile) (string, interface{}) + type Row struct + Colmaps map[string]string + DbDest *DbDestination + FirstRow int + IgnoreRows []int + LastRow int + LoadRows []int + type TimeColumns struct + ColNames []string + GetFrom []*GetValueMethod + TimeFormat []string + type Wheres struct + ColNames []string + Operator []string + Values []*GetValueMethod
Go to main page