Package tech.tablesaw.io.xlsx

Class XlsxReadOptions.Builder

java.lang.Object

tech.tablesaw.io.xlsx.XlsxReadOptions.Builder

Enclosing class:

XlsxReadOptions

public static class XlsxReadOptions.Builder
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
protected Integer	sheetIndex

Constructor Summary

Constructors

Modifier	Constructor	Description
	Builder(File file)
	Builder(InputStream stream)
	Builder(Reader reader)
protected	Builder(URL url)
protected	Builder(tech.tablesaw.io.Source source)

Method Summary

Modifier and Type	Method	Description
XlsxReadOptions	build()
XlsxReadOptions.Builder	columnTypes(Function<String,tech.tablesaw.api.ColumnType> columnTypeFunction)
XlsxReadOptions.Builder	columnTypes(tech.tablesaw.api.ColumnType[] columnTypes)
XlsxReadOptions.Builder	columnTypesPartial(Function<String,Optional<tech.tablesaw.api.ColumnType>> columnTypeFunction)
XlsxReadOptions.Builder	columnTypesPartial(Map<String,tech.tablesaw.api.ColumnType> columnTypeByName)
XlsxReadOptions.Builder	dateFormat(String dateFormat)	Deprecated.
XlsxReadOptions.Builder	dateFormat(DateTimeFormatter dateFormat)
XlsxReadOptions.Builder	dateTimeFormat(String dateTimeFormat)	Deprecated.
XlsxReadOptions.Builder	dateTimeFormat(DateTimeFormatter dateTimeFormat)
XlsxReadOptions.Builder	header(boolean header)
XlsxReadOptions.Builder	locale(Locale locale)
XlsxReadOptions.Builder	minimizeColumnSizes()
XlsxReadOptions.Builder	missingValueIndicator(String... missingValueIndicators)
XlsxReadOptions.Builder	sample(boolean sample)
XlsxReadOptions.Builder	sheetIndex(int sheetIndex)
XlsxReadOptions.Builder	tableName(String tableName)
XlsxReadOptions.Builder	timeFormat(String timeFormat)	Deprecated.
XlsxReadOptions.Builder	timeFormat(DateTimeFormatter timeFormat)

Methods inherited from class java.lang.Object

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

Field Detail

sheetIndex

protected Integer sheetIndex

Constructor Detail

Builder

protected Builder(tech.tablesaw.io.Source source)

Builder

protected Builder(URL url)
           throws IOException

Throws:

IOException

Builder

public Builder(File file)

Builder

public Builder(InputStream stream)

Builder

public Builder(Reader reader)

Method Detail

build

public XlsxReadOptions build()

header

public XlsxReadOptions.Builder header(boolean header)

tableName

public XlsxReadOptions.Builder tableName(String tableName)

sample

public XlsxReadOptions.Builder sample(boolean sample)

dateFormat

@Deprecated
public XlsxReadOptions.Builder dateFormat(String dateFormat)

Deprecated.

timeFormat

@Deprecated
public XlsxReadOptions.Builder timeFormat(String timeFormat)

Deprecated.

dateTimeFormat

@Deprecated
public XlsxReadOptions.Builder dateTimeFormat(String dateTimeFormat)

Deprecated.

dateFormat

public XlsxReadOptions.Builder dateFormat(DateTimeFormatter dateFormat)

timeFormat

public XlsxReadOptions.Builder timeFormat(DateTimeFormatter timeFormat)

dateTimeFormat

public XlsxReadOptions.Builder dateTimeFormat(DateTimeFormatter dateTimeFormat)

locale

public XlsxReadOptions.Builder locale(Locale locale)

missingValueIndicator

public XlsxReadOptions.Builder missingValueIndicator(String... missingValueIndicators)

minimizeColumnSizes

public XlsxReadOptions.Builder minimizeColumnSizes()

sheetIndex

public XlsxReadOptions.Builder sheetIndex(int sheetIndex)

columnTypes

public XlsxReadOptions.Builder columnTypes(tech.tablesaw.api.ColumnType[] columnTypes)

columnTypes

public XlsxReadOptions.Builder columnTypes(Function<String,tech.tablesaw.api.ColumnType> columnTypeFunction)

columnTypesPartial

public XlsxReadOptions.Builder columnTypesPartial(Function<String,Optional<tech.tablesaw.api.ColumnType>> columnTypeFunction)

columnTypesPartial

public XlsxReadOptions.Builder columnTypesPartial(Map<String,tech.tablesaw.api.ColumnType> columnTypeByName)