javascript - sheetJs - no output for empty cell - Stack Overflow

admin管理员组

文章数量:1346036

I am using sheetjs. The empty cell is not getting populated in the json object including the header. I need that information also if a column is not entered. Here is my code:

workbook.SheetNames.forEach((sheetName) => {
    let XL_row_object = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], {defval:""});
    console.log( JSON.stringify(XL_row_object ));
}

I am using sheetjs. The empty cell is not getting populated in the json object including the header. I need that information also if a column is not entered. Here is my code:

workbook.SheetNames.forEach((sheetName) => {
    let XL_row_object = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], {defval:""});
    console.log( JSON.stringify(XL_row_object ));
}

• javascript
• sheetjs

Share Improve this question Follow edited Jan 9, 2020 at 23:21 user47589 asked Jan 9, 2020 at 23:20 PadmaPadma 4111 silver badge22 bronze badges 1

• refer this stackoverflow./a/66658841/3099258 , if this helps your motive – Supriyo Bhattacherjee Commented Mar 17, 2021 at 13:48

Add a ment  | 

3 Answers 3

Sorted by: Reset to default 8

You can solved it with this part, at the begining, when you are including your SheetJS:

**const data = xlsx.utils.sheet_to_json((ws),{defval:""});**

• data is just a const which holds conversion from sheet to json
• ws is the name of our sheets which we are using for conversion and manipulation
• defval presents empty cell values. In our case it is an empty string ("")

I was having the same issue and I solved this problem with this:

XLSX.readFile('file', {sheetStubs:true})

To extend the sheetStubs answer, XLSX.utils.sheet_to_json will ignore stubs so you should first convert them with a simple function:

function removeStubs(wb) {
  Object.values(wb.Sheets).forEach(ws => {
    Object.values(ws).filter(v => v.t === 'z').forEach(v => Object.assign(v,{t:'s',v:''}));
  });
  return wb;
}

then call removeStubs( XLSX.readFile('file', {sheetStubs:true}) )

本文标签： javascriptsheetJsno output for empty cellStack Overflow