org.pentaho.di.trans.steps.excelinput.staxpoi

Class StaxUtil

java.lang.Object

org.pentaho.di.trans.steps.excelinput.staxpoi.StaxUtil

public class StaxUtil
extends Object

Constructor Summary

Constructors

Constructor and Description
StaxUtil()

Method Summary

Methods

Modifier and Type	Method and Description
static int	extractColumnNumber(String position)
static int	extractRowNumber(String position)
static int	parseColumnNumber(String columnIndicator) Convert the column indicator in Excel like A, B, C, AE, CX and so on to a 1-based column number.

Methods inherited from class java.lang.Object

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

Constructor Detail

StaxUtil

public StaxUtil()

Method Detail

extractRowNumber

public static int extractRowNumber(String position)

extractColumnNumber

public static int extractColumnNumber(String position)

parseColumnNumber

public static final int parseColumnNumber(String columnIndicator)

Convert the column indicator in Excel like A, B, C, AE, CX and so on to a 1-based column number.

Parameters:

columnIndicator - The indicator to convert

Returns:

The 1-based column number