String return textual version of bounds

Add adds a new ref into the BoundsList

CellByRef returns a cell for ref

New creates and returns Info object with requested options

New create and return ml.Color type for provided value, respecting built-in indexed colors

Normalize check if color in #RGB format and convert it into ARGB format

Cell returns a cell for 0-based indexes

nolint SetValue sets a value

Close frees allocated by sheet resources

Values returns values for all cells in range

Value returns current raw value of cell

Sheet returns a sheet by 0-based index with required open mode options

New creates and returns a new Info object that holds settings for hyperlink and related styles

Open opens a XLSX file with name or io.Reader

Hash builds hash code for all required values of Fill to use as unique index

Dimension returns total number of cols and rows in sheet

Add adds a new custom filter info for column with 0-based colIndex

Row returns a row for 0-based index

AddSheet adds a new sheet with name to document

Col returns a col for 0-based index

Set sets new options for hyperlink

BoundsFromIndexes returns a Bounds information for provided 0-based indexes

String returns text version of hyperlink info

ToFile sets target to external file

nolint private method used by stylesheet manager to unpack Info

New creates and returns a new XLSX document

Overlaps checks if bounds intersects with another bounds

AddStyles adds a new style formatting to document and return related ID that can be used lately

HasNext returns true if there are cols to iterate or false in other case

Next returns next Col in sheet and corresponding index

ToIndexes returns 0-based indexes of reference

Walk calls callback cb for each Cell in range

Get returns a resolved comment info for provided ref or nil if there is no any comment

RangeByRef returns a range for ref

SetStyles sets default style for the row. Affects cells not yet allocated in the row. In other words, this style applies to new cells.

ToBounds returns related bounds of Ref

CellRefFromIndexes is alias of original primitives.CellRefFromIndexes to make it public

Name returns name of sheet

String returns formatted value as string respecting cell number format and type. Any errors ignored to conform String() interface.

Type returns current type of cell

isCellEmpty checks if cell is empty - has no value and any formatting

Set sets new options for style

Set sets options for sheet

SetText sets shared rich text

ToBookmark sets target to bookmark, that can be named region in xlsx, bookmark of remote file or even site

expandIfRequired expands grid to required dimension

CellRefFromIndexes returns a CellRef for 0-based indexes

Contains checks if indexes cIdx and rIdx are inside of bounds

Remove removes filter info for column with 0-based colIndex

ToRef sets target to ref of sheet with sheetName. Omit sheetName to set location to ref of active sheet

ToUrl sets target to web site

private methods to use by internals only

IsEmpty return true if type was not initialized

OptionalBool is helper function that allow encode/decode optional boolean, where false should not be omitted - mostly for booleans with default true v

Rows returns iterator for all rows of sheet

ToMail sets target to email

isRowEmpty checks if row is empty (supposed that only non empty cells here) - has no cells

nolint

nolint

BoundsFromIndexes is alias of original primitives.BoundsFromIndexes to make it public

InsertCol inserts a col at 0-based index and returns it. Using to insert a col between other cols.

InsertRow inserts a row at 0-based index and returns it. Using to insert a row between other rows.

IsAllowed check if type is in list of allowed types

SetInt sets an signed integer value

SheetNames returns a names of all sheets

Bool try to convert and return current raw value as bool

Float try to convert and return current raw value as float64

Int try to convert and return current raw value as signed integer

Merge merges range

New creates and returns Info object with requested options

ToBool tries to convert string into bool type

IsBuiltIn returns true if id is one of built-in

New create and return ml.NumberFormat type for provided values, respecting built-in number formats

NumberFormatID is option to update Info with provided id of already existing or built-in number format

RefFromIndexes is alias of original primitives.RefFromIndexes to make it public