我已自己实现
- var rowCount = sheet.getRowCount();
- var ColCount = sheet.getColumnCount();
- if(rowCount<500){
- sheet.setRowCount(500-rowCount);
- }if(ColCount<256){
- sheet.setColumnCount(256- ColCount);
- }
- sheet.bind(GcSpread.Sheets.Events.TopRowChanged, function (sender, args) {
- var rowCount = args.sheet.getRowCount();
- var bottomRow = args.sheet.getViewportBottomRow(1);
- if (bottomRow == rowCount - 1) {
- if (rowCount < 10000) {
- args.sheet.setRowCount(rowCount + 10);
- }
- }
- });
复制代码 |