[]
        
首页
开发者学堂
文档
论坛
市场
生态机会
活动
立即试用
(Showing Draft Content)

RangeEventArgs

Class RangeEventArgs

java.lang.Object
com.grapecity.documents.excel.EventArgs
com.grapecity.documents.excel.RangeEventArgs

public class RangeEventArgs extends EventArgs
表示包含 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();
 
  • Constructor Details

    • RangeEventArgs

      public RangeEventArgs(IRange range)
      为指定区域创建事件参数。
      Parameters:
      range - 与事件关联的区域。
  • Method Details

    • getRange

      public final IRange getRange()
      获取与事件关联的区域。
      
       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();
       
      Returns:
      事件区域。