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

Field Summary

Fields

Modifier and Type	Field and Description
static int	MAX_COLUMNS
static int	MAX_ROWS

Constructor Summary

Constructors

Constructor and Description
StaxUtil()

Method Summary

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

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

Field Detail

MAX_ROWS

public static final int MAX_ROWS

MAX_COLUMNS

public static final int MAX_COLUMNS

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