DataFrame.toExcel

Deprecated in v1.1.0: Use the dfd.toExcel function directly instead
DataFrame.toExcel(options)
Parameters
Type
Description
Default
options
object, optional
Configuration object:
filePath: Local file path to write the CSV file to. If not specified, the CSV will be returned as a string. Only needed in Nodejs version

fileName: The name of the file to download as. Only needed in the browser environment.

sheetName: Name to call the excel sheet.
{
filePath: "./output.xlsx",
sheetName: "Sheet1"

}
The toExcel function can be used to write out a DataFrame or Series to Excel (.xlsx) file. The output format will depend on the environment. In the following examples, we show you how to write/download an Excel file from Node and Browser environments.
Convert DataFrame to Excel and write to file path
Writing an Excel file to a local file path is only supported in the Nodejs environment
Node.js
1
const dfd = require("danfojs-node")
2
​
3
let data = {
4
    Abs: [20.2, 30, 47.3],
5
    Count: [34, 4, 5],
6
    "country code": ["NG", "FR", "GH"],
7
};
8
​
9
let df = new dfd.DataFrame(data);
10
​
11
df.toExcel({ filePath: "testOut.xlsx"});
Copied!
Convert DataFrame to Excel and download the file in a browser
You can automatically convert and download an Excel file in a browser environment, by specifying a fileName.
1
let data = {
2
    Abs: [20.2, 30, 47.3],
3
    Count: [34, 4, 5],
4
    "country code": ["NG", "FR", "GH"],
5
};
6
​
7
let df = new dfd.DataFrame(data);
8
​
9
df.toExcel({ fileName: "testOut.xlsx", download: true });
Copied!

DataFrame.toJSON

DataFrame.sortValues

Last modified 1mo ago

Copy link

Contents

Convert DataFrame to Excel and write to file path

Convert DataFrame to Excel and download the file in a browser