We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Add image to spreadsheet at specific column & row

Thread ID:

Created:

Updated:

Platform:

Replies:

131750 Jul 25,2017 07:35 PM UTC Jul 26,2017 09:23 AM UTC ASP.NET Core 1
loading
Tags: Spreadsheet
Jacob Knight
Asked On July 25, 2017 07:35 PM UTC

I haven't been able to find what I'm looking for in terms of adding an image to a spreadsheet on loadComplete(args).
I tried utilizing code such as: this.XLEdit.updateCellValue({ rowIndex: 31, colIndex: 0 }, URL(new url, "../images/phLogo.png"));
to no 

I've tried by utilizing a button in the spreadsheet via:
                <e-cell-types>
                    <e-cell-type range="A32">
                        <e-settings typeof="button" style="background-image: url('/images/phLogo.png')" datasourcerange="A32" class="none"></e-settings>
                    </e-cell-type>
                </e-cell-types>

That class is being set by ej.spreadsheet.min.js and I'm trying to avoid going in and editing it because doing so is so resource intensive. Is there some other approach I can utilize? I'll also say that using the 2nd approach I do get a button that displays but it also displays the button name in 7 out of the next 10 or so cells in the A column.

Shanmugaraja K [Syncfusion]
Replied On July 26, 2017 09:23 AM UTC

Hi Jacob, 
 
Thanks for using Syncfusion products. 
 
We have checked your requirement, and we suspect that your trying to add picture in Spreadsheet. We suggest you to use setPicture method to achieve this requirement. 
 
[JS] 
 
 
        $(function () { 
            $("#Spreadsheet").ejSpreadsheet({ 
               loadComplete: "loadComplete" 
            }); 
        }); 
        function loadComplete(args) { 
            this.XLShape.setPicture("B2", "\ladybug.png", 400, 240); 
        } 
 
 
We have created simple sample with these code example and the same can be downloaded from the below link, 
 
 
Please try the above sample and check whether it fulfilling your requirement, if not please get back to us with more details. 
 
Regards, 
Shanmugaraja K  


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;