请选择 进入手机版 | 继续访问电脑版
 找回密码
 立即注册

QQ登录

只需一步,快速开始

KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于:2019-6-20 17:33:48
11#
您好,SpreadJS中可以通过浮动对象接口的调用,实现图片位置、大小不可变,

但Excel中不支持这样的操作,在没有保护表单的情况下,Excel中的图片是无法被完全固定的,

针对您的问题,实际上可以采用以下代码来设置所有单元格可编辑,并且除了图片外所有

保护项都被允许,如下代码所示:

  1. var pic = "data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAIBAQEBAQIBAQECAgICAgQDAgICAgUEBAMEBgUGBgYFBgYGBwkIBgcJBwYGCAsICQoKCgoKBggLDAsKDAkKCgr/2wBDAQICAgICAgUDAwUKBwYHCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgr/wAARCABQAH0DASIAAhEBAxEB/8QAHQAAAwADAQEBAQAAAAAAAAAAAAkKBQcIBAYBA//EAEoQAAAEBAMDBwcFDQkAAAAAAAIDBAUAAQYHCAkSChETGiEiWJay1RQxMjVCUnMjQWFxkhUWMzlFYnaBgoORtcUXJTRDUWNyk6L/xAAbAQEAAgMBAQAAAAAAAAAAAAAAAgYDBAUBB//EAC8RAAEDAwMBBgQHAAAAAAAAAAEAAgMEBREGEiFhBxMxUXGRQWKBoSIyUlNykrH/2gAMAwEAAhEDEQA/AGQZ4GcPSmT/AIeGe4IaCDVVa1g5HoKNp49UJOnMEUAIz1J4w7xcIoJhXRD0hiMAHo75jCmczbV8zSYhcPDtYkIfmCNgep/1WN/bct6swyfHrHussT8wROH5azmb9XixHZ968Vg5azmb9XixHZ968VhPEEETh+Ws5m/V4sR2fevFYOWs5m/V4sR2fevFYTxBBE4flrOZv1eLEdn3rxWDlrOZv1eLEdn3rxWNAZX2zhY68yim0d3CUyG3VuVstaKr6sLM1OJchaRCRpgdM4Pn+UFpL/OhndD7EphRbmksq4uMyvnRdIHyihnY0aEvV9ADJnz/APUEXIfLWczfq8WI7PvXisHLWczfq8WI7PvXisb4xKbEuAinFDthIxlmKHMoAhEMlfMYSyThe7NWlFPh/wDTOEpYt8H+IbAtetzw/wCJm3iqnKmbN05pztIylJM59BQQaHeA4oW7mMBPd5/qgiZry1nM36vFiOz714rGSTbZDmzOCYKtHhOsyaSYTxQGl0k/CCIEuYQ98nT0YTNHamHjOcxEWctJT9hES1uYWGmWYTa2ObCyCOVGEjMEMwKmQlZYTpDEKerdMP8AxnEXu2N3YJ9FJjN7sZx6+C7IFtjebXwuPPCTZmYej0/vSfdPOHWH8qe7zx/Oe2SZsUx8CWFWzGvcDeD7037VLWEQg/lT5wy3yjmOqc8++KFvCkoBop9SuBJMX90T6bMQkyTkpxFFkzIAtN16fSkIQ/fDp0jFGrKuzb8UFd1X9/NXttMrXXhAL8q8mWFayw6dJYglKQS0y0gkH3Qg0h3BGOQoxSd63cGkDqMH28R9cHopSM7t2Mg+nKaVgm2xHEI+4gaboLHrhrotloypXEhEZUtHoXBCe18UYQBVjAsUqAqCQaw69OgWjpS1cwIoJiFm9OLC7+JVybA3TdCFU0ToapTcEsYeCI7h8QIZTFPSH5OXRlF00ZFjSCduW9WYZPj1j3WWJ+YoG25b1Zhk+PWPdZYn5giIIIIIiOtskbBTS2PrMntzYCviyzKYmuNdaoIMM0+UoUoeKIj94IIC57vZHOOSYytJ1fVlBvhFT0RUzgzuiUepK4tS0xOoJn5uiYWKQgwRXnlk0nbSkOGQUiZmFjbuiABYSk6FKSX80pbpFlgAH9UoQnif21N+Yr0L2LCfhTaneim5cIlO8Va7nEq3csAph4oSig6U4R+kHVqF5tXuxw/gKsZtC2YbQblTmHK6t2l9BvKE9vc3yqq6VEM5xAg6TSAmqjJ8Toi9ErfHUFrtiexXvaMlbd/F1QjGMwEhGo2dsVrTCZ+7MQglgn+qCJ22VvmHW5zQcHzLiqt2wKWYSxYe3vzCqNkYNucCNPFJ1y3aw6RAGAXN0TAxwVtkWF6iLhZfbFigNaSA1Jb2r0yZO5BL+UGhWi4JieYvd4vCM/dx2fk5ZYSTKYwoLcMiO7p9aeX1arfzHY9tCjkAR6dMTMkJchj6IfJ9Wrf7caK2tD8SxW/6V0//ADAuCKSyCCCCIggggi9DV60TfHB3ov0iAtq9aJvjg70X6QRIJ25b1Zhk+PWPdZYn5igbblvVmGT49Y91lifmCIggggiI7s2fPLTp3M0x/tVvrnpRm0FSKAVQVmQDVLywkswISkW+Xo8U0Ut/+3IccJw8DYkKrpxBidvdSC5YALq6UQ1ntxQ59IZJCs0J276uMVBFQ+wU9QlpqGS03S7O3MFOsLfwkqNEnCnSoUpQfRCEO4JYQhDE5GYrtfmLCs7sPVGYBWlmpGh29aambqgdW0KxydCwC3SU6TOgnCPdMQQbhC0zlqijS6NFEXKtpUNuD1w0pVQMattMUl+kSE8kRUxS+rVEfFX7P7mu09iRVYckmEao3FaB0EnS1AhTf3QpJ4mmSqSsW4ASdPS5+lu9mCKhLZksZ2JnHfl7vV78VVxjqoqIq6Dk2pHI9GSTpRlo0AwFhCUEIeYw03+MYva0PxLFb/pXT/8AMC46RylMA7dlp4DqIwrFuhLg7tpBi6q3MiXyat0Ui4p4w7/YDzFA/MLBHmzj8ETrmHZddx8L1Lqiyn50byltNCOM0gG4pDgKCCxC9kIxl8Of0DgiikgjL1tRtT26rB0oKtmQ9semRwOQuzcqK0mJVBQxAMLEH3giDOUYiCIggggi9DV60TfHB3ov0iAtq9aJvjg70X6QRIJ25b1Zhk+PWPdZYn5igbblvVmGT49Y91lifmCIggggiy46SqcFOF1qZTq0LOYrmlLcxJh+TjPkHVMuRm7Tr08+nz7o27l3Y6rt5cOK2mcVdn5lqFjKYMhzaFRggp3VAZ0T0hunnkEYfn9kUgC+aP3B3jGdMM7uupatKOQ1pbqpJhLq+hngsJhC0MvROK1fgVAPYMl5o6sdcpPDljOoc29mWjfpLMkQNa+hasOFxm0yf+SIyWowv6JjCIIvfipXbVtNp2t2XaMxQOOGTAF0f8ZMDMbs+Y2kch2cgWKg0/NeabdQPD5R+aM4D/VmeHjoPxDyTz8KO03ZTuJihUlQVXiAIts+jAHy+l63TmEmJzNPSCA8AZknBlP2pC5/dlGbv5tJuT7YmlVL8HFegrBaQDUSxUWjOWKlAvdCLSEoP7Q5RLbePLVxv2NVGArbDnURqcsX+PZkc16cQfe1JtemX17o0660jVTAp8jeqZcEZ0p85SpGMsX8JyjvUN0tlyiElJOyRp+LXNcPsSuTVW+von7KiJzD8zSP9CcszbYTf5yzGmq8FRUONusGWWY1rbdI5gOWeRmGBn90RGz3cRaDSEUg9EGnWX7euOns3bawbJ0NaUi2OWDVZdXVrUzeEZ1ZjbzApacKMDu0gLNDKZy383doL8/SnzSndpSz9269PCRQtrqidzBT3BC1sp6ic/sBnHUOGjJtx/3Gf0VVSpP+zxMlOCpKfKlW+TnJ9PS4gCQbzd8vpkGNW6aisVlhdJW1UcYH6nAE9Mck/QE9FsUFlutzlDKaB78+TSfv4e5HqtZqMD2YNe9Q43hc8Olfval6WGuDi+ODSbI1acaIQxnC4u4RkxiFMWr540pUdPP9JPqqnKnZlKBehOESsRrChFmkmBnzhEEXOGe+GjWsd6YtZjHoumKLx717X6mh/K6gvXVi6oRTYCG5KTqEkKBqFIycx9H0xfhNMLkxK3UNvtfysbwDKmVKo6iVryivcAMwQgS+zuiv6W1HeL1cJI5o2iLY17XNbIwjc5wDXNk55a0uBIadpaS0bl1b7Z7bbaJj4nu7zcWkEtIwACSC3jgnafHnIB4XwMEEEXlVZehq9aJvjg70X6RAW1etE3xwd6L9IIkE7ct6swyfHrHussT8xZBngZPFKZwGHhnt8GvQ0rWtHuR6+jahPSiUJyxGgCA9MeAO4XCNCWV0g9IAiwC6W6YBJnM2KjM0kIXDxE2JEH5hDf3qX9KgiTvBDh+RTZm/WHsR2gevCoORTZm/WHsR2gevCoIk8R9Zai8l0bG1iRX1o66cqfeE0/kl7WqEUPd7s93pB+icNb5FNmb9YexHaB68Kg5FNmb9YexHaB68KjHLDDUROilaHNdwQRkEeRB4IU45JIZA+NxDhyCOCCtLWE2ie/NIoyGe/wDahnrEorojdW037mrBfSKUgjJFP9gMb0b9ocwcOieR9R2HrROo9oAEqFQH7QjAd2PJyKbM36w9iO0D14VByKbM36w9iO0D14VHzS4dj2gK+Yyil7sn9tzmD+oOB9AArvR9o+rqSPZ3+8fO0OPuefclYWv9o6tUztxqezOGZ2UqBfgjnx2JSlhn/qIsgI5i+3HGWKjNqxk4r0qmnKkrounadVT0m05SpYkpBwd/omj1TNO/bHOO5+RTZm/WHsR2gevCoORTZm/WHsR2gevCo6li7M9E6emE9LSAyDkOeS8jqNxIB6gArRumuNT3iIxT1BDD4taA0H124yOhSh0T08NpClGgczyClhci1hZZgghODIW+QR7vSlvjwQ4fkU2Zv1h7EdoHrwqDkU2Zv1h7EdoHrwqL3gfAKqZKTxBDh+RTZm/WHsR2gevCoORTZm/WHsR2gevCoLxKAavWib44O9F+kT2YGtjSvVRGISn69xvX7oJwo5hcyVyqnaFNXKlDxMoesKYZilKnCSUOYZaxS1i07wy0+lKhOCL/2Q==";

  2. var spread = GC.Spread.Sheets.findControl("ss");
  3. var option = {
  4.     allowSelectLockedCells: true,
  5.     allowSelectUnlockedCells: true,
  6.     allowSort: true,
  7.     allowFilter: true,
  8.     allowResizeRows: true,
  9.     allowResizeColumns: true,
  10.     allowEditObjects: false,
  11.     allowDragInsertRows: true,
  12.     allowDragInsertColumns: true,
  13.     allowInsertRows: true,
  14.     allowInsertColumns: true,
  15.     allowDeleteRows: true,
  16.     allowDeleteColumns: true
  17. };
  18. var sheet = spread.getActiveSheet();
  19. sheet.options.isProtected = true;
  20. sheet.options.protectionOptions = option;

  21. sheet.suspendPaint();
  22. sheet.getRange(0,0,sheet.getRowCount(), sheet.getColumnCount()).locked(false);
  23. sheet.resumePaint();

  24. var pic = sheet.pictures.add("f5", pic, 100, 100, 100, 100);
复制代码
回复 使用道具 举报
胡小蛋
注册会员   /  发表于:2019-6-25 11:17:35
12#
KevinChen 发表于 2019-6-20 14:07
您好,只需要将表单保护打开即可,参考示例:

https://demo.grapecity.com.cn/SpreadJS/TutorialSample/ ...

有两个ssjson文件,区别是一个多一列,一个少一列,有无办法把少一列文件的内容复制到多一列文件上
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于:2019-6-25 12:19:00
13#
您好,不知道您要合并sheet表单的内容,还是要将多个Workbook合并成一个Workbook?

如果是合并多个workbook,请参考:

https://gcdn.grapecity.com.cn/fo ... hlight=%BA%CF%B2%A2
回复 使用道具 举报
胡小蛋
注册会员   /  发表于:2019-6-25 14:15:25
14#
KevinChen 发表于 2019-6-25 12:19
您好,不知道您要合并sheet表单的内容,还是要将多个Workbook合并成一个Workbook?

如果是合并多个workb ...

不是合并,这种情况是:将已有数据图片上面的数据,迁移到多一列图片上面,有没有上面实例
已有数据.png
多一列数据.png
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于:2019-6-25 17:13:57
15#
您好,要做数据迁移的话,您如果执行了数据绑定,比如单元格绑定,

那么您可以拿到绑定的数据源,然后针对另一张表格的具体位置执行填入或绑定操作。

单元格绑定示例请参考:

https://demo.grapecity.com.cn/Sp ... os/cellLevelBinding

如果没有绑定数据源,只能通过代码,按照您的业务逻辑来一一对应,没有更好的办法了。
回复 使用道具 举报
12
您需要登录后才可以回帖 登录 | 立即注册
返回顶部