MCPcopy Create free account

hub / github.com/plandem/xlsx / functions

Functions811 in github.com/plandem/xlsx

MethodDeleteFilter
DeleteFilter deletes a filter from column with index
sheet_info.go:240
MethodDeleteFilter
DeleteFilter deletes a filter from column with 0-based colIndex
sheet.go:76
MethodDeleteFilter
(colIndex int)
sheet_readstream.go:329
MethodDeleteFilter
(colIndex int)
sheet_writestream.go:249
MethodDeleteRow
DeleteRow deletes a row at 0-based index
sheet_readwrite.go:119
MethodDeleteRow
(index int)
sheet_readstream.go:273
MethodDeleteRow
(index int)
sheet_writestream.go:193
MethodDiagonalDown
(s *Info)
format/styles/border.go:37
MethodDiagonalUp
(s *Info)
format/styles/border.go:33
MethodDimension
Dimension returns total number of cols and rows in sheet
sheet_info.go:173
MethodDimension
Dimension returns total number of cols and rows in bounds
internal/ml/primitives/bounds.go:67
MethodEndsWith
(s string, settings ...interface{})
format/conditional/rule/text.go:68
MethodEqualOrAbove
(s *styles.Info)
format/conditional/rule/average.go:37
MethodEqualOrBelow
(s *styles.Info)
format/conditional/rule/average.go:53
FunctionExample
()
docs/src/code/demo_test.go:10
FunctionExample_access
Demonstrates how to access differ information
example_test.go:58
FunctionExample_append
Demonstrates how to append cols/rows/sheets.
example_test.go:362
FunctionExample_comments
()
docs/src/code/comments_test.go:9
FunctionExample_copy
Demonstrates how to copy information in sheet
example_test.go:509
FunctionExample_delete
Demonstrates how to delete information
example_test.go:439
FunctionExample_files
Demonstrates how to create/open/save XLSX files
example_test.go:21
FunctionExample_formatting
Demonstrates how to add style formatting
example_test.go:285
FunctionExample_gettersAndSetters
Demonstrates how to get/set value for cell
example_test.go:582
FunctionExample_hyperlinks
()
docs/src/code/hyperlinks_test.go:9
FunctionExample_insert
Demonstrates how to insert cols/rows
example_test.go:400
FunctionExample_iterate
Demonstrates how to iterate
example_test.go:108
FunctionExample_mergedCells
()
docs/src/code/merged_cells_test.go:8
FunctionExample_options
Demonstrates how to set options of rows/cols/sheets
example_test.go:322
FunctionExample_readStream
()
docs/src/code/stream_read_test.go:8
FunctionExample_richText
()
docs/src/code/rich_text_test.go:9
FunctionExample_streams
Demonstrates how to open sheet in streaming mode
example_test.go:481
FunctionExample_stylesFont
()
docs/src/code/styles_font_test.go:7
FunctionExample_update
Demonstrates how to update information
example_test.go:233
FunctionExample_walk
Demonstrate walk cells using callback
example_test.go:189
FunctionExample_writeStream
()
docs/src/code/stream_write_test.go:8
MethodExpression
(formula string, settings ...interface{})
format/conditional/rule/formula.go:31
MethodExtend
(s *Info)
format/styles/font.go:60
FunctionFormat
Format tries to format value into required format code
internal/number_format/types.go:96
MethodGet
Get returns a resolved hyperlink info for provided ref or nil if there is no any hyperlink
hyperlinks.go:119
MethodGreater
(value interface{}, s *styles.Info)
format/conditional/rule/value.go:139
MethodGreaterOrEqual
(value interface{}, s *styles.Info)
format/conditional/rule/value.go:151
MethodHasFormula
HasFormula returns true if cell has formula
cell.go:308
MethodHasNext
HasNext returns true if there are cells to iterate or false in other case
range_iterator.go:13
MethodHasNext
HasNext returns true if there are cells to iterate or false in other case
range_iterator.go:47
MethodHasNext
HasNext returns true if there are cols to iterate or false in other case
col_iterator.go:41
MethodHasNext
HasNext returns true if there are rows to iterate or false in other case
row_iterator.go:13
MethodHasNext
HasNext returns true if there are rows to iterate or false in other case
row_iterator.go:41
MethodHasNext
HasNext returns true if there are sheets to iterate or false in other case
sheet_iterator.go:13
MethodHasNext
HasNext returns true if there are sheets to iterate or false in other case
sheet_iterator.go:40
MethodHash
Hash builds hash code for all required values of CellAlignment to use as unique index
internal/ml/hash.go:14
MethodHash
Hash builds hash code for all required values of Color to use as unique index
internal/ml/hash.go:34
MethodHash
Hash builds hash code for all required values of Font to use as unique index
internal/ml/hash.go:170
MethodHash
Hash builds hash code for all required values of NumberFormat to use as unique index
internal/ml/hash.go:195
MethodHash
Hash builds hash code for all required values of CellProtection to use as unique index
internal/ml/hash.go:208
MethodHash
Hash builds hash code for all required values of StringItem to use as unique index
internal/ml/hash.go:221
MethodHash
Hash builds hash code for all required values of NamedStyle to use as unique index
internal/ml/hash.go:253
MethodHash
Hash builds hash code for all required values of DirectStyle to use as unique index
internal/ml/hash.go:279
MethodHash
Hash builds hash code for all required values of DiffStyle to use as unique index
internal/ml/hash.go:290
MethodHash
Hash builds hash code for all required values of Text to use as unique index
internal/ml/primitives/text.go:19
MethodHash
Hash builds hash code for all required values of Bounds to use as unique index
internal/ml/primitives/bounds.go:92
MethodHyperlink
Hyperlink returns resolved hyperlink.Info if there is any hyperlink or nil otherwise
cell.go:329
MethodIconsOnly
(r *Info)
format/conditional/rule/icon_set.go:78
MethodInsertCol
InsertCol inserts a col at 0-based index and returns it. Using to insert a col between other cols.
sheet_readwrite.go:145
MethodInsertCol
(index int)
sheet_readstream.go:265
MethodInsertCol
(index int)
sheet_writestream.go:185
MethodInsertRow
InsertRow inserts a row at 0-based index and returns it. Using to insert a row between other rows.
sheet_readwrite.go:99
MethodInsertRow
(index int)
sheet_readstream.go:269
MethodInsertRow
(index int)
sheet_writestream.go:189
MethodIsValid
IsValid validates document and return error if there is any error. Using right before saving.
spreadsheet.go:175
MethodItalic
(s *Info)
format/styles/font.go:36
MethodJustifyLastLine
(s *Info)
format/styles/alignment.go:50
MethodLast7Days
(s *styles.Info)
format/conditional/rule/time_period.go:55
MethodLastMonth
(s *styles.Info)
format/conditional/rule/time_period.go:85
MethodLastWeek
(s *styles.Info)
format/conditional/rule/time_period.go:67
MethodLess
(value interface{}, s *styles.Info)
format/conditional/rule/value.go:145
MethodLessOrEqual
(value interface{}, s *styles.Info)
format/conditional/rule/value.go:157
MethodLocked
(s *Info)
format/styles/protection.go:16
MethodMarshalXML
MarshalXML marshal DiffStyleList
internal/ml/marshal.go:88
MethodMarshalXML
MarshalXML marshal NamedStyleInfoList
internal/ml/marshal.go:97
MethodMarshalXML
MarshalXML marshal DirectStyleList
internal/ml/marshal.go:106
MethodMarshalXML
MarshalXML marshal NamedStyleList
internal/ml/marshal.go:115
MethodMarshalXML
MarshalXML marshal BorderList
internal/ml/marshal.go:124
MethodMarshalXML
MarshalXML marshal FontList
internal/ml/marshal.go:133
MethodMarshalXML
MarshalXML marshal FillList
internal/ml/marshal.go:142
MethodMarshalXML
MarshalXML marshal NumberFormatList
internal/ml/marshal.go:151
MethodMarshalXML
MarshalXML marshal HyperlinkList
internal/ml/marshal.go:160
MethodMarshalXML
MarshalXML marshal MergedCellList
internal/ml/marshal.go:169
MethodMarshalXML
MarshalXML marshal SheetViewList
internal/ml/marshal.go:178
MethodMarshalXML
MarshalXML marshal BookViewList
internal/ml/marshal.go:187
MethodMarshalXML
MarshalXML marshal ExternalReferenceList
internal/ml/marshal.go:196
MethodMarshalXML
MarshalXML marshal AutoFilter
internal/ml/marshal.go:205
MethodMarshalXML
MarshalXML marshal ColList
internal/ml/columns.go:86
MethodMarshalXML
MarshalXML marshal UnderlineType
internal/ml/primitives/font_underline.go:16
MethodMarshalXML
MarshalXML marshal FontEffectType
internal/ml/primitives/font_effect.go:23
MethodMarshalXML
MarshalXML marshal FontCharsetType
internal/ml/primitives/font_charset.go:16
MethodMarshalXML
MarshalXML marshal Text
internal/ml/primitives/text.go:24
MethodMarshalXML
MarshalXML marshal FontFamilyType
internal/ml/primitives/font_family.go:16
MethodMarshalXML
MarshalXML marshal FontSchemeType
internal/ml/primitives/font_scheme.go:16
MethodMarshalXMLAttr
MarshalXMLAttr marshal HAlignType
internal/ml/primitives/align_h.go:25
MethodMarshalXMLAttr
MarshalXMLAttr marshal TimePeriodType
internal/ml/primitives/time_period.go:60
← previousnext →401–500 of 811, ranked by callers