[]
IRange 对象的事件参数。RangeEventArgs 用于工作表级别的事件,例如IWorksheet.getChangedEvent() 和 IWorksheet.getSelectionChangeEvent(),用于提供对与事件关联的区域的访问。
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getActiveSheet();
final IRange[] rangeFromEvent = {null};
Event<EventHandler<RangeEventArgs>> changedEvent = worksheet.getChangedEvent();
changedEvent.addListener(new EventHandler<RangeEventArgs>() {
public void invoke(Object sender, RangeEventArgs e) {
rangeFromEvent[0] = e.getRange();
}
});
worksheet.getRange("B2").setValue("Updated");
IRange changedRange = rangeFromEvent[0];
Object changedValue = changedRange.getValue();
range - 与事件关联的区域。
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getActiveSheet();
final IRange[] rangeFromEvent = {null};
Event<EventHandler<RangeEventArgs>> selectionChangeEvent = worksheet.getSelectionChangeEvent();
selectionChangeEvent.addListener(new EventHandler<RangeEventArgs>() {
public void invoke(Object sender, RangeEventArgs e) {
rangeFromEvent[0] = e.getRange();
}
});
worksheet.getRange("C3:D4").select();
IRange range = rangeFromEvent[0];
String selectedAddress = range.toString();