Picture in-cell support

Posted by: yyoshimura on 6 December 2024, 1:27 am EST

  • Posted 6 December 2024, 1:27 am EST

    Hi,

    Is inserting pictures in-cell(https://support.microsoft.com/en-us/office/insert-picture-in-cell-in-excel-e9317aee-4294-49a3-875c-9dd95845bab0) supported? I cannot find the corresponding API in the document.

    By the way, is there a way to get the result of Excel IMAGE() function? I tried to get the value but [GrapeCity.Documents.Excel.CalcError.Connect] was returned.

    Regards

  • Posted 6 December 2024, 8:31 am EST

    Hi,

    The picture addition inside a cell is not currently supported in DsExcel. However, it is possible to add the picture over a particular cell to look alike the same. Please refer to the below code snippet that illustrates this workaround -

    IShape picture = IWorksheet.Shapes.AddPicture(filename: "/PATH/TO/IMAGE/FILE.jpg", targetRange: IWorksheet.Range["A1"]);
    picture.Placement = Placement.MoveAndSize;

    In addition, there is no way to retrieve the image calculated using the IMAGE function. The IMAGE function is calculated for PDF exports only and the Microsoft Excel recalculates the values of the IMAGE function for the XLSX-based exports.

    We are also discussing both of the above scenarios with the concerned team and will get back to you as soon as we get any information from their end.

    [Internal Tracking Id (Picture in-cell): DOCXLS-11693]

    [Internal Tracking Id (Image Function): DOCXLS-11694]

    Please feel free to reach out if you encounter any further issues or require additional guidance.

    Best Regards,

    Kartik

  • Posted 9 December 2024, 1:46 am EST

    Hi,

    Thank you for the explanation. Hope that this feature will be supported in your great library.

  • Posted 10 December 2024, 6:09 am EST

    Hello Yukinori,

    >>By the way, is there a way to get the result of Excel IMAGE() function? I tried to get the value but [GrapeCity.Documents.Excel.CalcError.Connect] was returned.

    The developers wanted to know about the use-case that why do you want to get the value of Image function and what will you do after getting the cell value.

    Regards,

    Prabhat Sharma.

  • Posted 10 December 2024, 8:57 pm EST

    Hi,

    We need to send the Excel file to server side and read the Excel file of cells with pictures in it and save the pictures to database for our use case.

  • Posted 11 December 2024, 4:54 am EST

    Hi,

    Thanks for the information. We have shared your use-case to the development team. Will get back to you once we have any updates from them.

    Regards,

    Nitin

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels