xlsx

package
v0.0.0-...-be72452 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Sep 19, 2024 License: MIT Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Cell

type Cell struct {
	Type  string `xml:"t,attr"`
	Value string `xml:"v"`
}

type ColumnPrediction

type ColumnPrediction struct {
	FileIdx    int
	ColumnName string
	ColumnType string
	Decorators []string
	PrimaryKey bool
}

type Row

type Row struct {
	Cells []Cell `xml:"c"`
}

type Sheet

type Sheet struct {
	Rows []Row `xml:"row"`
}

type StringItem

type StringItem struct {
	Text string `xml:"t"`
}

type TablePrediction

type TablePrediction struct {
	TableName string
	Columns   []ColumnPrediction
}

type Worksheet

type Worksheet struct {
	Sheet Sheet `xml:"sheetData"`
	SS    *sharedStrings
}

func Open

func Open(filepath, sheetName string) *Worksheet

func (*Worksheet) PredictTable

func (ws *Worksheet) PredictTable() (*TablePrediction, error)

func (*Worksheet) ReadAll

func (ws *Worksheet) ReadAll()

func (*Worksheet) WriteSQL

func (ws *Worksheet) WriteSQL(tp *TablePrediction) (string, error)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL