Adding icon to a cell in Spread JS Sheet

Adding icon to a cell in Spread JS Sheet

Posted by: rraj226020 on 12 January 2022, 3:27 pm EST

• 

  rraj226020

  • Post Options:
  • Link
    Copy

  Posted 12 January 2022, 3:27 pm EST

  I want to add a Icon to one of the cells in the spread js sheet

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 18 January 2022, 9:04 pm EST

  Hi,

  For this, you may use the cellButtons feature. Please refer to the following code snippet and demo that explains the same.

  
  let style = new GC.Spread.Sheets.Style();
  style.cellButtons = [
       {
          caption: "Custom",
          buttonBackColor:"#F4F8EB",
          imageType: GC.Spread.Sheets.ButtonImageType.custom,
          imageSrc: "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAABPklEQVR4Ae2YAWYDQRSGV6BUabFQiKE28wA9Qo7Qo/QIBRTQGyQESlUWURRSVdZssL3B5gZJT/A6A8Eq8qck//I+foDxvjWzfi8zuhiGYRg6yZxOs3lMG6N7ZsI0/AYYnEoiCZT44EQSwNfnlEgDkKSNmacrDQuQZQNIUApoepeQAGHavguoCewyG6i+5apfN6q1HDm+0ZWM/yewHKbDTpswujtM4PUiHUAgIO1hAu/XHAIpjThc4NP1XKAWmuBX6PmMSeADFygviQT8Ey6wyHkEVv4eF1gOiQRkjAtUBY9A464wgdmAZ/gga7xKvJzT/4F20D/gIA+IAEGFAIpcgr5C1MUtLsBcIbpQV4jgv/fZzG15K4RM8dXiIud/wB0BF7OlqxDBl9CGOqaMWZ+8QlTFj1ajx7/qg2EYhmH8AtrSH2QJmV2LAAAAAElFTkSuQmCC"
     }
  ];
  sheet.setStyle(4, 6, style);
  
  

  Demo: https://www.grapecity.com/spreadjs/demos/features/cells/cell-buttons#demo_source_name

  Regards
  
  Avinash