Read excel spark

    import org.apache.spark.sql._

val spark: SparkSession = ???
val df = spark.read
         .format("com.crealytics.spark.excel")
        .option("sheetName", "Daily") // Required
        .option("useHeader", "true") // Required
        .option("treatEmptyValuesAsNulls", "false") // Optional, default: true
        .option("inferSchema", "false") // Optional, default: false
        .option("addColorColumns", "true") // Optional, default: false
        .option("startColumn", 0) // Optional, default: 0
        .option("endColumn", 99) // Optional, default: Int.MaxValue
        .option("timestampFormat", "MM-dd-yyyy HH:mm:ss") // Optional, default: yyyy-mm-dd hh:mm:ss[.fffffffff]
        .option("maxRowsInMemory", 20) // Optional, default None. If set, uses a streaming reader which can help with big files
        .option("excerptSize", 10) // Optional, default: 10. If set and if schema inferred, number of rows to infer schema from
        .schema(myCustomSchema) // Optional, default: Either inferred schema, or all columns are Strings
        .load("Worktime.xlsx")

Source: stackoverflow.com

Read excel spark

def readExcel(file: String): DataFrame = sqlContext.read
    .format("com.crealytics.spark.excel")
    .option("location", file)
    .option("useHeader", "true")
    .option("treatEmptyValuesAsNulls", "true")
    .option("inferSchema", "true")
    .option("addColorColumns", "False")
    .load()

val data = readExcel("path to your excel file")

data.show(false)

Source: stackoverflow.com

Similar codes

2 votes246 views1 answer
How to get micro symbol in python
Python
3 votes168 views2 answers
How to find the path of a python module
Python
0 vote159 views1 answer
Binary string to hex python
Python
6 votes214 views2 answers
Python config file
Python
0 vote128 views2 answers
Rename second column pandas
Python
0 vote165 views1 answer
Python - caéculate the average based on the level of a second column in a df
Python
0 vote172 views1 answer
HOW TO CREATE A DATETIME LIST QUICK
Python
2 votes157 views2 answers
Python format 001
Python
7 votes169 views4 answers
Pytorch save model
Python
1 vote127 views1 answer
Cannot import name 'joblib' from 'sklearn.externals' (/shared-libs/python3.7/py/lib/python3.7/site-packages/sklearn/externals/__init__.py)
Python