Image

The Image sparkline can be used to place an image in a cell. The image can be displayed in different sizes by using the display modes of the Image sparkline function. The source of the image can be a URL or a base64 string.

You can create an image using the Image function in a formula:=IMAGE(source,alt_text,sizing,height,width,clipX,clipY,clipHeight,clipWidth,vAlign,hAlign) This function has the following parameters: source: The location of the image on the web or a base64 string. alt_text: (optional) Alternative text that describes the image for accessibility. sizing: (optional) A number that represents the image fit mode. One of the following: Keep Scale To Fit - 0 Entire Image To Fit - 1 Origin Size To Fit - 2 Custom Size To Fit - 3 height: (optional) This is the height of the image when the mode is 3. width: (optional) This is the width of the image when the mode is 3. clipX: (optional) The X-axis coordinate of the top left corner of the sub-rectangle of the source image to draw into the destination context. clipY: (optional) The Y-axis coordinate of the top left corner of the sub-rectangle of the source image to draw into the destination context. clipHeight: (optional) The height of the sub-rectangle of the source image to draw into the destination context. clipWidth: (optional) The width of the sub-rectangle of the source image to draw into the destination context. vAlign: (optional) This value indicates the vertical alignment of the image. One of the following: Top - 0 Center - 1 Bottom - 2 hAlign: (optional) This value indicates the horizontal alignment of the image. One of the following: Left - 0 Center - 1 Right - 2
window.onload = () => { var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss")); initSpread(spread); } function initSpread(spread) { spread.suspendPaint(); spread.fromJSON(data[0]); spread.options.allowDynamicArray = true; var sheet = spread.getActiveSheet(); sheet.name("Image Formula"); initImageFormula(sheet); spread.resumePaint(); } function initImageFormula(sheet) { sheet.setFormula(1, 1, '=XLOOKUP(A2,Product_list[ITEM],Product_list[IMAGE])'); sheet.setFormula(5, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image13.jpg", "Wellington boots")'); sheet.setFormula(6, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image4.jpg", "Dress")'); sheet.setFormula(7, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image5.png", "Glasses")'); sheet.setFormula(8, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image6.jpg", "Hat")'); sheet.setFormula(9, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image7.png", "Jacket")'); sheet.setFormula(10, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image8.jpg", "Shorts")'); sheet.setFormula(11, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image9.jpg", "Slippers")'); sheet.setFormula(12, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image10.jpg", "Suitcase")'); sheet.setFormula(13, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image11.png", "Swimsuit")'); sheet.setFormula(14, 4, '=IMAGE("$DEMOROOT$/spread/source/images/avatar/image12.jpg", "T-shirt")'); }
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" type="text/css" href="$DEMOROOT$/en/purejs/node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2013white.css"> <script src="$DEMOROOT$/en/purejs/node_modules/@mescius/spread-sheets/dist/gc.spread.sheets.all.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/spread/source/js/license.js" type="text/javascript"></script> <script src="$DEMOROOT$/spread/source/data/image-function.js" type="text/javascript"></script> <script src="app.js" type="text/javascript"></script> <link rel="stylesheet" type="text/css" href="styles.css"> </head> <body> <div class="sample-tutorial"> <div id="ss" style="width:100%;height:100%"></div> </div> </body> </html>
.sample-tutorial { position: relative; height: 100%; overflow: hidden; } body { position: absolute; top: 0; bottom: 0; left: 0; right: 0; }