Community Conundrum 28: News Engagement is live! Read More

Import images from password protected cells in .xlsx files

Level 1
Level 1
Import images from password protected cells in .xlsx files

Hi all,

Hope you're doing well. 


I'm hosting a DataIku demo this Friday. The team I'm hosting the demo for is planning to work with images stored in xlsx files. However, the cells are password protected. Any suggestions or thoughts on how to get this imported into DataIku? Thanks! 

Regards,

Wouter 

0 Kudos
2 Replies
Neuron
Neuron

@Wvnassau 

How far have you gotten with this challenge so far? Are you using something like the python libraries?

openpyxl
and
openpyxl-image-loader

 

--Tom
0 Kudos

@Wvnassau any way you could share a sample file? I am not particularly familiar with Excel's wizardry but when I looked up how to recreate the scenario you stated I could not find an obvious solution in Excel. I don't think you can embed images in cells directly, but rather can constrain them to resize with cells. And you can lock the permissions on a cell only if you lock the whole file (I think). 

In any event if you could give me an example file I might be able to help - just make sure to create trivialized passwords for the sample you post (if you do post one)

 

-Tim 

0 Kudos
A banner prompting to get Dataiku DSS