sheets.drawings.offsetYNumber
The vertical offset from the anchor cell's top-left corner, in pixels.
Example
<script>
var workbook = new kendo.ooxml.Workbook({
images: {
"banner": {
data: "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVR42mP8/5+hHgAHggJ/PchI7wAAAABJRU5ErkJggg==",
type: "image/png"
}
},
sheets: [
{
drawings: [
{
topLeftCell: "A1",
offsetX: 10,
offsetY: 15,
width: 200,
height: 40,
image: "banner"
}
],
rows: [
{ cells: [ { value: "Banner will be offset 15px down" } ] }
]
}
]
});
workbook.toDataURLAsync().then(function(dataURL) {
kendo.saveAs({
dataURI: dataURL,
fileName: "offset-y-example.xlsx"
});
});
</script>
In this article