Documentation ¶
Overview ¶
Package goxcel is a library to operate Excel made in Golang. This library works only on Windows.
Goxcel is the main struct in this library. NewGoxcel() is the staring point.
References:
Index ¶
- Variables
- func InitGoxcel() (func(), error)
- func MustInitGoxcel() func()
- func MustNewGoxcel() (*Goxcel, ReleaseFunc)
- func NewGoxcel() (*Goxcel, ReleaseFunc, error)
- func NewWorkbook(wbs *Workbooks, wb *ole.IDispatch) (*Workbook, ReleaseFunc)
- type Cell
- func (c *Cell) Column() (int32, error)
- func (c *Cell) ComObject() *ole.IDispatch
- func (c *Cell) End(direction constants.XlDirection) (*XlRange, error)
- func (c *Cell) Font() (*Font, error)
- func (c *Cell) Goxcel() *Goxcel
- func (c *Cell) Interior() (*Interior, error)
- func (c *Cell) MustSetValue(value interface{})
- func (c *Cell) MustValue() interface{}
- func (c *Cell) PageBreak(pageBreakType constants.XlPageBreak) error
- func (c *Cell) Releaser() *Releaser
- func (c *Cell) Row() (int32, error)
- func (c *Cell) Select() error
- func (c *Cell) SetNumberFormatLocal(format constants.NumberFormatLocal) error
- func (c *Cell) SetValue(value interface{}) error
- func (c *Cell) String() (string, error)
- func (c *Cell) Value() (interface{}, error)
- type ComReleaser
- type Font
- func (f *Font) Bold() (bool, error)
- func (f *Font) Color() (constants.XlRgbColor, error)
- func (f *Font) ComObject() *ole.IDispatch
- func (f *Font) Goxcel() *Goxcel
- func (f *Font) Italic() (bool, error)
- func (f *Font) Name() (string, error)
- func (f *Font) Releaser() *Releaser
- func (f *Font) SetBold(isBold bool) error
- func (f *Font) SetColor(color constants.XlRgbColor) error
- func (f *Font) SetItalic(isItalic bool) error
- func (f *Font) SetName(fontName string) error
- func (f *Font) SetSize(fontSize int) error
- func (f *Font) SetStrikethrough(isStrikethrough bool) error
- func (f *Font) SetUnderline(value constants.XlUnderlineStyle) error
- func (f *Font) Size() (int, error)
- func (f *Font) Strikethrough() (bool, error)
- func (f *Font) Underline() (constants.XlUnderlineStyle, error)
- type Goxcel
- func (g *Goxcel) ActiveSheet() (*Worksheet, *Workbook, ReleaseFunc, error)
- func (g *Goxcel) ActiveWindow() (*Window, error)
- func (g *Goxcel) ActiveWorkbook() (*Workbook, ReleaseFunc, error)
- func (g *Goxcel) ComObject() *ole.IDispatch
- func (g *Goxcel) DisplayAlerts() (bool, error)
- func (g *Goxcel) EnableEvents() (bool, error)
- func (g *Goxcel) Goxcel() *Goxcel
- func (g *Goxcel) MustSetVisible(value bool)
- func (g *Goxcel) MustSilent(visible bool)
- func (g *Goxcel) MustWorkbooks() *Workbooks
- func (g *Goxcel) Releaser() *Releaser
- func (g *Goxcel) ScreenUpdating() (bool, error)
- func (g *Goxcel) SetDisplayAlerts(value bool) error
- func (g *Goxcel) SetEnableEvents(value bool) error
- func (g *Goxcel) SetScreenUpdating(value bool) error
- func (g *Goxcel) SetVisible(value bool) error
- func (g *Goxcel) Silent(visible bool) error
- func (g *Goxcel) Workbooks() (*Workbooks, error)
- type GoxcelObject
- type HPageBreak
- type HPageBreaks
- func (hpbs *HPageBreaks) Add(ra *XlRange) error
- func (hpbs *HPageBreaks) ComObject() *ole.IDispatch
- func (hpbs *HPageBreaks) Count() (int32, error)
- func (hpbs *HPageBreaks) Goxcel() *Goxcel
- func (hpbs *HPageBreaks) Item(index int) (*HPageBreak, error)
- func (hpbs *HPageBreaks) Releaser() *Releaser
- func (hpbs *HPageBreaks) Walk(walkFn func(hpb *HPageBreak, index int) error) (*HPageBreak, error)
- type HasComObject
- type HasGoxcel
- type HasReleaser
- type HyperLinks
- func (hl *HyperLinks) Add(ra *XlRange, address string, subAddress string, screenTip string, ...) error
- func (hl *HyperLinks) ComObject() *ole.IDispatch
- func (hl *HyperLinks) Count() (int64, error)
- func (hl *HyperLinks) Delete() error
- func (hl *HyperLinks) Goxcel() *Goxcel
- func (hl *HyperLinks) Item(index int) (*HyperLinks, error)
- func (hl *HyperLinks) Releaser() *Releaser
- type Interior
- type PageSetup
- func (p *PageSetup) ComObject() *ole.IDispatch
- func (p *PageSetup) Goxcel() *Goxcel
- func (p *PageSetup) Releaser() *Releaser
- func (p *PageSetup) SetCenterFooter(value interface{}) error
- func (p *PageSetup) SetCenterHeader(value interface{}) error
- func (p *PageSetup) SetOrientation(value constants.XlPageOrientation) error
- type ReleaseFunc
- type Releaser
- type Shape
- type Shapes
- func (ss *Shapes) AddPicture(filename string, left, top, width, height int) error
- func (ss *Shapes) ComObject() *ole.IDispatch
- func (ss *Shapes) Count() (int32, error)
- func (ss *Shapes) Goxcel() *Goxcel
- func (ss *Shapes) Item(index int) (*Shape, error)
- func (ss *Shapes) Releaser() *Releaser
- func (ss *Shapes) Walk(walkFn func(s *Shape, index int) error) (*Shape, error)
- type VPageBreak
- type VPageBreaks
- func (vpbs *VPageBreaks) Add(ra *XlRange) error
- func (vpbs *VPageBreaks) ComObject() *ole.IDispatch
- func (vpbs *VPageBreaks) Count() (int32, error)
- func (vpbs *VPageBreaks) Goxcel() *Goxcel
- func (vpbs *VPageBreaks) Item(index int) (*VPageBreak, error)
- func (vpbs *VPageBreaks) Releaser() *Releaser
- func (vpbs *VPageBreaks) Walk(walkFn func(hpb *VPageBreak) error) (*VPageBreak, error)
- type Window
- type Workbook
- func (w *Workbook) Close() error
- func (w *Workbook) ComObject() *ole.IDispatch
- func (w *Workbook) ExportAsFixedFormat(fmtType constants.XlFixedFormatType, path string) error
- func (w *Workbook) Goxcel() *Goxcel
- func (w *Workbook) MustSave()
- func (w *Workbook) MustSaveAs(filePath string)
- func (w *Workbook) MustSheets(index int) *Worksheet
- func (w *Workbook) MustWorkSheets() *Worksheets
- func (w *Workbook) PrintOut() error
- func (w *Workbook) Releaser() *Releaser
- func (w *Workbook) Save() error
- func (w *Workbook) SaveAs(filePath string) error
- func (w *Workbook) SaveAsWithFileFormat(filePath string, format constants.XlFileFormat) error
- func (w *Workbook) SetSaved(value bool) error
- func (w *Workbook) Sheets(index int) (*Worksheet, error)
- func (w *Workbook) WorkSheets() (*Worksheets, error)
- type Workbooks
- func (w *Workbooks) Add() (*Workbook, ReleaseFunc, error)
- func (w *Workbooks) ComObject() *ole.IDispatch
- func (w *Workbooks) Goxcel() *Goxcel
- func (w *Workbooks) MustAdd() (*Workbook, ReleaseFunc)
- func (w *Workbooks) MustOpen(filePath string) (*Workbook, ReleaseFunc)
- func (w *Workbooks) Open(filePath string) (*Workbook, ReleaseFunc, error)
- func (w *Workbooks) Releaser() *Releaser
- type Worksheet
- func (ws *Worksheet) Activate() error
- func (ws *Worksheet) AllRange() (*XlRange, error)
- func (ws *Worksheet) Cells(row int, col int) (*Cell, error)
- func (ws *Worksheet) Columns() (*XlRange, error)
- func (ws *Worksheet) ComObject() *ole.IDispatch
- func (ws *Worksheet) CopySheet(dest *Worksheet, after bool) error
- func (ws *Worksheet) ExportAsFixedFormat(fmtType constants.XlFixedFormatType, path string) error
- func (ws *Worksheet) Goxcel() *Goxcel
- func (ws *Worksheet) HPageBreaks() (*HPageBreaks, error)
- func (ws *Worksheet) HyperLinks() (*HyperLinks, error)
- func (ws *Worksheet) MaxCol(row int) (int32, error)
- func (ws *Worksheet) MaxRow(col int) (int32, error)
- func (ws *Worksheet) MaxRowCol(row, col int) (maxRow, maxCol int32, err error)
- func (ws *Worksheet) MustCells(row int, col int) *Cell
- func (ws *Worksheet) Name() (string, error)
- func (ws *Worksheet) PageSetup() (*PageSetup, error)
- func (ws *Worksheet) PrintOut() error
- func (ws *Worksheet) Range(startRow, startCol, endRow, endCol int) (*XlRange, error)
- func (ws *Worksheet) Releaser() *Releaser
- func (ws *Worksheet) ResetAllPageBreaks() error
- func (ws *Worksheet) Rows() (*XlRange, error)
- func (ws *Worksheet) SetName(name string) error
- func (ws *Worksheet) Shapes() (*Shapes, error)
- func (ws *Worksheet) UsedRange() (*XlRange, error)
- func (ws *Worksheet) VPageBreaks() (*VPageBreaks, error)
- type Worksheets
- func (w *Worksheets) Add() (*Worksheet, error)
- func (w *Worksheets) AddAfter(ws *Worksheet) (*Worksheet, error)
- func (w *Worksheets) AddBefore(ws *Worksheet) (*Worksheet, error)
- func (w *Worksheets) AddLast() (*Worksheet, error)
- func (w *Worksheets) ComObject() *ole.IDispatch
- func (w *Worksheets) Count() (int64, error)
- func (w *Worksheets) Goxcel() *Goxcel
- func (w *Worksheets) Item(index int) (*Worksheet, error)
- func (w *Worksheets) Releaser() *Releaser
- func (w *Worksheets) Walk(walkFn func(ws *Worksheet, index int) error) (*Worksheet, error)
- type XlRange
- func NewRange(ws *Worksheet, r *ole.IDispatch) *XlRange
- func NewRangeFromCell(cell *Cell, c *ole.IDispatch) *XlRange
- func NewRangeFromHPageBreak(hpb *HPageBreak, c *ole.IDispatch) *XlRange
- func NewRangeFromRange(ra *XlRange, c *ole.IDispatch) *XlRange
- func NewRangeFromShape(s *Shape, c *ole.IDispatch) *XlRange
- func NewRangeFromVPageBreak(vpb *VPageBreak, c *ole.IDispatch) *XlRange
- func NewRangeFromWorksheet(ws *Worksheet, c *ole.IDispatch) *XlRange
- func (r *XlRange) Cells(row int, col int) (*Cell, error)
- func (r *XlRange) Clear() error
- func (r *XlRange) Column() (int32, error)
- func (r *XlRange) Columns() (*XlRange, error)
- func (r *XlRange) ComObject() *ole.IDispatch
- func (r *XlRange) CopyPicture(appearance constants.XlPictureAppearance, format constants.XlCopyPictureFormat) error
- func (r *XlRange) CopyPictureToFile(writer io.Writer, appearance constants.XlPictureAppearance, ...) error
- func (r *XlRange) Count() (int32, error)
- func (r *XlRange) Font() (*Font, error)
- func (r *XlRange) Goxcel() *Goxcel
- func (r *XlRange) Interior() (*Interior, error)
- func (r *XlRange) MustSetValue(value any)
- func (r *XlRange) PageBreak(pageBreakType constants.XlPageBreak) error
- func (r *XlRange) Releaser() *Releaser
- func (r *XlRange) Row() (int32, error)
- func (r *XlRange) Rows() (*XlRange, error)
- func (r *XlRange) Select() error
- func (r *XlRange) SetNumberFormatLocal(format constants.NumberFormatLocal) error
- func (r *XlRange) SetValue(value interface{}) error
- func (r *XlRange) Value() (interface{}, error)
- func (r *XlRange) Walk(walkFn func(r *XlRange, c *Cell, row, col int) error) (*Cell, error)
Constants ¶
This section is empty.
Variables ¶
View Source
var ( ValueMustBeGreaterThanZero = errors.New("value must be greater than 0") ValueCantConvertToInt = errors.New("value can't convert to int type") ValueCantConvertToString = errors.New("value can't convert to string type") ValueCantConvertToBool = errors.New("value can't convert to bool type") )
View Source
var ( SkipRow = errors.New("skip row") SkipCol = errors.New("skip col") )
Functions ¶
func InitGoxcel ¶ added in v0.5.4
func InitGoxcel() (func(), error)
func MustInitGoxcel ¶ added in v0.5.15
func MustInitGoxcel() func()
func MustNewGoxcel ¶ added in v0.5.15
func MustNewGoxcel() (*Goxcel, ReleaseFunc)
func NewGoxcel ¶
func NewGoxcel() (*Goxcel, ReleaseFunc, error)
func NewWorkbook ¶
func NewWorkbook(wbs *Workbooks, wb *ole.IDispatch) (*Workbook, ReleaseFunc)
Types ¶
type Cell ¶
type Cell struct {
// contains filtered or unexported fields
}
func NewCellFromRange ¶ added in v0.4.0
func (*Cell) End ¶ added in v0.6.0
func (c *Cell) End(direction constants.XlDirection) (*XlRange, error)
func (*Cell) MustSetValue ¶ added in v0.5.16
func (c *Cell) MustSetValue(value interface{})
func (*Cell) PageBreak ¶ added in v0.6.4
func (c *Cell) PageBreak(pageBreakType constants.XlPageBreak) error
func (*Cell) SetNumberFormatLocal ¶ added in v0.5.2
func (c *Cell) SetNumberFormatLocal(format constants.NumberFormatLocal) error
type ComReleaser ¶ added in v0.4.0
type ComReleaser interface { HasReleaser HasComObject }
noinspection GoNameStartsWithPackageName
type Font ¶ added in v0.4.0
type Font struct {
// contains filtered or unexported fields
}
Font represents an Excel Font
REFERENCES::
func NewFontFromRange ¶ added in v0.4.0
func (*Font) SetStrikethrough ¶ added in v0.4.0
func (*Font) SetUnderline ¶ added in v0.4.0
func (f *Font) SetUnderline(value constants.XlUnderlineStyle) error
func (*Font) Strikethrough ¶ added in v0.4.0
type Goxcel ¶
type Goxcel struct {
// contains filtered or unexported fields
}
func (*Goxcel) ActiveSheet ¶
func (g *Goxcel) ActiveSheet() (*Worksheet, *Workbook, ReleaseFunc, error)
func (*Goxcel) ActiveWindow ¶
func (*Goxcel) ActiveWorkbook ¶
func (g *Goxcel) ActiveWorkbook() (*Workbook, ReleaseFunc, error)
func (*Goxcel) DisplayAlerts ¶ added in v0.5.10
func (*Goxcel) EnableEvents ¶ added in v0.5.10
func (*Goxcel) MustSetVisible ¶ added in v0.5.15
func (*Goxcel) MustSilent ¶ added in v0.5.15
func (*Goxcel) MustWorkbooks ¶ added in v0.5.15
func (*Goxcel) ScreenUpdating ¶ added in v0.5.10
func (*Goxcel) SetDisplayAlerts ¶
func (*Goxcel) SetEnableEvents ¶ added in v0.5.10
func (*Goxcel) SetScreenUpdating ¶ added in v0.5.10
func (*Goxcel) SetVisible ¶
type GoxcelObject ¶ added in v0.4.0
type GoxcelObject interface { HasGoxcel ComReleaser }
noinspection GoNameStartsWithPackageName
type HPageBreak ¶ added in v0.5.0
type HPageBreak struct {
// contains filtered or unexported fields
}
func NewHPageBreak ¶ added in v0.5.0
func NewHPageBreak(hpbs *HPageBreaks, comObj *ole.IDispatch) *HPageBreak
func (*HPageBreak) ComObject ¶ added in v0.5.0
func (hpb *HPageBreak) ComObject() *ole.IDispatch
func (*HPageBreak) Goxcel ¶ added in v0.5.0
func (hpb *HPageBreak) Goxcel() *Goxcel
func (*HPageBreak) Location ¶ added in v0.5.0
func (hpb *HPageBreak) Location() (*XlRange, error)
func (*HPageBreak) Releaser ¶ added in v0.5.0
func (hpb *HPageBreak) Releaser() *Releaser
func (*HPageBreak) SetLocation ¶ added in v0.5.0
func (hpb *HPageBreak) SetLocation(ra *XlRange) error
type HPageBreaks ¶ added in v0.5.0
type HPageBreaks struct {
// contains filtered or unexported fields
}
func NewHPageBreaks ¶ added in v0.5.0
func NewHPageBreaks(ws *Worksheet, comObj *ole.IDispatch) *HPageBreaks
func (*HPageBreaks) Add ¶ added in v0.5.0
func (hpbs *HPageBreaks) Add(ra *XlRange) error
func (*HPageBreaks) ComObject ¶ added in v0.5.0
func (hpbs *HPageBreaks) ComObject() *ole.IDispatch
func (*HPageBreaks) Count ¶ added in v0.5.0
func (hpbs *HPageBreaks) Count() (int32, error)
func (*HPageBreaks) Goxcel ¶ added in v0.5.0
func (hpbs *HPageBreaks) Goxcel() *Goxcel
func (*HPageBreaks) Item ¶ added in v0.5.0
func (hpbs *HPageBreaks) Item(index int) (*HPageBreak, error)
func (*HPageBreaks) Releaser ¶ added in v0.5.0
func (hpbs *HPageBreaks) Releaser() *Releaser
func (*HPageBreaks) Walk ¶ added in v0.5.0
func (hpbs *HPageBreaks) Walk(walkFn func(hpb *HPageBreak, index int) error) (*HPageBreak, error)
type HasComObject ¶
type HasComObject interface {
ComObject() *ole.IDispatch
}
noinspection GoNameStartsWithPackageName
type HasGoxcel ¶ added in v0.1.2
type HasGoxcel interface {
Goxcel() *Goxcel
}
noinspection GoNameStartsWithPackageName
type HasReleaser ¶ added in v0.1.3
type HasReleaser interface {
Releaser() *Releaser
}
noinspection GoNameStartsWithPackageName
type HyperLinks ¶ added in v0.6.8
type HyperLinks struct {
// contains filtered or unexported fields
}
func NewHyperLinks ¶ added in v0.6.8
func NewHyperLinks(ws *Worksheet, comObj *ole.IDispatch) *HyperLinks
func NewHyperLinksFromHyperLinks ¶ added in v0.6.8
func NewHyperLinksFromHyperLinks(hl *HyperLinks, comObj *ole.IDispatch) *HyperLinks
func (*HyperLinks) ComObject ¶ added in v0.6.8
func (hl *HyperLinks) ComObject() *ole.IDispatch
func (*HyperLinks) Count ¶ added in v0.6.8
func (hl *HyperLinks) Count() (int64, error)
func (*HyperLinks) Delete ¶ added in v0.6.8
func (hl *HyperLinks) Delete() error
func (*HyperLinks) Goxcel ¶ added in v0.6.8
func (hl *HyperLinks) Goxcel() *Goxcel
func (*HyperLinks) Item ¶ added in v0.6.8
func (hl *HyperLinks) Item(index int) (*HyperLinks, error)
func (*HyperLinks) Releaser ¶ added in v0.6.8
func (hl *HyperLinks) Releaser() *Releaser
type Interior ¶ added in v0.4.0
type Interior struct {
// contains filtered or unexported fields
}
func NewInterior ¶ added in v0.4.0
func NewInteriorFromRange ¶ added in v0.4.0
type PageSetup ¶
type PageSetup struct {
// contains filtered or unexported fields
}
func NewPageSetup ¶
func (*PageSetup) SetCenterFooter ¶
func (*PageSetup) SetCenterHeader ¶
func (*PageSetup) SetOrientation ¶
func (p *PageSetup) SetOrientation(value constants.XlPageOrientation) error
type ReleaseFunc ¶
type ReleaseFunc func()
type Releaser ¶
type Releaser struct {
// contains filtered or unexported fields
}
func NewReleaser ¶
func NewReleaser() *Releaser
type Shape ¶ added in v0.5.0
type Shape struct {
// contains filtered or unexported fields
}
func (*Shape) TopLeftCell ¶ added in v0.5.0
type Shapes ¶ added in v0.5.0
type Shapes struct {
// contains filtered or unexported fields
}
func NewShapesFromWorksheet ¶ added in v0.5.0
func (*Shapes) AddPicture ¶ added in v0.5.12
type VPageBreak ¶ added in v0.5.0
type VPageBreak struct {
// contains filtered or unexported fields
}
func NewVPageBreak ¶ added in v0.5.0
func NewVPageBreak(vpbs *VPageBreaks, comObj *ole.IDispatch) *VPageBreak
func (*VPageBreak) ComObject ¶ added in v0.5.0
func (vpb *VPageBreak) ComObject() *ole.IDispatch
func (*VPageBreak) Goxcel ¶ added in v0.5.0
func (vpb *VPageBreak) Goxcel() *Goxcel
func (*VPageBreak) Location ¶ added in v0.5.0
func (vpb *VPageBreak) Location() (*XlRange, error)
func (*VPageBreak) Releaser ¶ added in v0.5.0
func (vpb *VPageBreak) Releaser() *Releaser
func (*VPageBreak) SetLocation ¶ added in v0.5.0
func (vpb *VPageBreak) SetLocation(ra *XlRange) error
type VPageBreaks ¶ added in v0.5.0
type VPageBreaks struct {
// contains filtered or unexported fields
}
func NewVPageBreaks ¶ added in v0.5.0
func NewVPageBreaks(ws *Worksheet, comObj *ole.IDispatch) *VPageBreaks
func (*VPageBreaks) Add ¶ added in v0.5.0
func (vpbs *VPageBreaks) Add(ra *XlRange) error
func (*VPageBreaks) ComObject ¶ added in v0.5.0
func (vpbs *VPageBreaks) ComObject() *ole.IDispatch
func (*VPageBreaks) Count ¶ added in v0.5.0
func (vpbs *VPageBreaks) Count() (int32, error)
func (*VPageBreaks) Goxcel ¶ added in v0.5.0
func (vpbs *VPageBreaks) Goxcel() *Goxcel
func (*VPageBreaks) Item ¶ added in v0.5.0
func (vpbs *VPageBreaks) Item(index int) (*VPageBreak, error)
func (*VPageBreaks) Releaser ¶ added in v0.5.0
func (vpbs *VPageBreaks) Releaser() *Releaser
func (*VPageBreaks) Walk ¶ added in v0.5.0
func (vpbs *VPageBreaks) Walk(walkFn func(hpb *VPageBreak) error) (*VPageBreak, error)
type Workbook ¶
type Workbook struct {
// contains filtered or unexported fields
}
func (*Workbook) ExportAsFixedFormat ¶ added in v0.6.3
func (w *Workbook) ExportAsFixedFormat(fmtType constants.XlFixedFormatType, path string) error
func (*Workbook) MustSaveAs ¶ added in v0.6.9
func (*Workbook) MustSheets ¶ added in v0.5.15
func (*Workbook) MustWorkSheets ¶ added in v0.5.16
func (w *Workbook) MustWorkSheets() *Worksheets
func (*Workbook) SaveAsWithFileFormat ¶
func (w *Workbook) SaveAsWithFileFormat(filePath string, format constants.XlFileFormat) error
func (*Workbook) WorkSheets ¶
func (w *Workbook) WorkSheets() (*Worksheets, error)
type Workbooks ¶
type Workbooks struct {
// contains filtered or unexported fields
}
func NewWorkbooks ¶
func (*Workbooks) MustAdd ¶ added in v0.5.15
func (w *Workbooks) MustAdd() (*Workbook, ReleaseFunc)
type Worksheet ¶
type Worksheet struct {
// contains filtered or unexported fields
}
func NewWorksheet ¶
func NewWorksheetFromWorksheets ¶ added in v0.4.0
func NewWorksheetFromWorksheets(ws *Worksheets, comObj *ole.IDispatch) *Worksheet
func (*Worksheet) ExportAsFixedFormat ¶ added in v0.5.14
func (ws *Worksheet) ExportAsFixedFormat(fmtType constants.XlFixedFormatType, path string) error
func (*Worksheet) HPageBreaks ¶ added in v0.5.0
func (ws *Worksheet) HPageBreaks() (*HPageBreaks, error)
func (*Worksheet) HyperLinks ¶ added in v0.6.8
func (ws *Worksheet) HyperLinks() (*HyperLinks, error)
func (*Worksheet) ResetAllPageBreaks ¶ added in v0.6.4
func (*Worksheet) VPageBreaks ¶ added in v0.5.0
func (ws *Worksheet) VPageBreaks() (*VPageBreaks, error)
type Worksheets ¶
type Worksheets struct {
// contains filtered or unexported fields
}
func NewWorkSheets ¶
func NewWorkSheets(wb *Workbook, wss *ole.IDispatch) *Worksheets
func (*Worksheets) Add ¶
func (w *Worksheets) Add() (*Worksheet, error)
func (*Worksheets) AddAfter ¶ added in v0.5.1
func (w *Worksheets) AddAfter(ws *Worksheet) (*Worksheet, error)
func (*Worksheets) AddBefore ¶ added in v0.5.1
func (w *Worksheets) AddBefore(ws *Worksheet) (*Worksheet, error)
func (*Worksheets) AddLast ¶ added in v0.5.1
func (w *Worksheets) AddLast() (*Worksheet, error)
func (*Worksheets) ComObject ¶
func (w *Worksheets) ComObject() *ole.IDispatch
func (*Worksheets) Count ¶
func (w *Worksheets) Count() (int64, error)
func (*Worksheets) Goxcel ¶ added in v0.1.2
func (w *Worksheets) Goxcel() *Goxcel
func (*Worksheets) Releaser ¶ added in v0.1.3
func (w *Worksheets) Releaser() *Releaser
type XlRange ¶ added in v0.1.4
type XlRange struct {
// contains filtered or unexported fields
}
func NewRangeFromCell ¶ added in v0.6.0
func NewRangeFromHPageBreak ¶ added in v0.5.0
func NewRangeFromHPageBreak(hpb *HPageBreak, c *ole.IDispatch) *XlRange
func NewRangeFromRange ¶ added in v0.4.0
func NewRangeFromShape ¶ added in v0.5.0
func NewRangeFromVPageBreak ¶ added in v0.5.0
func NewRangeFromVPageBreak(vpb *VPageBreak, c *ole.IDispatch) *XlRange
func NewRangeFromWorksheet ¶ added in v0.6.4
func (*XlRange) CopyPicture ¶ added in v0.6.5
func (r *XlRange) CopyPicture(appearance constants.XlPictureAppearance, format constants.XlCopyPictureFormat) error
func (*XlRange) CopyPictureToFile ¶ added in v0.6.5
func (r *XlRange) CopyPictureToFile(writer io.Writer, appearance constants.XlPictureAppearance, format constants.XlCopyPictureFormat) error
func (*XlRange) MustSetValue ¶ added in v0.6.4
func (*XlRange) PageBreak ¶ added in v0.6.4
func (r *XlRange) PageBreak(pageBreakType constants.XlPageBreak) error
func (*XlRange) SetNumberFormatLocal ¶ added in v0.5.2
func (r *XlRange) SetNumberFormatLocal(format constants.NumberFormatLocal) error
Source Files ¶
Directories ¶
Path | Synopsis |
---|---|
Package constants パッケージには、Visual Basic の Excel列挙体の一覧が定義されています。
|
Package constants パッケージには、Visual Basic の Excel列挙体の一覧が定義されています。 |
examples
|
|
Click to show internal directories.
Click to hide internal directories.