Picture in-cell support

Picture in-cell support

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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  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

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  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.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  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.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  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.

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  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

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 6 May 2026, 12:21 am EST

  Hi Yukinori,

  Thanks for your patience while we worked with our development team to support the required features.

  The picture-in-cell feature is fully supported starting from DsExcel v9.1.0. We recommend upgrading to this version to use the feature reliably in your workflow.

  Please refer to the attached materials for additional details (see below).

  Please let us know if you need any further assistance.

  Kind Regards,
  
  Chirag

  References:

  1. Picture In Cell: https://developer.mescius.com/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/picture-in-cell
  2. DsExcel v9.1.0 NuGet Download: https://www.nuget.org/api/v2/package/DS.Documents.Excel/9.1.0