在依賴中找到j(luò)excel的源碼，我們只需要關(guān)注scrollControls (滾動(dòng)控制)，updateFreezePosition(更新凍結(jié)位置) 這兩個(gè)方法：
obj.scrollControls = function(e) {
obj.wheelControls()
if (obj.options.freezeColumns > 0 && obj.content.scrollLeft != scrollLeft) {
obj.updateFreezePosition()
}
// Close editor
if (obj.options.lazyLoading == true || obj.options.tableOverflow == true) {
if (obj.edition && e.target.className.substr(0, 9) != 'jdropdown') {
obj.closeEditor(obj.edition[0], true)
}
}
}
obj.updateFreezePosition = function() {
scrollLeft = obj.content.scrollLeft
var width = 0
if (scrollLeft > 50) {
for (var i = 0; i < obj.options.freezeColumns; i++) {
if (i > 0) {
width += parseInt(obj.options.columns[i - 1].width)
}
obj.headers[i].classList.add('jexcel_freezed')
obj.headers[i].style.left = width + 'px'
for (var j = 0; j < obj.rows.length; j++) {
if (obj.rows[j] && obj.records[j][i]) {
var shifted = scrollLeft + (i > 0 ? obj.records[j][i - 1].style.width : 0) - 51 + 'px'
obj.records[j][i].classList.add('jexcel_freezed')
obj.records[j][i].style.left = shifted
}
}
}
} else {
for (var i = 0; i < obj.options.freezeColumns; i++) {
obj.headers[i].classList.remove('jexcel_freezed')
obj.headers[i].style.left = ''
for (var j = 0; j < obj.rows.length; j++) {
if (obj.records[j][i]) {
obj.records[j][i].classList.remove('jexcel_freezed')
obj.records[j][i].style.left = ''
}
}
}
}
// Place the corner in the correct place
obj.updateCornerPosition()
}
這里面有個(gè)bug，就是合并單元格列數(shù)大于凍結(jié)列數(shù)，拖動(dòng)橫向滾動(dòng)條無限延伸，其實(shí)也很好理解，因?yàn)樗创a寫的就是將單元格加上凍結(jié)類名,固定左側(cè)，如果凍結(jié)兩列，而合并列有20列，拖動(dòng)橫向滾動(dòng)條，合并的單元格就無限延伸了。我目前想到比較簡(jiǎn)單粗暴的方法是合并列的單元格不加凍結(jié)類名。
2.源碼上加上凍結(jié)行的功能(clickReportItem是jexcel實(shí)例，因?yàn)槲易龅淖远x報(bào)表，有多個(gè)jexcel表格，如果你只有一個(gè)jexcel表格，直接用你創(chuàng)建的實(shí)例替換就可以了)：
clickReportItem.spread.scrollControls = function (e) {
clickReportItem.spread.wheelControls()
// 拖動(dòng)滾動(dòng)條距離超過凍結(jié)行列寬，高度
if (
(clickReportItem.freezeColumns > 0 && clickReportItem.spread.content.scrollLeft != scrollLeft) ||
(clickReportItem.freezeRows > 0 && clickReportItem.spread.content.scrollTop != scrollTop)
) {
clickReportItem.spread.updateFreezePosition()
}
// Close editor
if (
clickReportItem.spread.options.lazyLoading == true ||
clickReportItem.spread.options.tableOverflow == true
) {
if (clickReportItem.spread.edition && e.target.className.substr(0, 9) != 'jdropdown') {
clickReportItem.spread.closeEditor(clickReportItem.spread.edition[0], true)
}
}
}
var scrollTop = 0
// 更新凍結(jié)位置
clickReportItem.spread.updateFreezePosition = function () {
scrollTop = clickReportItem.spread.content.scrollTop
var width = 0
var height = 0
// 凍結(jié)行
if (scrollTop > 0) {
for (let i = 0; i < clickReportItem.freezeRows; i++) {
if (i > 0) {
height += parseInt(clickReportItem.spread.records[i - 1][0].style.height)
}
for (let j = 0; j < clickReportItem.spread.records[i].length; j++) {
if (clickReportItem.spread.rows[i] && clickReportItem.spread.records[i][j]) {
let shifted = scrollTop - 1 + 'px'
// 當(dāng)前行下標(biāo)(data-y:從0開始計(jì)算，加一)
let rowIndex =
(clickReportItem.spread.rows[i].getAttribute('data-y')
? Number(clickReportItem.spread.rows[i].getAttribute('data-y'))
: 0) + 1
let rowspan = clickReportItem.spread.records[i][j].getAttribute('rowspan')
? Number(clickReportItem.spread.records[i][j].getAttribute('rowspan'))
: 0
// 合并至第幾行(rowspan包括當(dāng)前行，減一)
let mergeRowIndex = rowIndex + rowspan - 1
if (
!(
clickReportItem.spread.records[i][j].getAttribute('data-merged') &&
mergeRowIndex > clickReportItem.freezeRows
)
) {
clickReportItem.spread.records[i][j].classList.add('jexcel_freezed')
clickReportItem.spread.records[i][j].style.top = shifted
}
}
}
}
} else {
for (let i = 0; i < clickReportItem.freezeRows; i++) {
for (let j = 0; j < clickReportItem.spread.records[i].length; j++) {
if (clickReportItem.spread.rows[i] && clickReportItem.spread.records[i][j]) {
// 合并單元格列數(shù)大于凍結(jié)列數(shù)，不加凍結(jié)類名，否則無限延伸
clickReportItem.spread.records[i][j].classList.remove('jexcel_freezed')
clickReportItem.spread.records[i][j].style.top = 0
}
}
}
}
// Place the corner in the correct place
clickReportItem.spread.updateCornerPosition()
}
