方法是这样的
- spread.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
- console.log("ClipboardPasting---粘贴图片---", sender, args);
- if (args.pasteData.image) {
- args.cancel = true;
- addImgRow(args)
- }
- });
- const addImgRow = (args)=>{
- let Designer = GC.Spread.Sheets.Designer.findControl('designer-container');
- let spread = Designer.getWorkbook()
- let sheet = spread.getActiveSheet();
- let rows = args.cellRange.row
- let cols = args.cellRange.col
- let height = sheet.getRowHeight(rows) //获取第2行行高
- let width = sheet.getColumnWidth(cols) //获取第2列宽度
- // console.log(height, '--宽度--', width, '---args.cellRange--', args.cellRange)
- let pic = sheet.shapes.addPictureShape(new Date().getTime(), args.pasteData.image, 0,0, width,height)
- // let pic = sheet.shapes.addPictureShape(new Date().getTime(), args.pasteData.image, 0,0,width,height)
- pic.startRow(rows) //开始行在第二行
- pic.startColumn(cols) //开始列在第二列
- pic.pictureStretch(GC.Spread.Sheets.ImageLayout.zoom);
- pic.startRowOffset(0);
- pic.startColumnOffset(0);
- pic.endColumnOffset(height);
- pic.endRowOffset(width);
- pic.endRow(rows + args.cellRange.rowCount) //结束行在第三行
- pic.endColumn(cols + args.cellRange.colCount) //结束列在第三列
- pic.allowMove(false) //图片不允许移动
- pic.allowResize(false) //图片不允许拉动调整大小
- pic.dynamicMove(true) //图片是否随插入行列移动
- pic.dynamicSize(true) //图片是否随行高列宽变化而变化
- }
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图
