tafia
Cannot find out how to read image in cells
Thanks for the hard work you put into this useful crate. I've used it a lot in my work. Recently I had to work with a .xlsx file with image data in cells, but it seems calamine doesn't have a way to extract images from cells. Wonder if it's possible to extract images from cells or if it's planned to add support for this?
Thanks.
Doesn't look like read_value supports imagines and is why you are getting DataType::Empty. Perhaps the proper way to handle this is to make a datatype such as DataType::Blob to store the reference to the file to be read later as needed.
For my specific case, I resort to use Python, openpyxl, openpyxl-image-loader to get images in .xlsx files. But openpyxl-image-loader only works when one image is contained in a cell. If there are multiple images in a cell, it only gets the first image. So I have but to manually unzip the .xlsx file, parse xml files, and get (col, row): [img1, img2, ..] mapping, which, unfortunately, is not without caveat.
To scratch my own itch, I write this small lib to retrieve a map of {sheetname: {(col, row), imgpath}
It's not efficient, but it did the work.
Still hope this function will be implemented in calamine, though.
