从Excel复制了100行数据过来，但是监听脏数据改变，只监听到29行

Lynn.Dou

从Excel复制了100行数据过来，但是监听脏数据改变，只监听到29行
企业微信截图_1635148492103.png159219054.png

如何可以监听到全部改变

Lynn.Dou · Lynn.Dou

根据您提供的json，测试SpreadJS无法导入，如下图，您可以实际测试下：
image.png706607360.png

请提供完整正确的json。

Lynn.Dou · Lynn.Dou

您好，
根据您的描述测试如下：1、从Excel复制114行数据，粘贴至SJS
2、调用 getDirtyRows 方法，获取脏行，结果如下图：
未复现您描述的问题。
image.png657753905.png

如果我的理解有误，请直接提供可复现此问题的简单demo，并详细描述复现步骤。
附件为demo模板，您可以在模板基础上添加自己的代码。

柠能 · 柠能

Lynn.Dou 发表于 2021-10-25 17:22
您好，
根据您的描述测试如下：1、从Excel复制114行数据，粘贴至SJS
2、调用 getDirtyRows 方法，获取脏 ...

{"allowExtendPasteRange":true,"customList":[],"docProps":{"docPropsApp":{"AppVersion":"16.0300","Application":"Microsoft Excel","Company":"","DocSecurity":"0","HeadingPairs":{"baseType":"variant","size":2,"workbookInfoArray":[{"elementType":"vt:lpstr","value":"工作表"},{"elementType":"vt:i4","value":"1"}]},"HyperlinksChanged":"false","LinksUpToDate":"false","ScaleCrop":"false","SharedDoc":"false","TitlesOfParts":{"baseType":"lpstr","sheetsNameArray":["Sheet1"],"size":1}},"docPropsCore":{"created":"2015-06-05T18:17:20Z","creator":"Qi QD Wang","lastModifiedBy":"Qi QD Wang","modified":"2021-10-18T11:23:01Z"}},"iterativeCalculation":false,"iterativeCalculationMaximumChange":0.001,"iterativeCalculationMaximumIterations":100,"namedStyles":[{"backColor":"Accent 1 80","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"20% - Accent1","themeFont":"Body"},{"backColor":"Accent 2 80","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"20% - Accent2","themeFont":"Body"},{"backColor":"Accent 3 80","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"20% - Accent3","themeFont":"Body"},{"backColor":"Accent 4 80","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"20% - Accent4","themeFont":"Body"},{"backColor":"Accent 5 80","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"20% - Accent5","themeFont":"Body"},{"backColor":"Accent 6 80","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"20% - Accent6","themeFont":"Body"},{"backColor":"Accent 1 60","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"40% - Accent1","themeFont":"Body"},{"backColor":"Accent 2 60","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"40% - Accent2","themeFont":"Body"},{"backColor":"Accent 3 60","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"40% - Accent3","themeFont":"Body"},{"backColor":"Accent 4 60","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"40% - Accent4","themeFont":"Body"},{"backColor":"Accent 5 60","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"40% - Accent5","themeFont":"Body"},{"backColor":"Accent 6 60","font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","name":"40% - Accent6","themeFont":"Body"},{"backColor":"Accent 1 40","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"60% - Accent1","themeFont":"Body"},{"backColor":"Accent 2 40","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"60% - Accent2","themeFont":"Body"},{"backColor":"Accent 3 40","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"60% - Accent3","themeFont":"Body"},{"backColor":"Accent 4 40","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"60% - Accent4","themeFont":"Body"},{"backColor":"Accent 5 40","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"60% - Accent5","themeFont":"Body"},{"backColor":"Accent 6 40","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"60% - Accent6","themeFont":"Body"},{"backColor":"Accent 1 0","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"Accent1","themeFont":"Body"},{"backColor":"Accent 2 0","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"Accent2","themeFont":"Body"},{"backColor":"Accent 3 0","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"Accent3","themeFont":"Body"},{"backColor":"Accent 4 0","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"Accent4","themeFont":"Body"},{"backColor":"Accent 5 0","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"Accent5","themeFont":"Body"},{"backColor":"Accent 6 0","font":"normal normal 14.7px Calibri","foreColor":"Background 1 0","name":"Accent6","themeFont":"Body"},{"backColor":"#ffc7ce","font":"normal normal 14.7px Calibri","foreColor":"#9c0006","name":"Bad","themeFont":"Body"},{"backColor":"#f2f2f2","borderBottom":{"color":"#7f7f7f","style":1},"borderLeft":{"color":"#7f7f7f","style":1},"borderRight":{"color":"#7f7f7f","style":1},"borderTop":{"color":"#7f7f7f","style":1},"diagonalDown":null,"diagonalUp":null,"font":"normal bold 14.7px Calibri","foreColor":"#fa7d00","name":"Calculation","themeFont":"Body"},{"backColor":"#a5a5a5","borderBottom":{"color":"#3f3f3f","style":6},"borderLeft":{"color":"#3f3f3f","style":6},"borderRight":{"color":"#3f3f3f","style":6},"borderTop":{"color":"#3f3f3f","style":6},"diagonalDown":null,"diagonalUp":null,"font":"normal bold 14.7px Calibri","foreColor":"Background 1 0","name":"Check Cell","themeFont":"Body"},{"backColor":null,"formatter":"_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)","name":"Comma"},{"backColor":null,"formatter":"_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)","name":"Comma [0]"},{"backColor":null,"formatter":"_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_)","name":"Currency"},{"backColor":null,"formatter":"_("$"* #,##0_);_("$"* (#,##0);_("$"* "-"_);_(@_)","name":"Currency [0]"},{"backColor":null,"font":"italic normal 14.7px Calibri","foreColor":"#7f7f7f","name":"Explanatory Text","themeFont":"Body"},{"backColor":"#c6efce","font":"normal normal 14.7px Calibri","foreColor":"#006100","name":"Good","themeFont":"Body"},{"backColor":null,"borderBottom":{"color":"Accent 1 0","style":5},"borderLeft":null,"borderRight":null,"borderTop":null,"diagonalDown":null,"diagonalUp":null,"font":"normal bold 20px Calibri","foreColor":"Text 2 0","name":"Heading 1","themeFont":"Body"},{"backColor":null,"borderBottom":{"color":"Accent 1 50","style":5},"borderLeft":null,"borderRight":null,"borderTop":null,"diagonalDown":null,"diagonalUp":null,"font":"normal bold 17.3px Calibri","foreColor":"Text 2 0","name":"Heading 2","themeFont":"Body"},{"backColor":null,"borderBottom":{"color":"Accent 1 40","style":2},"borderLeft":null,"borderRight":null,"borderTop":null,"diagonalDown":null,"diagonalUp":null,"font":"normal bold 14.7px Calibri","foreColor":"Text 2 0","name":"Heading 3","themeFont":"Body"},{"backColor":null,"font":"normal bold 14.7px Calibri","foreColor":"Text 2 0","name":"Heading 4","themeFont":"Body"},{"backColor":"#ffcc99","borderBottom":{"color":"#7f7f7f","style":1},"borderLeft":{"color":"#7f7f7f","style":1},"borderRight":{"color":"#7f7f7f","style":1},"borderTop":{"color":"#7f7f7f","style":1},"diagonalDown":null,"diagonalUp":null,"font":"normal normal 14.7px Calibri","foreColor":"#3f3f76","name":"Input","themeFont":"Body"},{"backColor":null,"borderBottom":{"color":"#ff8001","style":6},"borderLeft":null,"borderRight":null,"borderTop":null,"diagonalDown":null,"diagonalUp":null,"font":"normal normal 14.7px Calibri","foreColor":"#fa7d00","name":"Linked Cell","themeFont":"Body"},{"backColor":"#ffeb9c","font":"normal normal 14.7px Calibri","foreColor":"#9c6500","name":"Neutral","themeFont":"Body"},{"backColor":null,"borderBottom":null,"borderLeft":null,"borderRight":null,"borderTop":null,"diagonalDown":null,"diagonalUp":null,"font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","hAlign":3,"locked":true,"name":"Normal","textIndent":0,"themeFont":"Body","vAlign":2,"wordWrap":false},{"backColor":"#ffffcc","borderBottom":{"color":"#b2b2b2","style":1},"borderLeft":{"color":"#b2b2b2","style":1},"borderRight":{"color":"#b2b2b2","style":1},"borderTop":{"color":"#b2b2b2","style":1},"diagonalDown":null,"diagonalUp":null,"name":"Note"},{"backColor":"#f2f2f2","borderBottom":{"color":"#3f3f3f","style":1},"borderLeft":{"color":"#3f3f3f","style":1},"borderRight":{"color":"#3f3f3f","style":1},"borderTop":{"color":"#3f3f3f","style":1},"diagonalDown":null,"diagonalUp":null,"font":"normal bold 14.7px Calibri","foreColor":"#3f3f3f","name":"Output","themeFont":"Body"},{"backColor":null,"formatter":"0%","name":"Percent"},{"backColor":null,"font":"normal bold 24px Calibri Light","foreColor":"Text 2 0","name":"Title","themeFont":"Headings"},{"backColor":null,"borderBottom":{"color":"Accent 1 0","style":6},"borderLeft":null,"borderRight":null,"borderTop":{"color":"Accent 1 0","style":1},"diagonalDown":null,"diagonalUp":null,"font":"normal bold 14.7px Calibri","foreColor":"Text 1 0","name":"Total","themeFont":"Body"},{"backColor":null,"font":"normal normal 14.7px Calibri","foreColor":"#ff0000","name":"Warning Text","themeFont":"Body"},{"backColor":null,"borderBottom":null,"borderLeft":null,"borderRight":null,"borderTop":null,"diagonalDown":null,"diagonalUp":null,"font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","formatter":"General","hAlign":3,"locked":true,"name":"__builtInStyle1","textIndent":0,"themeFont":"Body","vAlign":2,"wordWrap":false},{"backColor":"Background 2 -10","borderBottom":{"color":"#000000","style":1},"borderLeft":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"diagonalDown":null,"diagonalUp":null,"font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","formatter":"General","hAlign":3,"locked":true,"name":"__builtInStyle2","textIndent":0,"themeFont":"Body","vAlign":2,"wordWrap":true},{"backColor":null,"borderBottom":null,"borderLeft":null,"borderRight":null,"borderTop":null,"diagonalDown":null,"diagonalUp":null,"font":"normal normal 14.7px Calibri","foreColor":"Text 1 0","formatter":"_ * #,##0.00_ ;_ * \\-#,##0.00_ ;_ * "-"??_ ;_ @_ ","hAlign":0,"locked":true,"name":"__builtInStyle3","textIndent":0,"themeFont":"Body","vAlign":0,"wordWrap":true}],"sheets":{"Sheet1":{"activeCol":11,"activeRow":5,"autoMergeRangeInfos":[],"cellStates":{},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"columnOutlines":{"items":[]},"columns":[null,{"size":123},{"size":104},null,null,null,null,null,{"size":88}],"comments":[{"colIndex":3,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZCHBURS02","zIndex":830},{"colIndex":4,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZGROUP2","zIndex":832},{"colIndex":5,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZCATG","zIndex":834},{"colIndex":6,"rowIndex":5,"text":"nn:col\n$bw_field:CALDAY","zIndex":836},{"colIndex":7,"rowIndex":5,"text":"nn:col\n$bw_field:VENDOR","zIndex":838},{"colIndex":8,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZBP_TX","zIndex":840},{"colIndex":9,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZBPLB","zIndex":860},{"colIndex":10,"rowIndex":5,"text":"nn:col\n$bw_field:PRODUCT","zIndex":862},{"colIndex":14,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZHB_HSJE","zIndex":872},{"colIndex":15,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZHB_SE","zIndex":874},{"colIndex":16,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZHB_BHSJE","zIndex":876},{"colIndex":17,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZHB_CGSL","zIndex":878},{"colIndex":18,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZHB_CGZL","zIndex":880},{"colIndex":19,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZHB_JJSL","zIndex":882},{"colIndex":2,"rowIndex":5,"text":"nn:col\n$bw_field:ENTITY","zIndex":896},{"colIndex":0,"rowIndex":0,"text":"nn:page\n$source:BW\n$model:ZHBMT040\n$active:row\n$bw_cdt:C6\n$CDT:CC_ENTITY","zIndex":881},{"colIndex":13,"rowIndex":5,"text":"nn:col\n$bw_field:BASE_UOM","zIndex":883},{"colIndex":12,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZPROD_C","zIndex":892},{"colIndex":11,"rowIndex":5,"text":"nn:col\n$bw_field:BIC_ZPROD_T","zIndex":898}],"data":{"dataTable":{"0":{"0":{"style":{"borderBottom":{"color":"rgba(255,255,255,0)"},"borderLeft":{"color":"rgba(255,255,255,0)"},"borderRight":{"color":"rgba(255,255,255,0)"},"borderTop":{"color":"rgba(255,255,255,0)"}}},"1":{"style":{"borderBottom":{"color":"rgba(255,255,255,0)"},"borderLeft":{"color":"rgba(255,255,255,0)"},"borderRight":{"color":"rgba(255,255,255,0)"},"borderTop":{"color":"rgba(255,255,255,0)"},"font":"14.7px 微软雅黑","vAlign":1}}},"1":{"0":{"style":{"borderBottom":{"color":"rgb(0, 0, 0)","style":1},"borderLeft":{"color":"rgb(0, 0, 0)","style":1},"borderRight":{"color":"rgb(0, 0, 0)","style":1},"borderTop":{"color":"rgb(0, 0, 0)","style":1},"font":"700 13.3px 微软雅黑","vAlign":1},"value":"公司"},"1":{"style":{"borderBottom":{"color":"rgb(0, 0, 0)","style":1},"borderLeft":{"color":"rgb(0, 0, 0)","style":1},"borderRight":{"color":"rgb(0, 0, 0)","style":1},"borderTop":{"color":"rgb(0, 0, 0)","style":1},"font":"13.3px 微软雅黑","vAlign":1},"value":"E0101_北京正大饲料有限公司"}},"2":{"0":{"style":{"borderBottom":{"color":"rgb(0, 0, 0)","style":1},"borderLeft":{"color":"rgb(0, 0, 0)","style":1},"borderRight":{"color":"rgb(0, 0, 0)","style":1},"borderTop":{"color":"rgb(0, 0, 0)","style":1},"font":"700 13.3px 微软雅黑","hAlign":0,"vAlign":1},"value":"期间"},"1":{"style":{"borderBottom":{"color":"rgb(0, 0, 0)","style":1},"borderLeft":{"color":"rgb(0, 0, 0)","style":1},"borderRight":{"color":"rgb(0, 0, 0)","style":1},"borderTop":{"color":"rgb(0, 0, 0)","style":1},"font":"13.3px 微软雅黑","vAlign":1},"value":"0.00"}},"5":{"2":{"style":"__builtInStyle2","value":"公司代码"},"3":{"style":"__builtInStyle2","value":"公司名称"},"4":{"style":"__builtInStyle2","value":"大区"},"5":{"style":"__builtInStyle2","value":"板块"},"6":{"style":"__builtInStyle2","value":"日期"},"7":{"style":"__builtInStyle2","value":"供应商代码"},"8":{"style":"__builtInStyle2","value":"供应商名称"},"9":{"style":"__builtInStyle2","value":"供应商类别"},"10":{"style":"__builtInStyle2","value":"产品代码"},"11":{"style":"__builtInStyle2","value":"产品名称"},"12":{"style":"__builtInStyle2","value":"产品类别"},"13":{"style":"__builtInStyle2","value":"单位"},"14":{"style":"__builtInStyle2","value":"含税金额(不含运费)"},"15":{"style":"__builtInStyle2","value":"税额"},"16":{"style":"__builtInStyle2","value":"不含税金额"},"17":{"style":"__builtInStyle2","value":"采购数量"},"18":{"style":"__builtInStyle2","value":"采购重量"},"19":{"style":"__builtInStyle2","value":"计价数量"}},"6":{"2":{"style":"__builtInStyle3","value":"$fs:ENTITY\n$at:md\n$act:ENTITY[l]"},"3":{"style":"__builtInStyle3","value":"$fs:BIC_ZCHBURS02\n$point:C7"},"4":{"style":"__builtInStyle3","value":"$fs:BIC_ZGROUP2\n$point:C7"},"5":{"style":"__builtInStyle3","value":"$fs:BIC_ZCATG\n$point:C7"},"6":{"style":"__builtInStyle3","value":"$fs:CALDAY\n$point:C7"},"7":{"style":"__builtInStyle3","value":"$fs:VENDOR\n$point:C7"},"8":{"style":"__builtInStyle3","value":"$fs:BIC_ZBP_TX\n$point:C7"},"9":{"style":"__builtInStyle3","value":"$fs:BIC_ZBPLB\n$point:C7"},"10":{"style":"__builtInStyle3","value":"$fs:PRODUCT\n$point:C7"},"11":{"style":"__builtInStyle3","value":"$fs:BIC_ZPROD_T\n$point:C7"},"12":{"style":"__builtInStyle3","value":"$fs:BIC_ZPROD_C\n$point:C7"},"13":{"style":"__builtInStyle3","value":"$fs:BASE_UOM\n$point:C7"},"14":{"style":"__builtInStyle3","value":"$fs:BIC_ZHB_HSJE\n$point:C7"},"15":{"style":"__builtInStyle3","value":"$fs:BIC_ZHB_SE\n$point:C7"},"16":{"style":"__builtInStyle3","value":"$fs:BIC_ZHB_BHSJE\n$point:C7"},"17":{"style":"__builtInStyle3","value":"$fs:BIC_ZHB_CGSL\n$point:C7"},"18":{"style":"__builtInStyle3","value":"$fs:BIC_ZHB_CGZL\n$point:C7"},"19":{"style":"__builtInStyle3","value":"$fs:BIC_ZHB_JJSL\n$point:C7"}},"7":{"7":{"value":""}},"8":{"12":{"value":""}}},"defaultDataNode":{"style":{"backColor":null,"borderBottom":null,"borderLeft":null,"borderRight":null,"borderTop":null,"diagonalDown":null,"diagonalUp":null,"font":"normal normal 14.7px Calibri","fontForColumnWidth":"normal normal 14.7px 等线","foreColor":"Text 1 0","locked":true,"textIndent":0,"themeFont":"Body","vAlign":2,"wordWrap":false},"tag":"c_sht-g7539mwrtyx"}},"defaults":{"_isExcelDefaultColumnWidth":true,"colHeaderRowHeight":20,"colWidth":72,"rowHeaderColWidth":40,"rowHeight":19},"frozenTrailingColumnStickToEdge":true,"frozenTrailingRowStickToEdge":true,"index":0,"isSelected":true,"leftCellIndex":6,"name":"Sheet1","outlineColumnOptions":{},"printInfo":{"margin":{"bottom":72,"footer":29,"header":29,"left":67,"right":67,"top":72},"pageOrder":1,"paperSize":{"height":1100,"kind":1,"width":850}},"rowCount":29,"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"rowOutlines":{"items":[]},"rows":[{"size":19},null,null,null,null,{"size":57},{"size":94.26249694824219}],"selections":{"0":{"col":11,"colCount":1,"row":5,"rowCount":1},"length":1},"shapeCollectionOption":{"snapMode":0},"states":{},"theme":"Office","topCellIndex":0}},"tabStripRatio":0.6,"version":"14.1.6"}

复制代码

我的场景是先渲染了这个sheet，然后在这个sheet上复制粘贴

		自动登录	找回密码
密码			立即注册

[已处理] 从Excel复制了100行数据过来，但是监听脏数据改变，只监听到29行

最佳答案

3 个回复

浏览过的版块

SpreadJS 认证

SpreadJS 高级认证

讲师达人

悬赏达人