danfo.readExcel
Reads a JSON file from local or remote location into a DataFrame.
Last updated
Was this helpful?
Reads a JSON file from local or remote location into a DataFrame.
Last updated
Was this helpful?
danfo.readExcel(source, options)
source
string
source : string, URL or local file path to Excel file.
options
Object
{
sheet : string, (Optional) Name of the sheet which u want to parse. Default will be the first sheet. method: The HTTP method to use.
headers: Additional headers to send with the request if reading JSON from remote url. Supports all the node-fetch options in Nodejs, and all fetch options in browsers.
frameConfig: Optional arguments passed when creating the DataFrame. e.g column names, index. etc.
}
The readExcel method can read excel files saved on a local disk, or over the internet.
By specifying a valid , you can load Excel files in the browser in DataFrames/Series
parsingOptions: supports all xlsx options. See