danfo.readExcel
Reads a JSON file from local or remote location into a DataFrame.
danfo.readExcel(source, options)
Parameters
Type
Description
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.
}

Example

The readExcel method can read excel files saved on a local disk, or over the internet.
Node.js
Browser
const dfd = require("danfojs-node")
const path = require("path")
let local_xcel = path.join(process.cwd(), "data", "testexcel.xlxs")
async function load_process_data() {
let df = await dfd.readExcel(local_xcel)
df.head().print()
}
load_process_data()
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="https://cdn.jsdelivr.net/npm/[email protected]/lib/bundle.min.js"></script>
<title>Document</title>
</head>
<body>
<script>
const remote_url = 'https://file-examples-com.github.io/uploads/2017/02/file_example_XLS_100.xls';
dfd.readExcel(remote_url).then(df => {
df.head().print()
})
</script>
</body>
</html>

Reading an input file object in the browser

By specifying a valid file object, you can load Excel files in the browser in DataFrames/Series
Browser
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="https://cdn.jsdelivr.net/npm/[email protected]/lib/bundle.min.js"></script>
<title>Document</title>
</head>
<body>
<input type="file" id="file" name="file">
<script>
const inputFile = document.querySelector('#file')
inputFile.addEventListener("change", async () => {
const excelFile = inputFile.files[0]
dfd.readExcel(excelFile).then((df) => {
df.print()
})
})
</script>
</body>
</html>
Copy link
On this page
Example
Reading an input file object in the browser