· 7 years ago · Feb 06, 2019, 05:28 PM
1import pandas
2
3def readExcel():
4 pandas.read_excel('/mnt/adls/Raw/Financials/lrp.xlsx')
5
6data = readExcel()
7print(data)
8
9%sql
10Create Table If Not Exists Raw.Test
11Using CSV
12OPTIONS (header "true", inferSchema "true")
13Location "/mnt/adls/Raw/Financials/lrp.xlsx"