Merge branch 'dev' of https://github.com/lyhue1991/danfojs into lyhue1991-dev

risenW · risenW · commit fecaa61f5649 · 2025-04-02T14:43:32.000+01:00
diff --git a/src/danfojs-base/io/node/io.excel.ts b/src/danfojs-base/io/node/io.excel.ts
@@ -71,7 +71,7 @@ const $readExcel = async (filePath: string, options: ExcelInputOptionsNode = {})
                     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);
+                    const data = utils.sheet_to_json(worksheet,{'defval':null});
                     const df = new DataFrame(data, frameConfig);
                     resolve(df);
                 });
@@ -89,7 +89,7 @@ const $readExcel = async (filePath: string, options: ExcelInputOptionsNode = {})
 
                 const workbook = readFile(filePath, parsingOptions);
                 const worksheet = workbook.Sheets[workbook.SheetNames[sheet]];
-                const data = utils.sheet_to_json(worksheet);
+                const data = utils.sheet_to_json(worksheet,{'defval':null});
                 const df = new DataFrame(data, frameConfig);
                 resolve(df);
             })
