Function $readExcel

src/danfojs-base/io/node/io.excel.ts:54–98

(filePath: string, options: ExcelInputOptionsNode = {})

 * ```
 */
const $readExcel = async (filePath: string, options: ExcelInputOptionsNode = {}) => {
    const {
        sheet,
        method,
        headers,
        frameConfig,
        parsingOptions
    } = { sheet: 0, method: "GET", headers: {}, frameConfig: {}, parsingOptions: {}, ...options }

    if (filePath.startsWith("http") || filePath.startsWith("https")) {

        return new Promise((resolve, reject) => {
            fetch(filePath, { method, headers }).then(response => {
                if (response.status !== 200) {
                    throw new Error(`Failed to load ${filePath}`)
                }
                response.arrayBuffer().then(arrBuf => {
                    const arrBufInt8 = new Uint8Array(arrBuf);
                    const workbook = read(arrBufInt8, { type: "array", ...parsingOptions });
                    const worksheet = workbook.Sheets[workbook.SheetNames[sheet]];
                    const data = utils.sheet_to_json(worksheet, { defval: null });
                    const df = new DataFrame(data, frameConfig);
                    resolve(df);
                });
            }).catch((err) => {
                reject(err)
            })
        })

    } else {
        return new Promise((resolve, reject) => {
            fs.access(filePath, fs.constants.F_OK, (err) => {
                if (err) {
                    reject("ENOENT: no such file or directory");
                }

                const workbook = readFile(filePath, parsingOptions);
                const worksheet = workbook.Sheets[workbook.SheetNames[sheet]];
                const data = utils.sheet_to_json(worksheet, { defval: null });
                const df = new DataFrame(data, frameConfig);
                resolve(df);
            })
        });
    }
};

/**
 * Converts a DataFrame or Series to Excel Sheet.