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