Resolve looks through built-in number formats and return related if there is any

SetUint sets an unsigned integer value

Split splits cells in range

ToFloat tries to convert string into float64 type

ToInt tries to convert string into int type

addString adds a new string and return index for it

newRange create and returns Range for requested 0-based indexes

setDate is a general setter for date types

Cells returns iterator for all cells in range

ContainsRef checks if celRef is inside of bounds

Date try to convert and return current raw value as time.Time

IsEmail check if the str is an email

NumberFormat is option to update Info with provided custom format of number, but respecting built-in number formats

Range returns a range for indexes

RefFromCellRefs returns Ref for from/to CellRefs

SetFloat sets a float value

Styles sets style format to requested DirectStyleID or styles.Info

ToDate tries to convert string into time.Time type

addText adds a new StringItem and return index for it

get returns string item stored at index

CopyTo copies row cells into another row with rIdx index. N.B.: Merged cells are not supported

Equals checks if bounds is same as other bounds

IsMailTo check if the str is an mailto format

IsURL check if the str is an URL

SetBool sets a bool value

SetStyles sets style format to requested DirectStyleID or styles.Info

ToCellRefs returns from/to CellRef of Ref

ToRefList returns refs. Alias of String() method

* ToTarget is very close to HYPERLINK function of Excel https://support.office.com/en-us/article/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f5

adds a style. Style can be Direct or Named. Depends on settings.

adds a number formats for each type of number format if required. These styles will be used by cell's typed SetXXX methods

go:linkname fromRule github.com/plandem/xlsx/format/conditional/rule.fromRule

resolveDimension check if there is a 'dimension' information(optional) and if there is no any, then calculate it from existing data

Add adds a new comment info for bounds

AddRule adds another rule to conditional formatting

BoundsListFromRefs returns BoundsList for provided refs

Cols returns iterator for all cols of sheet

CopyToRef copies range cells into another range starting with ref. N.B.: Merged cells are not supported

DeleteCol deletes a col at 0-based index

DeleteRow deletes a row at 0-based index

Display adds a display information for hyperlink

Hidden sets flag indicating if the affected column are hidden on this worksheet.

Hidden sets flag indicating if the affected row are hidden on this worksheet.

IsFilePath check is a str is Win or Unix file

IsWinPath check is a str is Win file

New create and returns option set for column

New create and returns option set for row

New create and returns option set for comment

OptionalIndex is helper alias for ml.OptionalIndex from core package

OutlineLevel sets outline level of affected column. Range is 0 to 7.

OutlineLevel set outlining level of the row, when outlining is on.

Phonetic sets flag indicating if the phonetic information should be displayed by default for the affected column of the worksheet.

Phonetic sets flag indicating if the phonetic information should be displayed by default for the affected row of the worksheet.

RefFromIndexes returns Ref for a CellRef of 0-based indexes

Reset resets current current cell information

SetActive sets the sheet as active

SetComment sets comment for cell, where comment can be string or comment.Info

SetDateTime sets a time value with number format for datetime

SetHyperlink sets hyperlink for cell, where link can be string or hyperlink.Info

SetInlineText sets inline rich text

SetValueWithFormat is helper function that internally works as SetValue and SetStyles with NumberFormat

String return textual version of BoundsList

Styles returns DirectStyleID of default format for row

Text sets rich text of comment

ToBoundsList returns related bounds of RefList

ToRef returns reference of bounds. Alias of String() method

ToRefs returns refs of RefList

Tooltip adds a tooltip information for hyperlink

afterCreate initializes a new sheet

afterOpen is callback that will be called right after requesting an already existing sheet. By default, it does nothing

only attach files, no content is loading

build author and comment indexes