Package ortus.boxlang.spreadsheet.bifs

Class SpreadsheetGetLastRowNumber

java.lang.Object
ortus.boxlang.runtime.bifs.BIF
ortus.boxlang.spreadsheet.bifs.SpreadsheetGetLastRowNumber
@BoxBIF(description="Retrieves the row number of the last row with data in a spreadsheet.") public class SpreadsheetGetLastRowNumber extends ortus.boxlang.runtime.bifs.BIF

  • Field Summary

    Fields inherited from class ortus.boxlang.runtime.bifs.BIF

    __functionName, __isMemberExecution, asyncService, cacheService, componentService, declaredArguments, functionService, interceptorService, logger, moduleService, runtime, schedulerService

  • Constructor Summary

    Constructors
    Constructor
    Description
    SpreadsheetGetLastRowNumber()
    Constructor

  • Method Summary

    Modifier and Type
    Method
    Description
    Object
    _invoke(ortus.boxlang.runtime.context.IBoxContext context, ortus.boxlang.runtime.scopes.ArgumentsScope arguments)
    Retrieves the row number of the last row with data in the active sheet.

    Methods inherited from class ortus.boxlang.runtime.bifs.BIF

    announce, getDeclaredArguments, invoke

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Constructor Details

    • SpreadsheetGetLastRowNumber

      public SpreadsheetGetLastRowNumber()
      Constructor

  • Method Details

    • _invoke

      public Object _invoke(ortus.boxlang.runtime.context.IBoxContext context, ortus.boxlang.runtime.scopes.ArgumentsScope arguments)
      Retrieves the row number of the last row with data in the active sheet.
      Specified by:
      _invoke in class ortus.boxlang.runtime.bifs.BIF
      Parameters:
      context - The context in which the BIF is being invoked.
      arguments - Argument scope for the BIF.
      Returns:
      The last row number (1-based), or 0 if sheet is empty