TypeError: carr[1].forEach is not a function #3102

New Issue

RockyScube · 2024-04-03T05:44:19Z

RockyScube commented

2024-04-03 05:44:19 +00:00

I've check the documentation:

previously it was working, now it is not.

xlsx version:
"xlsx": "^0.18.5"

below is my code snippet:
`
// import
import xlsx from 'xlsx'

// implementation
let worksheet = xlsx.utils.json_to_sheet(data)

  let workbook = xlsx.utils.book_new()

  xlsx.utils.book_append_sheet(workbook, worksheet, 'employee')

  xlsx.writeFileXLSX(workbook, 'file.xlsx')
  // xlsx.writeFile(workbook, filename) // tried this as well

`

stack trace:
TypeError: carr[1].forEach is not a function at server/node_modules/xlsx/xlsx.js:23544:14 at Array.forEach (<anonymous>) at write_zip_xlsx (server/node_modules/xlsx/xlsx.js:23543:14) at write_zip_typeXLSX (server/node_modules/xlsx/xlsx.js:23758:10) at writeSyncXLSX (server/node_modules/xlsx/xlsx.js:23847:9) at Object.writeFileSyncXLSX [as writeFileXLSX] (server/node_modules/xlsx/xlsx.js:23921:9)

I've check the documentation: previously it was working, now it is not. xlsx version: `"xlsx": "^0.18.5"` below is my code snippet: ` // import import xlsx from 'xlsx' // implementation let worksheet = xlsx.utils.json_to_sheet(data) let workbook = xlsx.utils.book_new() xlsx.utils.book_append_sheet(workbook, worksheet, 'employee') xlsx.writeFileXLSX(workbook, 'file.xlsx') // xlsx.writeFile(workbook, filename) // tried this as well ` stack trace: ` TypeError: carr[1].forEach is not a function at server/node_modules/xlsx/xlsx.js:23544:14 at Array.forEach (<anonymous>) at write_zip_xlsx (server/node_modules/xlsx/xlsx.js:23543:14) at write_zip_typeXLSX (server/node_modules/xlsx/xlsx.js:23758:10) at writeSyncXLSX (server/node_modules/xlsx/xlsx.js:23847:9) at Object.writeFileSyncXLSX [as writeFileXLSX] (server/node_modules/xlsx/xlsx.js:23921:9) `

RockyScube commented

2024-04-03 05:53:43 +00:00

it was due to date time field, changed it to string, working fine now.

RockyScube closed this issue

2024-04-03 05:53:44 +00:00

sheetjs commented

2024-04-03 05:56:49 +00:00

Can you share the data that was causing issues? You should be able to pass date objects:

let data = [
	{date: new Date()}
]

let worksheet = XLSX.utils.json_to_sheet(data)

let workbook = XLSX.utils.book_new()

XLSX.utils.book_append_sheet(workbook, worksheet, 'employee')

XLSX.writeFileXLSX(workbook, 'file.xlsx')

https://jsfiddle.net/e8ygdcp6/

Can you share the data that was causing issues? You should be able to pass date objects: ```js let data = [ {date: new Date()} ] let worksheet = XLSX.utils.json_to_sheet(data) let workbook = XLSX.utils.book_new() XLSX.utils.book_append_sheet(workbook, worksheet, 'employee') XLSX.writeFileXLSX(workbook, 'file.xlsx') ``` https://jsfiddle.net/e8ygdcp6/

RockyScube commented

2024-04-03 06:00:33 +00:00

Can you share the data that was causing issues? You should be able to pass date objects:

let data = [
	{date: new Date()}
]

let worksheet = XLSX.utils.json_to_sheet(data)

let workbook = XLSX.utils.book_new()

XLSX.utils.book_append_sheet(workbook, worksheet, 'employee')

XLSX.writeFileXLSX(workbook, 'file.xlsx')

https://jsfiddle.net/e8ygdcp6/

I'm using Lucid ORM which provides DateTime Type, maybe converting it JSDate() will work

> Can you share the data that was causing issues? You should be able to pass date objects: > > ```js > let data = [ > {date: new Date()} > ] > > let worksheet = XLSX.utils.json_to_sheet(data) > > let workbook = XLSX.utils.book_new() > > XLSX.utils.book_append_sheet(workbook, worksheet, 'employee') > > XLSX.writeFileXLSX(workbook, 'file.xlsx') > ``` > > https://jsfiddle.net/e8ygdcp6/ I'm using Lucid ORM which provides DateTime Type, maybe converting it JSDate() will work

Sign in to join this conversation.