PicoXLSX Library Documentation
PicoXLSX
PicoXLSX
Worksheet Class
Worksheet Methods
AddAllowedActionOnSheetProtection Method
AddCell Method
AddCellFormula Method
AddCellRange Method
AddCellRangeInternal<T> Method
AddHiddenColumn Method
AddHiddenRow Method
AddNextCell Method
AddNextCellFormula Method
AddSelectedCells Method
CastValue Method
CellsByValue Method
ClearActiveStyle Method
Copy Method
FirstCellByValue Method
FirstOrDefaultCell Method
GetBoundaryDataNumber Method
GetBoundaryNumber Method
GetCell Method
GetColumn Method
GetCurrentColumnNumber Method
GetCurrentRowNumber Method
GetFirstCellAddress Method
GetFirstColumnNumber Method
GetFirstDataCellAddress Method
GetFirstDataColumnNumber Method
GetFirstDataRowNumber Method
GetFirstRowNumber Method
GetLastCellAddress Method
GetLastColumnNumber Method
GetLastDataCellAddress Method
GetLastDataColumnNumber Method
GetLastDataRowNumber Method
GetLastRowNumber Method
GetMaxRow Method
GetMinRow Method
GetRow Method
GetUnusedWorksheetName Method
GoToNextColumn Method
GoToNextRow Method
HasCell Method
InsertColumn Method
InsertRow Method
MergeCells Method
RecalculateAutoFilter Method
RecalculateColumns Method
RemoveAllowedActionOnSheetProtection Method
RemoveAutoFilter Method
RemoveCell Method
RemoveHiddenColumn Method
RemoveHiddenRow Method
RemoveMergedCells Method
RemoveRowHeight Method
RemoveSelectedCells Method
ReplaceCellValue Method
ResetColumn Method
ResetSplit Method
ResolveMergedCells Method
SanitizeWorksheetName Method
SetActiveStyle Method
SetAutoFilter Method
SetColumnDefaultStyle Method
SetColumnHiddenState Method
SetColumnWidth Method
SetCurrentCellAddress Method
SetCurrentColumnNumber Method
SetCurrentRowNumber Method
SetHorizontalSplit Method
SetRowHeight Method
SetRowHiddenState Method
SetSelectedCells Method
SetSheetName Method
SetSheetProtectionPassword Method
SetSplit Method
SetStyle Method
SetVerticalSplit Method
SetZoomFactor Method
WorksheetExists Method
Click or drag to resize
PicoXLSX

WorksheetGetBoundaryDataNumber Method

Gets either the minimum or maximum row or column number, considering only calls with data

Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.2+f55916d49ef2baa43fc7dc8f5c7d751a77c50baf
Syntax
C#
Copy
private int GetBoundaryDataNumber(
	bool row,
	bool min,
	bool ignoreEmpty
)

Parameters

row  Boolean
If true, the min or max row is returned, otherwise the column.
min  Boolean
If true, the min value of the row or column is defined, otherwise the max value.
ignoreEmpty  Boolean
If true, empty cell values are ignored, otherwise considered without checking the content.

Return Value

Int32
Min or max number, or -1 if not defined.
See Also