Class

com.crealytics.spark.excel

ExcelRelation

Related Doc: package excel

Permalink

case class ExcelRelation(location: String, sheetName: Option[String], useHeader: Boolean, treatEmptyValuesAsNulls: Boolean, inferSheetSchema: Boolean, addColorColumns: Boolean = true, userSchema: Option[StructType] = None, startColumn: Int = 0, endColumn: Int = Int.MaxValue, timestampFormat: Option[String] = None, maxRowsInMemory: Option[Int] = None, excerptSize: Int = 10, skipFirstRows: Option[Int] = None, workbookPassword: Option[String] = None)(sqlContext: SQLContext) extends BaseRelation with TableScan with PrunedScan with Product with Serializable

Linear Supertypes
Serializable, Serializable, Product, Equals, PrunedScan, TableScan, BaseRelation, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. ExcelRelation
  2. Serializable
  3. Serializable
  4. Product
  5. Equals
  6. PrunedScan
  7. TableScan
  8. BaseRelation
  9. AnyRef
  10. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. new ExcelRelation(location: String, sheetName: Option[String], useHeader: Boolean, treatEmptyValuesAsNulls: Boolean, inferSheetSchema: Boolean, addColorColumns: Boolean = true, userSchema: Option[StructType] = None, startColumn: Int = 0, endColumn: Int = Int.MaxValue, timestampFormat: Option[String] = None, maxRowsInMemory: Option[Int] = None, excerptSize: Int = 10, skipFirstRows: Option[Int] = None, workbookPassword: Option[String] = None)(sqlContext: SQLContext)

    Permalink

Value Members

  1. final def !=(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  4. val addColorColumns: Boolean

    Permalink
  5. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  6. def buildScan(requiredColumns: Array[String]): RDD[Row]

    Permalink
    Definition Classes
    ExcelRelation → PrunedScan
  7. def buildScan(): RDD[Row]

    Permalink
    Definition Classes
    ExcelRelation → TableScan
  8. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  9. val columnNameRegex: UnanchoredRegex

    Permalink
  10. val dataFormatter: DataFormatter

    Permalink
  11. val endColumn: Int

    Permalink
  12. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  13. lazy val excerpt: List[Row]

    Permalink
  14. val excerptSize: Int

    Permalink
  15. def extractCells(row: Row): Vector[Option[Cell]]

    Permalink
  16. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  17. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any
  18. val inferSheetSchema: Boolean

    Permalink
  19. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  20. val location: String

    Permalink
  21. def makeSafeHeader(row: Array[String], dataTypes: Array[DataType]): Array[StructField]

    Permalink

    Generates a header from the given row which is null-safe and duplicate-safe.

    Generates a header from the given row which is null-safe and duplicate-safe.

    Attributes
    protected
  22. val maxRowsInMemory: Option[Int]

    Permalink
  23. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  24. def needConversion: Boolean

    Permalink
    Definition Classes
    BaseRelation
  25. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  26. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef
  27. val schema: StructType

    Permalink
    Definition Classes
    ExcelRelation → BaseRelation
  28. val sheetName: Option[String]

    Permalink
  29. def sizeInBytes: Long

    Permalink
    Definition Classes
    BaseRelation
  30. val skipFirstRows: Option[Int]

    Permalink
  31. val sqlContext: SQLContext

    Permalink
    Definition Classes
    ExcelRelation → BaseRelation
  32. val startColumn: Int

    Permalink
  33. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  34. val timestampFormat: Option[String]

    Permalink
  35. val timestampParser: Option[SimpleDateFormat]

    Permalink
  36. val treatEmptyValuesAsNulls: Boolean

    Permalink
  37. def unhandledFilters(filters: Array[Filter]): Array[Filter]

    Permalink
    Definition Classes
    BaseRelation
  38. val useHeader: Boolean

    Permalink
  39. val userSchema: Option[StructType]

    Permalink
  40. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  41. final def wait(arg0: Long, arg1: Int): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  42. final def wait(arg0: Long): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  43. val workbookPassword: Option[String]

    Permalink

Inherited from Serializable

Inherited from Serializable

Inherited from Product

Inherited from Equals

Inherited from PrunedScan

Inherited from TableScan

Inherited from BaseRelation

Inherited from AnyRef

Inherited from Any

Ungrouped