XlsxDocumentSheet Class Members

In This Topic

The following tables list the members exposed by XlsxDocumentSheet.

Public Fields

	Name	Description
	Tab	A string that represents tab. (Inherited from OpenXmlDocumentElement)
	TextBreak	A string that represents text break. (Inherited from OpenXmlDocumentElement)

Public Properties

	Name	Description
	ChildCount	Gets the child count. (Inherited from OpenXmlDocumentElement)
	ChildElements	Gets the collection that contains all child nodes of this element. (Inherited from OpenXmlDocumentElement)
	ColumnCount	Gets the column count. (Inherited from OpenXmlDocumentTable)
	Drawing	Gets the sheet drawing.
	Format	Gets the sheet format.
	HasChildren	Gets a value indicating whether this element has child elements. (Inherited from OpenXmlDocumentElement)
	HasContent	Gets a value indicating whether this element has content. (Inherited from OpenXmlDocumentElement)
	HasText	Gets a value indicating whether this element has text. (Inherited from OpenXmlDocumentElement)
	Hyperlinks	Gets all hyperlinks, which are located on this sheet.
	Images	Gets all images, which are contained on this sheet.
	MergedCells	Gets all merged cells, which are located on this sheet.
	Name	Gets or sets the sheet name.
	Next	Gets the next element of current level in OpenXML document. (Inherited from OpenXmlDocumentElement)
	Parent	Gets the parent element of this element. (Inherited from OpenXmlDocumentElement)
	Prev	Gets the previous element of current level in OpenXML document. (Inherited from OpenXmlDocumentElement)
	Root	Gets the root element of this element. (Inherited from OpenXmlDocumentElement)
	RowCount	Gets the row count. (Inherited from OpenXmlDocumentTable)
	Text	Gets or sets text, which is associated with this element. (Inherited from OpenXmlDocumentElement)
	Item	Gets the table row at the specified index. (Inherited from OpenXmlDocumentTable)
	View	Gets the sheet view.

Public Methods

	Name	Description
	AddChart	Adds a chart to the worksheet.
	AddImage	Overloaded. Adds an image to the worksheet.
	Append	Overloaded. Appends the specified content to the children of this element. (Inherited from OpenXmlDocumentElement)
	ClearCachedCellValues	Removes cached values of formulas calculation for all cells.
	ClearCellsContents	Removes values and formulas of cells.
	Clone	Clones this element.
	Contains	Returns a value indicating whether this element contains the text. (Inherited from OpenXmlDocumentElement)
	FindAfter<T>	Finds the first element of specified type after this element. (Inherited from OpenXmlDocumentElement)
	FindBefore<T>	Finds the first element of specified type before this element. (Inherited from OpenXmlDocumentElement)
	FindCell	Overloaded. Returns the first table cell that contains specified text. (Inherited from OpenXmlDocumentTable)
	FindCellByName	Finds the table cell by name (reference) in A1 format.
	FindImages	Finds images, which are intersected with specified row.
	FindRow	Overloaded. Tries to get row at specified row index.
	FindText	Finds the specified text. (Inherited from OpenXmlDocumentElement)
	FindTextNext	Finds the specified text at specified index. (Inherited from OpenXmlDocumentElement)
	GetCell	Returns the table cell at specified location in sheet.
	GetColumnIsHidden	Returns a value indicating whether column is hidden.
	GetColumnStyleIndex	Returns the style index of the column.
	GetColumnWidth	Returns the column width.
	GetEnumerator	Returns an enumerator that iterates through the collection. (Inherited from OpenXmlDocumentElement)
	GetFirstChild<T>	Returns the first child (of specified type) of this element. (Inherited from OpenXmlDocumentElement)
	GetLastChild<T>	Returns the last child (of specified type) of this element. (Inherited from OpenXmlDocumentElement)
	GetParent<T>	Returns the parent (of specified type) of this element. (Inherited from OpenXmlDocumentElement)
	GetRow	Returns the row at specified row index.
	GetTextContent	Overloaded. Returns the text content by specified source. (Inherited from OpenXmlDocumentElement)
	GetTextProperties	Returns the text properties. (Inherited from OpenXmlDocumentElement)
	GetTextSubregion	Returns text subregion that corresponds to this element in specified text region. (Inherited from OpenXmlDocumentElement)
	InsertColumns	Inserts the columns to the sheet.
	InsertCopyAfterSelf	Inserts a copy of this element after this element. (Inherited from OpenXmlDocumentElement)
	InsertCopyBeforeSelf	Inserts a copy of this element before this element. (Inherited from OpenXmlDocumentElement)
	InsertRows	Inserts the rows to the sheet.
	MoveComment	Moves the comment.
	Remove	This method is not supported.
	RemoveAllChildren	Removes all children of this element. (Inherited from OpenXmlDocumentElement)
	RemoveColumns	Removes the columns from sheet.
	RemoveComment	Removes the cell comment.
	RemoveRows	Removes the rows from sheet.
	ReplaceText	Replaces all occurrences of specified string in Text. (Inherited from OpenXmlDocumentElement)
	Select<T>	Selects all child elements of specified type. (Inherited from OpenXmlDocumentElement)
	SetColumnsIsHidden	Sets the visibility status of columns.
	SetColumnsStyleIndex	Sets the style index of columns.
	SetColumnsWidth	Sets the width of columns.
	SetComment	Sets the cell comment.
	SetCommentIsVisible	Sets the visibility status of comment.
	SetCommentLocation	Sets the comment location.
	SetFillColor	Sets the fill color of this element. (Inherited from OpenXmlDocumentElement)
	SetOutsideBorder	Overloaded. Sets the outside border of this table. (Inherited from OpenXmlDocumentTable)
	SetTextProperties	Overloaded. Sets the text properties. (Inherited from OpenXmlDocumentElement)
	ToString	Converts this element to a string. (Inherited from OpenXmlDocumentElement)

Reference

XlsxDocumentSheet Class
Vintasoft.Imaging.Office.OpenXml.Editor.Xlsx Namespace

Send Feedback