image error with 1.3.2

[smolleyes]

hi

i have this error with 1.3.2 and can t get any image working with any other version :(

TypeError: Cannot read properties of null (reading 'asText') 1|extranet-api | 2022-08-26 15:23 +02:00: at Workbook.module.exports.Workbook.loadDrawing (/home/srv/websites/batexpert-api/node_modules/xlsx-template/lib/index.js:592:77)

someone have success adding images with this module ?

thanks

[smolleyes]

hi

someone still maintaining this module ?

thanks

[Eraledm]

Same issue here

[Eraledm]

I forked the repo and it looks like tests are working correctly so I tested with my own xlsx file and turns out an embedded image was breaking this feature:

I haven't had time to check the code and figure out what's the real issue, I tested removing that image and adding other png images and it works as expected, so my current solution was just remove that image and add another one.

Hope it helps

[kant2002]

If somebody have file and short sample of code that may help troubleshoot an issue

[Eraledm]

Sure,
test-insert-images.xlsx
The original excel was from a client, I modified it to keep the same format of the testing files so you can delete the image object and validate that the tests passes but if you keep the image then the tests fails

[kant2002]

@Eraledm can you take a look at release 1.4.0 and I was not able to repro an issue. Maybe you can create some small repro app ?

[smolleyes]

hi!

in my case it seems that the checkbox are creating the problem... if i remove them everything works... for information

[kant2002]

@smolleyes do you experience this error with 1.4.0 too?

[smolleyes]

with the "bad" excel yes

[kant2002]

@smolleyes can you give me test file similar to wha Eraledm provide which trigger this behaviour?

[interrizky]

Upgrade it to 1.4.3 version and still having the issue. Have tried using buffer, base64 and path too. It says:

TypeError: Cannot read properties of null (reading 'asText') at Workbook.loadDrawing (../node_modules/xlsx-template/lib/index.js:517:77)

[jdugh]

@smolleyes , @interrizky @Eraledm :
Can you provide a simple template, with the image and a simple source script to reproduce your problem?
We use this module daily and the image insertion works fine for us.