๐ผ๏ธ CadifyDartImage
The CadifyDartImage
function sends a JSON prompt to an external ML service and inserts the generated image into your Excel sheet.
๐ What It Does
When you enter this function into a cell, it posts the provided JSON (from CadifyDartJson
) to the Dart/Floris API and places the returned image at the specified location in your worksheet.
๐งพ Syntax
=CadifyDartImage(json, jsonType, target)
๐งฎ Parameters
Parameter | Description |
---|---|
Endpoint URL |
Url to call example: https://api.runpod.ai/v2/689zc0j1f8go4t/runsync |
JSON input |
JSON string, typically from CadifyDartJson |
JSON export type |
Type of JSON/ML request. Currently, only 1 (Floris) is supported |
Top Left Cell |
Excel cell reference (e.g., "B2" ) for the top-left corner of the image |
โ Example
=CadifyDartImage(A2, 1, "B2")
Where cell A2
contains the JSON generated by CadifyDartJson(1)
.
๐ Behavior
- Synchronously sends the JSON to the Dart/Floris API and waits for a response.
- Inserts the returned image as an Excel picture at the
target
cell location. - Each function call generates a new image; previous images are deleted automatically.
- Returns a status message indicating how long it took to retrieve the image from the service.
๐ Notes
- Only
jsonType = 1
is currently supported (Floris image generation). - Requires internet access and a valid API key.
- The image file is temporarily stored and deleted after insertion.
- For best results, ensure the JSON is correctly formatted and the target cell is visible.