excel

Documentation

Index

• func ChartStructToString(ChartStruct interface{}) string
• func GetColLetter(col int) string
• func ReadExcelFile(excelFileName string) (map[string]interface{}, error)
• func StringToFloat(str string) float64
• func Zip(zipFile string, fileList []string) error
• type FormatChart
  • func InitFormatChart() FormatChart
• type FormatChartAxis
• type FormatChartDimension
• type FormatChartLegend
• type FormatChartSeries
• type FormatChartTitle
• type FormatFont
• type FormatLayout
• type FormatPicture
• type FormatShape
• type FormatShapeColor
• type FormatShapeParagraph

Functions

func ChartStructToString

func ChartStructToString(ChartStruct interface{}) string

func GetColLetter

func GetColLetter(col int) string

func ReadExcelFile

func ReadExcelFile(excelFileName string) (map[string]interface{}, error)

func StringToFloat

func StringToFloat(str string) float64

func Zip

func Zip(zipFile string, fileList []string) error

Types

type FormatChart

type FormatChart struct {
	Type      string               `json:"type"`
	Series    []FormatChartSeries  `json:"series"`
	Format    FormatPicture        `json:"format"`
	Dimension FormatChartDimension `json:"dimension"`
	Legend    FormatChartLegend    `json:"legend"`
	Title     FormatChartTitle     `json:"title"`
	XAxis     FormatChartAxis      `json:"x_axis"`
	YAxis     FormatChartAxis      `json:"y_axis"`
	Chartarea struct {
		Border struct {
			None bool `json:"none"`
		} `json:"border"`
		Fill struct {
			Color string `json:"color"`
		} `json:"fill"`
		Pattern struct {
			Pattern string `json:"pattern"`
			FgColor string `json:"fg_color"`
			BgColor string `json:"bg_color"`
		} `json:"pattern"`
	} `json:"chartarea"`
	Plotarea struct {
		ShowBubbleSize  bool `json:"show_bubble_size"`
		ShowCatName     bool `json:"show_cat_name"`
		ShowLeaderLines bool `json:"show_leader_lines"`
		ShowPercent     bool `json:"show_percent"`
		ShowSerName     bool `json:"show_series_name"`
		ShowVal         bool `json:"show_val"`
		Gradient        struct {
			Colors []string `json:"colors"`
		} `json:"gradient"`
		Border struct {
			Color    string `json:"color"`
			Width    int    `json:"width"`
			DashType string `json:"dash_type"`
		} `json:"border"`
		Fill struct {
			Color string `json:"color"`
		} `json:"fill"`
		Layout FormatLayout `json:"layout"`
	} `json:"plotarea"`
	ShowBlanksAs   string `json:"show_blanks_as"`
	ShowHiddenData bool   `json:"show_hidden_data"`
	SetRotation    int    `json:"set_rotation"`
	SetHoleSize    int    `json:"set_hole_size"`
}

func InitFormatChart

func InitFormatChart() FormatChart

type FormatChartAxis

type FormatChartAxis struct {
	Crossing            string  `json:"crossing"`
	MajorGridlines      bool    `json:"major_grid_lines"`
	MajorTickMark       string  `json:"major_tick_mark"`
	MinorTickMark       string  `json:"minor_tick_mark"`
	MinorUnitType       string  `json:"minor_unit_type"`
	MajorUnit           int     `json:"major_unit"`
	MajorUnitType       string  `json:"major_unit_type"`
	DisplayUnits        string  `json:"display_units"`
	DisplayUnitsVisible bool    `json:"display_units_visible"`
	DateAxis            bool    `json:"date_axis"`
	ReverseOrder        bool    `json:"reverse_order"`
	Maximum             float64 `json:"maximum"`
	Minimum             float64 `json:"minimum"`
	NumFormat           string  `json:"num_Format"`
	NumFont             struct {
		Color     string `json:"color"`
		Bold      bool   `json:"bold"`
		Italic    bool   `json:"italic"`
		Underline bool   `json:"underline"`
	} `json:"num_font"`
	NameLayout FormatLayout `json:"name_layout"`
}

FormatChartAxis directly maps the Format settings of the chart axis.

type FormatChartDimension

type FormatChartDimension struct {
	Width  int `json:"width"`
	Height int `json:"height"`
}

type FormatChartLegend

type FormatChartLegend struct {
	None            bool         `json:"none"`
	DeleteSeries    []int        `json:"delete_series"`
	Font            FormatFont   `json:"font"`
	Layout          FormatLayout `json:"layout"`
	Position        string       `json:"position"`
	ShowLegendEntry bool         `json:"show_legend_entry"`
	ShowLegendKey   bool         `json:"show_legend_key"`
}

FormatChartLegend directly maps the Format settings of the chart legend.

type FormatChartSeries

type FormatChartSeries struct {
	Name       string `json:"name"`
	Categories string `json:"categories"`
	Values     string `json:"values"`
	Line       struct {
		None  bool   `json:"none"`
		Color string `json:"color"`
	} `json:"line"`
	Marker struct {
		Type   string  `json:"type"`
		Size   int     `json:"size"`
		Width  float64 `json:"width"`
		Border struct {
			Color string `json:"color"`
			None  bool   `json:"none"`
		} `json:"border"`
		Fill struct {
			Color string `json:"color"`
			None  bool   `json:"none"`
		} `json:"fill"`
	} `json:"marker"`
}

FormatChartSeries directly maps the Format settings of the chart series.

type FormatChartTitle

type FormatChartTitle struct {
	None    bool         `json:"none"`
	Name    string       `json:"name"`
	Overlay bool         `json:"overlay"`
	Layout  FormatLayout `json:"layout"`
}

FormatChartTitle directly maps the Format settings of the chart title.

type FormatFont

type FormatFont struct {
	Bold      bool    `json:"bold"`
	Italic    bool    `json:"italic"`
	Underline string  `json:"underline"`
	Family    string  `json:"family"`
	Size      float64 `json:"size"`
	Strike    bool    `json:"strike"`
	Color     string  `json:"color"`
}

FormatFont directly maps the styles settings of the fonts.

type FormatLayout

type FormatLayout struct {
	X      float64 `json:"x"`
	Y      float64 `json:"y"`
	Width  float64 `json:"width"`
	Height float64 `json:"height"`
}

FormatLayout directly maps the Format settings of the element layout.

type FormatPicture

type FormatPicture struct {
	FPrintsWithSheet bool    `json:"print_obj"`
	FLocksWithSheet  bool    `json:"locked"`
	NoChangeAspect   bool    `json:"lock_aspect_ratio"`
	OffsetX          int     `json:"x_offset"`
	OffsetY          int     `json:"y_offset"`
	XScale           float64 `json:"x_scale"`
	YScale           float64 `json:"y_scale"`
	Hyperlink        string  `json:"hyperlink"`
	HyperlinkType    string  `json:"hyperlink_type"`
	Positioning      string  `json:"positioning"`
}

FormatPicture directly maps the Format settings of the picture.

type FormatShape

type FormatShape struct {
	Type      string                 `json:"type"`
	Width     int                    `json:"width"`
	Height    int                    `json:"height"`
	Format    FormatPicture          `json:"format"`
	Color     FormatShapeColor       `json:"color"`
	Paragraph []FormatShapeParagraph `json:"paragraph"`
}

FormatShape directly maps the Format settings of the shape.

type FormatShapeColor

type FormatShapeColor struct {
	Line   string `json:"line"`
	Fill   string `json:"fill"`
	Effect string `json:"effect"`
}

FormatShapeColor directly maps the color settings of the shape.

type FormatShapeParagraph

type FormatShapeParagraph struct {
	Font FormatFont `json:"font"`
	Text string     `json:"text"`
}

FormatShapeParagraph directly maps the Format settings of the paragraph in the shape.