sheet_common.js 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494
  1. /**
  2. * Created by Tony on 2017/4/28.
  3. */
  4. var sheetCommonObj = {
  5. // createSpread、initSheet 在一个Spread多个Sheet分别调用时的情况下使用。
  6. // buildSheet 在一个Spread、一个Sheet的情况下使用。
  7. createSpread: function (container, SheetCount) {
  8. var me = this;
  9. var spreadBook = new GC.Spread.Sheets.Workbook(container, { sheetCount: SheetCount });
  10. spreadBook.options.allowCopyPasteExcelStyle = false;
  11. spreadBook.options.allowExtendPasteRange = true;
  12. spreadBook.options.tabStripVisible = false;
  13. //spreadBook.options.showHorizontalScrollbar = false;
  14. spreadBook.options.allowUserDragDrop = false;
  15. spreadBook.options.allowUserDragFill = false;
  16. spreadBook.options.scrollbarMaxAlign = true;
  17. spreadBook.options.allowContextMenu = false;
  18. spreadBook.options.allowUndo = false;
  19. spreadBook.options.cutCopyIndicatorVisible = false;
  20. return spreadBook;
  21. },
  22. initSheet: function (sheet, setting, rowCount) {
  23. var me = this;
  24. var spreadNS = GC.Spread.Sheets;
  25. sheet.suspendPaint();
  26. sheet.suspendEvent();
  27. sheet.setRowCount(1, spreadNS.SheetArea.colHeader);
  28. sheet.setColumnCount(setting.header.length, spreadNS.SheetArea.viewport);
  29. sheet.options.colHeaderAutoTextIndex = 1;
  30. sheet.options.colHeaderAutoText = spreadNS.HeaderAutoText.numbers;
  31. sheet.options.protectionOptions = {
  32. allowResizeRows: true,
  33. allowResizeColumns: true
  34. };
  35. sheet.showRowOutline(false);
  36. sheet.options.allowCellOverflow = false;
  37. me.buildHeader(sheet, setting);
  38. if (rowCount > 0) sheet.setRowCount(rowCount);
  39. sheet.resumeEvent();
  40. sheet.resumePaint();
  41. },
  42. buildSheet: function (container, setting, rowCount, spreadOptions) {
  43. var me = this;
  44. var spreadBook = new GC.Spread.Sheets.Workbook(container, { sheetCount: 1 });
  45. spreadBook.options.tabStripVisible = false;
  46. //spreadBook.options.showHorizontalScrollbar = false;
  47. spreadBook.options.scrollbarMaxAlign = true;
  48. spreadBook.options.allowCopyPasteExcelStyle = false;
  49. spreadBook.options.cutCopyIndicatorVisible = false;
  50. spreadBook.options.allowExtendPasteRange = true;
  51. spreadBook.options.allowUserDragDrop = false;
  52. spreadBook.options.allowUserDragFill = false;
  53. spreadBook.options.allowUndo = false;
  54. spreadBook.options.allowContextMenu = false;
  55. if (spreadOptions) {
  56. Object.assign(spreadBook.options, spreadOptions)
  57. }
  58. var spreadNS = GC.Spread.Sheets;
  59. var sheet = spreadBook.getSheet(0);
  60. sheet.suspendPaint();
  61. sheet.suspendEvent();
  62. //Set rowHeader count and columnHeader count.
  63. sheet.setRowCount(1, spreadNS.SheetArea.colHeader);
  64. sheet.setColumnCount(setting.header.length, spreadNS.SheetArea.viewport);
  65. sheet.options.colHeaderAutoTextIndex = 1;
  66. sheet.options.colHeaderAutoText = spreadNS.HeaderAutoText.numbers;
  67. sheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values;
  68. sheet.options.protectionOptions = {
  69. allowResizeRows: true,
  70. allowResizeColumns: true
  71. };
  72. sheet.showRowOutline(false);
  73. //setup column header
  74. me.buildHeader(sheet, setting);
  75. //setup cells
  76. if (rowCount > 0) sheet.setRowCount(rowCount);
  77. sheet.resumeEvent();
  78. sheet.resumePaint();
  79. return spreadBook;
  80. },
  81. buildHeader: function (sheet, setting) {
  82. var me = this, ch = GC.Spread.Sheets.SheetArea.colHeader;
  83. for (var i = 0; i < setting.header.length; i++) {
  84. sheet.setValue(0, i, setting.header[i].headerName, ch);
  85. sheet.setColumnWidth(i, setting.header[i].headerWidth ? setting.header[i].headerWidth : 100);
  86. }
  87. if (setting.headerHeight) sheet.setRowHeight(0, setting.headerHeight, GC.Spread.Sheets.SheetArea.colHeader);
  88. },
  89. cleanData: function (sheet, setting, rowCount) {
  90. sheet.suspendPaint();
  91. sheet.suspendEvent();
  92. sheet.clear(-1, 0, -1, setting.header.length, GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  93. if (rowCount > 0) sheet.setRowCount(rowCount);
  94. sheet.resumeEvent();
  95. sheet.resumePaint();
  96. },
  97. cleanSheet: function (sheet, setting, rowCount) {
  98. sheet.suspendPaint();
  99. sheet.suspendEvent();
  100. sheet.clear(-1, 0, -1, setting.header.length, GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  101. if (rowCount > 0) sheet.setRowCount(rowCount);
  102. sheet.clearSelection();
  103. sheet.resumeEvent();
  104. sheet.resumePaint();
  105. },
  106. setAreaAlign: function (area, hAlign, vAlign) {
  107. if (!(hAlign) || hAlign === "left") {
  108. area.hAlign(GC.Spread.Sheets.HorizontalAlign.left);
  109. } else if (hAlign === "right") {
  110. area.hAlign(GC.Spread.Sheets.HorizontalAlign.right);
  111. } else if (hAlign === "center") {
  112. area.hAlign(GC.Spread.Sheets.HorizontalAlign.center);
  113. } else {
  114. area.hAlign(GC.Spread.Sheets.HorizontalAlign.left);
  115. }
  116. if (!(vAlign) || vAlign === "center") {
  117. area.vAlign(GC.Spread.Sheets.VerticalAlign.center);
  118. } else if (vAlign === "top") {
  119. area.vAlign(GC.Spread.Sheets.VerticalAlign.top);
  120. } else if (vAlign === "bottom") {
  121. area.vAlign(GC.Spread.Sheets.VerticalAlign.bottom);
  122. } else {
  123. area.vAlign(GC.Spread.Sheets.VerticalAlign.center);
  124. }
  125. },
  126. showData: function (sheet, setting, data, distTypeTree) {
  127. var me = this, ch = GC.Spread.Sheets.SheetArea.viewport;
  128. sheet.suspendPaint();
  129. sheet.suspendEvent();
  130. //sheet.addRows(row, 1);
  131. sheet.clear(0, 0, sheet.getRowCount(), sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  132. if (sheet.getRowCount() < data.length) {
  133. data.length < 30 ? sheet.setRowCount(30) : sheet.setRowCount(data.length);
  134. } else if (sheet.getRowCount() == 0) {
  135. sheet.setRowCount(30);
  136. }
  137. for (var col = 0; col < setting.header.length; col++) {
  138. var hAlign = "left", vAlign = "center";
  139. if (setting.header[col].hAlign) {
  140. hAlign = setting.header[col].hAlign;
  141. } else if (setting.header[col].dataType !== "String") {
  142. hAlign = "right";
  143. }
  144. vAlign = setting.header[col].vAlign ? setting.header[col].vAlign : vAlign;
  145. me.setAreaAlign(sheet.getRange(-1, col, -1, 1), hAlign, vAlign);
  146. if (setting.header[col].formatter) {
  147. sheet.setFormatter(-1, col, setting.header[col].formatter, GC.Spread.Sheets.SheetArea.viewport);
  148. }
  149. if (setting.header[col].cellType === "checkBox" || setting.header[col].cellType === "button") {//clear and reset
  150. var me = this, header = GC.Spread.Sheets.SheetArea.colHeader;
  151. sheet.deleteColumns(col, 1);
  152. sheet.addColumns(col, 1);
  153. sheet.setValue(0, col, setting.header[col].headerName, header);
  154. sheet.setColumnWidth(col, setting.header[col].headerWidth ? setting.header[col].headerWidth : 100);
  155. }
  156. if (setting.header[col].visible === false) {
  157. sheet.setColumnVisible(col, false);
  158. }
  159. sheet.getCell(0, col, GC.Spread.Sheets.SheetArea.colHeader).wordWrap(true);
  160. }
  161. for (var row = 0; row < data.length; row++) {
  162. //var cell = sheet.getCell(row, col, GC.Spread.Sheets.SheetArea.viewport);
  163. this.showRowData(sheet, setting, row, data, distTypeTree);
  164. if (setting.getStyle && setting.getStyle(data[row])) {
  165. sheet.setStyle(row, -1, setting.getStyle(data[row]));
  166. }
  167. }
  168. this.lockCells(sheet, setting);
  169. sheet.resumeEvent();
  170. sheet.resumePaint();
  171. //me.shieldAllCells(sheet);
  172. },
  173. getCheckBox(threeState = false) {
  174. var c = new GC.Spread.Sheets.CellTypes.CheckBox();
  175. c.isThreeState(threeState);
  176. return c
  177. },
  178. // 无法勾选的复选框
  179. getReadOnlyCheckBox(threeState = false) {
  180. function ReadOnlyCheckBox() { }
  181. ReadOnlyCheckBox.prototype = this.getCheckBox(threeState);
  182. ReadOnlyCheckBox.prototype.processMouseUp = function () {
  183. return;
  184. };
  185. return new ReadOnlyCheckBox();
  186. },
  187. showRowData: function (sheet, setting, row, data, distTypeTree = null) {
  188. let ch = GC.Spread.Sheets.SheetArea.viewport;
  189. for (var col = 0; col < setting.header.length; col++) {
  190. //var cell = sheet.getCell(row, col, GC.Spread.Sheets.SheetArea.viewport);
  191. var val = data[row][setting.header[col].dataCode];
  192. if (val && setting.header[col].dataType === "Number") {
  193. if (setting.header[col].hasOwnProperty('tofix')) {
  194. val = scMathUtil.roundToString(val, setting.header[col].tofix);
  195. } else {
  196. val = val + '';
  197. }
  198. }
  199. if (val != null && setting.header[col].cellType === "checkBox") {
  200. this.setCheckBoxCell(row, col, sheet, val)
  201. }
  202. if (setting.header[col].cellType === "comboBox") {
  203. this.setComboBox(row, col, sheet, setting.header[col].options, setting.header[col].editorValueType);
  204. }
  205. if (setting.header[col].getText) {
  206. val = setting.getText[setting.header[col].getText](data[row], val)
  207. }
  208. sheet.setValue(row, col, val, ch);
  209. }
  210. this.setRowStyle(row, sheet, data[row].bgColour);
  211. if (setting.autoFit == true) {
  212. sheet.getRange(row, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).wordWrap(true);
  213. sheet.autoFitRow(row);
  214. }
  215. },
  216. setCheckBoxCell(row, col, sheet, val) {
  217. var c = new GC.Spread.Sheets.CellTypes.CheckBox();
  218. c.isThreeState(false);
  219. sheet.setCellType(row, col, c, GC.Spread.Sheets.SheetArea.viewport);
  220. sheet.getCell(row, col).value(val);
  221. sheet.getCell(row, col).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
  222. },
  223. setComboBox(row, col, sheet, options, editorValueType) {
  224. //let combo = new GC.Spread.Sheets.CellTypes.ComboBox();
  225. let dynamicCombo = sheetCommonObj.getDynamicCombo(true);
  226. if (options) {
  227. dynamicCombo.itemHeight(options.length).items(options);
  228. if (editorValueType == true) {
  229. dynamicCombo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.value);
  230. }
  231. }
  232. sheet.setCellType(row, col, dynamicCombo, GC.Spread.Sheets.SheetArea.viewport);
  233. },
  234. setRowStyle(row, sheet, bgColour) {
  235. if (bgColour) {
  236. let style = new GC.Spread.Sheets.Style();
  237. style.backColor = bgColour;
  238. style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  239. style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  240. style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  241. style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  242. sheet.setStyle(row, -1, style);
  243. }
  244. },
  245. analyzePasteData: function (setting, pastedInfo) {
  246. var rst = [], propId = pastedInfo.cellRange.col, preStrIdx = 0, itemObj = {};
  247. for (var i = 0; i < pastedInfo.pasteData.text.length; i++) {
  248. if (pastedInfo.pasteData.text[i] === "\n") {
  249. propId = pastedInfo.cellRange.col;
  250. preStrIdx = i + 1;
  251. rst.push(itemObj);
  252. if (i < pastedInfo.pasteData.text.length - 1) {
  253. itemObj = {};
  254. }
  255. } else if (pastedInfo.pasteData.text[i] === "\t" || pastedInfo.pasteData.text[i] === "\r") {
  256. if (setting.header[propId]) {
  257. itemObj[setting.header[propId].dataCode] = pastedInfo.pasteData.text.slice(preStrIdx, i);
  258. }
  259. propId++;
  260. preStrIdx = i + 1;
  261. //if the last copied-cell were empty, should check whether the end of text
  262. if (i == pastedInfo.pasteData.text.length - 1 && setting.header[propId]) {
  263. itemObj[setting.header[propId].dataCode] = pastedInfo.pasteData.text.slice(preStrIdx);
  264. rst.push(itemObj);
  265. }
  266. } else if (i == pastedInfo.pasteData.text.length - 1 && setting.header[propId]) {
  267. itemObj[setting.header[propId].dataCode] = pastedInfo.pasteData.text.slice(preStrIdx);
  268. rst.push(itemObj);
  269. }
  270. }
  271. return rst;
  272. },
  273. combineRowData: function (sheet, setting, row) {
  274. var rst = {};
  275. for (var col = 0; col < setting.header.length; col++) {
  276. rst[setting.header[col].dataCode] = sheet.getValue(row, col);
  277. }
  278. return rst;
  279. },
  280. shieldAllCells: function (sheet) {
  281. sheet.options.isProtected = true;
  282. },
  283. unShieldAllCells: function (sheet) {
  284. sheet.options.isProtected = false;
  285. },
  286. unLockAllCells: function (sheet) {
  287. sheet.suspendPaint();
  288. sheet.suspendEvent();
  289. let defaultStyle = new GC.Spread.Sheets.Style();
  290. defaultStyle.locked = false;
  291. sheet.setDefaultStyle(defaultStyle, GC.Spread.Sheets.SheetArea.viewport);
  292. sheet.setStyle(-1, 0, defaultStyle);
  293. sheet.options.isProtected = false;
  294. sheet.resumePaint();
  295. sheet.resumeEvent();
  296. },
  297. lockAllCells: function (sheet) {
  298. sheet.suspendPaint();
  299. sheet.suspendEvent();
  300. let defaultStyle = new GC.Spread.Sheets.Style();
  301. defaultStyle.locked = true;
  302. sheet.setDefaultStyle(defaultStyle, GC.Spread.Sheets.SheetArea.viewport);
  303. for (let i = 0; i < sheet.getRowCount(); i++) {
  304. sheet.setStyle(i, 0, defaultStyle);
  305. }
  306. sheet.options.isProtected = true;
  307. sheet.resumePaint();
  308. sheet.resumeEvent();
  309. },
  310. lockCells: function (sheet, setting) {
  311. sheet.suspendPaint();
  312. sheet.suspendEvent();
  313. if (setting && setting.view.lockColumns && setting.view.lockColumns.length > 0) {
  314. sheet.options.isProtected = true;
  315. sheet.getRange(-1, 0, -1, setting.header.length, GC.Spread.Sheets.SheetArea.viewport).locked(false);
  316. for (var i = 0; i < setting.view.lockColumns.length; i++) {
  317. sheet.getRange(-1, setting.view.lockColumns[i], -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(true);
  318. }
  319. }
  320. sheet.resumePaint();
  321. sheet.resumeEvent();
  322. },
  323. setLockCol: function (sheet, col, isLocked) {
  324. sheet.suspendPaint();
  325. sheet.suspendEvent();
  326. for (let row = 0, len = sheet.getRowCount(); row < len; row++) {
  327. sheet.getCell(row, col).locked(isLocked);
  328. }
  329. sheet.resumePaint();
  330. sheet.resumeEvent();
  331. },
  332. chkIfEmpty: function (rObj, setting) {
  333. var rst = true;
  334. if (rObj) {
  335. for (var i = 0; i < setting.header.length; i++) {
  336. if (rObj[setting.header[i].dataCode]) {
  337. rst = false;
  338. break;
  339. }
  340. }
  341. }
  342. return rst;
  343. },
  344. //add by zhong 2017-10-10
  345. //动态下拉框
  346. getDynamicCombo: function () {
  347. let ComboCellForActiveCell = function () { };
  348. ComboCellForActiveCell.prototype = new GC.Spread.Sheets.CellTypes.ComboBox();
  349. ComboCellForActiveCell.prototype.paintValue = function (ctx, value, x, y, w, h, style, options) {
  350. let sheet = options.sheet;
  351. if (options.row === sheet.getActiveRowIndex() && options.col === sheet.getActiveColumnIndex()) {
  352. GC.Spread.Sheets.CellTypes.ComboBox.prototype.paintValue.apply(this, arguments);
  353. } else {
  354. GC.Spread.Sheets.CellTypes.Base.prototype.paintValue.apply(this, arguments);
  355. }
  356. };
  357. ComboCellForActiveCell.prototype.getHitInfo = function (x, y, cellStyle, cellRect, options) {
  358. let sheet = options.sheet;
  359. if (options.row === sheet.getActiveRowIndex() && options.col === sheet.getActiveColumnIndex()) {
  360. return GC.Spread.Sheets.CellTypes.ComboBox.prototype.getHitInfo.apply(this, arguments);
  361. } else {
  362. return GC.Spread.Sheets.CellTypes.Base.prototype.getHitInfo.apply(this, arguments);
  363. }
  364. };
  365. return new ComboCellForActiveCell();
  366. },
  367. setDynamicCombo: function (sheet, beginRow, col, rowCount, items, itemsHeight, itemsType) {
  368. let me = this;
  369. sheet.suspendPaint();
  370. let combo = me.getDynamicCombo();
  371. if (itemsHeight) {
  372. combo.itemHeight(itemsHeight);
  373. combo._maxDropDownItems = itemsHeight + 5;
  374. }
  375. if (itemsType === 'value') combo.items(items).editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.value);
  376. else if (itemsType === 'text') combo.items(items).editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
  377. else combo.items(items);
  378. for (let i = 0, len = rowCount; i < len; i++) {
  379. sheet.getCell(beginRow + i, col).cellType(combo);
  380. }
  381. sheet.resumePaint();
  382. },
  383. setStaticCombo: function (sheet, beginRow, col, rowCount, items, itemsHeight, itemsType) {
  384. sheet.suspendPaint();
  385. let combo = new GC.Spread.Sheets.CellTypes.ComboBox();
  386. for (let i = 0, len = rowCount; i < len; i++) {
  387. if (itemsHeight) combo.itemHeight(itemsHeight);
  388. if (itemsType === 'value') combo.items(items).editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.value);
  389. else if (itemsType === 'text') combo.items(items).editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
  390. else combo.items(items);
  391. sheet.getCell(beginRow + i, col).cellType(combo);
  392. }
  393. sheet.resumePaint();
  394. },
  395. //注册自定义回车键事件
  396. bindEnterKey: function (workBook, operation) {
  397. workBook.commandManager().register('myEnter', operation);
  398. workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.enter, false, false, false, false);
  399. workBook.commandManager().setShortcutKey('myEnter', GC.Spread.Commands.Key.enter, false, false, false, false);
  400. },
  401. //解决esc后触发了编辑结束的保存事件,显示与实际数据不同问题
  402. bindEscKey: function (workBook, sheets) {
  403. function isDef(v) {
  404. return typeof v !== 'undefined' && v !== null;
  405. }
  406. workBook.commandManager().register('myEsc', function () {
  407. let activeSheet = workBook.getActiveSheet();
  408. let hasTheSheet = false;
  409. for (let sheetObj of sheets) {
  410. let sheet = sheetObj.sheet;
  411. if (sheet === activeSheet) {
  412. hasTheSheet = true;
  413. let editStarting = sheetObj.editStarting;
  414. let editEnded = sheetObj.editEnded;
  415. if (editStarting) {
  416. sheet.unbind(GC.Spread.Sheets.Events.EditStarting);
  417. }
  418. if (editEnded) {
  419. sheet.unbind(GC.Spread.Sheets.Events.EditEnded);
  420. }
  421. let row = sheet.getActiveRowIndex();
  422. let col = sheet.getActiveColumnIndex();
  423. let orgV = sheet.getValue(row, col);
  424. if (!isDef(orgV)) {
  425. orgV = '';
  426. }
  427. if (sheet.isEditing()) {
  428. sheet.endEdit();
  429. sheet.setValue(row, col, orgV);
  430. }
  431. if (editStarting) {
  432. sheet.bind(GC.Spread.Sheets.Events.EditStarting, editStarting);
  433. }
  434. if (editEnded) {
  435. sheet.bind(GC.Spread.Sheets.Events.EditEnded, editEnded);
  436. }
  437. }
  438. }
  439. //容错处理,以防没把所有工作簿的表格信息传入参数
  440. if (!hasTheSheet) {
  441. if (activeSheet.isEditing()) {
  442. activeSheet.endEdit();
  443. }
  444. }
  445. });
  446. workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.esc, false, false, false, false);
  447. workBook.commandManager().setShortcutKey('myEsc', GC.Spread.Commands.Key.esc, false, false, false, false);
  448. },
  449. //生成列字段与列号映射
  450. initColMapping: function (obj, headers) {
  451. //colToField 列下标与列字段映射
  452. //fieldToCol 列字段与列下标映射
  453. let colMapping = { colToField: {}, fieldToCol: {} };
  454. for (let header of headers) {
  455. colMapping['colToField'][headers.indexOf(header)] = header.dataCode;
  456. colMapping['fieldToCol'][header.dataCode] = headers.indexOf(header);
  457. }
  458. console.log(colMapping);
  459. obj.colMapping = colMapping
  460. },
  461. //动态根据工作簿宽度和各列宽度比例设置宽度
  462. setColumnWidthByRate: function (workBookWidth, workBook, headers) {
  463. if (workBook) {
  464. const sheet = workBook.getActiveSheet();
  465. sheet.suspendEvent();
  466. sheet.suspendPaint();
  467. for (let col = 0; col < headers.length; col++) {
  468. if (headers[col]['rateWidth'] !== undefined && headers[col]['rateWidth'] !== null && headers[col]['rateWidth'] !== '') {
  469. sheet.setColumnWidth(col, workBookWidth * headers[col]['rateWidth'], GC.Spread.Sheets.SheetArea.colHeader)
  470. }
  471. else {
  472. if (headers[col]['headerWidth'] !== undefined && headers[col]['headerWidth'] !== null && headers[col]['headerWidth'] !== '') {
  473. sheet.setColumnWidth(col, headers[col]['headerWidth'], GC.Spread.Sheets.SheetArea.colHeader)
  474. }
  475. }
  476. }
  477. sheet.resumeEvent();
  478. sheet.resumePaint();
  479. }
  480. },
  481. renderSheetFunc: function (sheet, func) {
  482. sheet.suspendEvent();
  483. sheet.suspendPaint();
  484. if (func) {
  485. func();
  486. }
  487. sheet.resumeEvent();
  488. sheet.resumePaint();
  489. }
  490. }