Extract an image "Placed In Cell"

GemBox.Spreadsheet
1

Hi All,
I have an .xlsx with 1000+ images.
It has a mix of both “Placed in cell” and “floating” images.
I can extract the “floating” images, but I cannot extract the images that are “Placed in cell” ?
Examining the .xlsx shows that it does use the “Rich Text” mechanism, but that GemBox Spreadsheet does not yet support this as noted by Mario Import Excel's images to Datagridview - #4 by mario.gembox
I have not yet tried the hotfix, as i wondering where that has ended up with wrt latest release ?
Thanks.

2

Hi,

Please try using the current latest version, that previous hotfix is included in it.
If the problem remains, please send us a small Visual Studio project that reproduces your issue so we can investigate it.

Regards,
Mario

3

Hi All,
Latest bundle version 2025.7.105 installed, I still cannot find this single image that has been “placed in cell”.
I couldn’t upload the spreadsheet, but it contains only a single worksheet, containing a single image “placed within cell” within cell A1.
All “freefloating” images can be found within ws.Pictures[] easily enough.

        private void btnReadXlsx_Click(object sender, EventArgs e)
        {
            SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
            ExcelFile wb = ExcelFile.Load(@"C:\Test\SingleImage.xlsx");
            foreach (ExcelWorksheet ws in wb.Worksheets)
            {
                int iCounts = ws.Pictures.Count
                             + ws.Shapes.Count
                             + ws.GroupShapes.Count
                             + ws.Tables.Count
                             + ws.EmbeddedObjects.Count;
                int iOccupiedCellsCount = 0;
                foreach (ExcelRow r in ws.Rows)
                {
                    iOccupiedCellsCount += r.AllocatedCells.Count;
                }
                Console.WriteLine("Worksheet " + ws.Name + " has " + iCounts + " objects and " + iOccupiedCellsCount + " cells.");
            }
        }
4

Hi,

Please send us the “SingleImage.xlsx” via email or support ticket so we can investigate it.
See our Contact page.

Regards,
Mario