sql - Retrieve images embedded in Excel file -


i'm in process of upscaling excel solution web solution. in process, need upload existing data new (sql server) database.

problem is, need upload images stored in excel file (as shapes). in database, stored bytearray in png format.

what best way retrieve source of embedded image?

i'm thinking of either using ws.shapes("img_1").copypicture , api functions retrieve - far, got stuck in figuring out proper api functions. also, not sure if there isn't easier/more elegant way...

if don't mind getting images files in disk , afterwards uploading database, save excel workbook or worksheet "web page".

that create html file , directory filled whatever images (one png file per image) original excel file has.


Comments