Revision history [back]

click to hide/show revision 1
initial version

asked 2020-09-11 01:42:33 +0800

bztom35 gravatar image bztom35

Extract Celldata from a selection

How to extract cell data selection for example for A1:A10?

  public void onCellSelection$ss(CellSelectionEvent event){

   System.out.println("selected range: " +  Ranges.getAreaRefString(event.getSheet() , event.getArea()));

 Range selectedRange = Ranges.range(ss.getSelectedSheet(),event.getRow(),event.getColumn());
         System.out.println("Selected row: " +   selectedRange .toRowRange().getCellEditText() + " "  +   selectedRange.getCellEditText());

}

Extract Celldata celldata from a selectionthe last selected position in Spreadsheet (keikai 5.x)

How to extract cell data selection for the end position of the selected cell? For example for A1:A10?A1:A10, I wnat to get the print out of A10.

  public void onCellSelection$ss(CellSelectionEvent event){

   System.out.println("selected range: " +  Ranges.getAreaRefString(event.getSheet() , event.getArea()));

 Range selectedRange = Ranges.range(ss.getSelectedSheet(),event.getRow(),event.getColumn());
         System.out.println("Selected row: " +   selectedRange .toRowRange().getCellEditText() + " "  +   selectedRange.getCellEditText());

}

Extract celldata from the last selected position in Spreadsheet (keikai 5.x)

How to extract the end position of the selected cell? For example for A1:A10, I wnat want to get the print out cell content of A10.

  public void onCellSelection$ss(CellSelectionEvent event){

   System.out.println("selected range: " +  Ranges.getAreaRefString(event.getSheet() , event.getArea()));

 Range selectedRange = Ranges.range(ss.getSelectedSheet(),event.getRow(),event.getColumn());
         System.out.println("Selected row: " +   selectedRange .toRowRange().getCellEditText() + " "  +   selectedRange.getCellEditText());

}

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More