上下两个range是一样的,这里打印出来都是 $B$1 参考代码: console.log(sheet.Range("B65536").End(xlUp).Address()) console.log(sheet1.Cells(sheet1.Rows.Count, "B").End(xlUp).Address())