com.extentech.ExtenXLS.ui
Class ExtenXLSWorkBookViewer

java.lang.Object
  java.awt.Component
      java.awt.Container
          java.awt.Window
              java.awt.Frame
                  javax.swing.JFrame
                      com.extentech.ExtenXLS.ui.ExtenXLSWorkBookViewer

All Implemented Interfaces:

com.extentech.toolkit.ExceptionListener, ImageObserver, MenuContainer, Serializable, Accessible, RootPaneContainer, WindowConstants

public class ExtenXLSWorkBookViewer
extends JFrame
implements com.extentech.toolkit.ExceptionListener

Java Swing Spreadsheet User Interface
Provides basic formatting, execution of formulas, ability to add and edit Cells, and ability to create new, edit existing, and save WorkBooks.
NOTE: ExtenXLS Swing Functionality requires additional libraries found in: /lib/sym.jar And support for XLSX further requires: /lib/jaxen-1.1-beta-5.jar /lib/xpp3-1.1.3.4.O.jar
Also demonstrates programmatic change of the Spreadsheet

                Object[][] objs = {
                        {new Integer(123),"Joe Smith", "14 South Street", "Australia"},         
                        {new Integer(234),"Billy Williams", "902 2nd Ave.", "USA"},
                        {new Integer(345),"Charles Chin", "234 Bar Bridge Blvd.", "USA"},
                        {new Integer(343),"Samantha Saludi", "87 Calgary Rd.", "Canada"}
                };

                TableModel mod =Sheet1Panel.getModel();

                // loop thru the values and set the cell values in the table model
                for(int x=0;x
        





Version:
  
4.1
Author:
  
John McMahon -- Copyright ©2011Extentech Inc.
See Also:
Serialized Form






Nested Class Summary

 
Nested classes/interfaces inherited from class java.awt.Component
Component.BaselineResizeBehavior
 



Field Summary

 
Fields inherited from class javax.swing.JFrame
EXIT_ON_CLOSE
 
Fields inherited from class java.awt.Frame
CROSSHAIR_CURSOR, DEFAULT_CURSOR, E_RESIZE_CURSOR, HAND_CURSOR, ICONIFIED, MAXIMIZED_BOTH, MAXIMIZED_HORIZ, MAXIMIZED_VERT, MOVE_CURSOR, N_RESIZE_CURSOR, NE_RESIZE_CURSOR, NORMAL, NW_RESIZE_CURSOR, S_RESIZE_CURSOR, SE_RESIZE_CURSOR, SW_RESIZE_CURSOR, TEXT_CURSOR, W_RESIZE_CURSOR, WAIT_CURSOR
 
Fields inherited from class java.awt.Component
BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT
 
Fields inherited from interface javax.swing.WindowConstants
DISPOSE_ON_CLOSE, DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE
 
Fields inherited from interface java.awt.image.ImageObserver
ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH
 



Constructor Summary
ExtenXLSWorkBookViewer()



           
ExtenXLSWorkBookViewer(String finp)



          Constructor which takes a file path.
 



Method Summary




 void
exceptionThrown(Exception e)



           



 JMenu
getJMenu1()



           



 JMenuBar
getJMenuBar1()



           



 void
init(String finp)



          Inits the Interface



 void
initUI()



          Sets the Look and Feel using JGoodies Plastic Look and Feel.



 void
initXLSPanel(String finp)



           



 void
log(String msg)



          Logs a message to System.out



static void
main(String[] args)



          Entry point for WorkBook UI



 void
showMessage(String msg,
            String title)



          Show a message dialog.



 void
Splash()



          Provides Splashing


 
Methods inherited from class javax.swing.JFrame
getAccessibleContext, getContentPane, getDefaultCloseOperation, getGlassPane, getGraphics, getJMenuBar, getLayeredPane, getRootPane, getTransferHandler, isDefaultLookAndFeelDecorated, remove, repaint, setContentPane, setDefaultCloseOperation, setDefaultLookAndFeelDecorated, setGlassPane, setIconImage, setJMenuBar, setLayeredPane, setLayout, setTransferHandler, update
 
Methods inherited from class java.awt.Frame
addNotify, getCursorType, getExtendedState, getFrames, getIconImage, getMaximizedBounds, getMenuBar, getState, getTitle, isResizable, isUndecorated, remove, removeNotify, setCursor, setExtendedState, setMaximizedBounds, setMenuBar, setResizable, setState, setTitle, setUndecorated
 
Methods inherited from class java.awt.Window
addPropertyChangeListener, addPropertyChangeListener, addWindowFocusListener, addWindowListener, addWindowStateListener, applyResourceBundle, applyResourceBundle, createBufferStrategy, createBufferStrategy, dispose, getBufferStrategy, getFocusableWindowState, getFocusCycleRootAncestor, getFocusOwner, getFocusTraversalKeys, getGraphicsConfiguration, getIconImages, getInputContext, getListeners, getLocale, getModalExclusionType, getMostRecentFocusOwner, getOwnedWindows, getOwner, getOwnerlessWindows, getToolkit, getWarningString, getWindowFocusListeners, getWindowListeners, getWindows, getWindowStateListeners, hide, isActive, isAlwaysOnTop, isAlwaysOnTopSupported, isFocusableWindow, isFocusCycleRoot, isFocused, isLocationByPlatform, isShowing, pack, paint, postEvent, removeWindowFocusListener, removeWindowListener, removeWindowStateListener, reshape, setAlwaysOnTop, setBounds, setBounds, setCursor, setFocusableWindowState, setFocusCycleRoot, setIconImages, setLocationByPlatform, setLocationRelativeTo, setMinimumSize, setModalExclusionType, setSize, setSize, setVisible, show, toBack, toFront
 
Methods inherited from class java.awt.Container
add, add, add, add, add, addContainerListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getAlignmentX, getAlignmentY, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getComponentZOrder, getContainerListeners, getFocusTraversalPolicy, getInsets, getLayout, getMaximumSize, getMinimumSize, getMousePosition, getPreferredSize, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusTraversalPolicyProvider, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, print, printComponents, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusTraversalKeys, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setFont, transferFocusBackward, transferFocusDownCycle, validate
 
Methods inherited from class java.awt.Component
action, add, addComponentListener, addFocusListener, addHierarchyBoundsListener, addHierarchyListener, addInputMethodListener, addKeyListener, addMouseListener, addMouseMotionListener, addMouseWheelListener, bounds, checkImage, checkImage, contains, contains, createImage, createImage, createVolatileImage, createVolatileImage, disable, dispatchEvent, enable, enable, enableInputMethods, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getBackground, getBaseline, getBaselineResizeBehavior, getBounds, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getHeight, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocation, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPeer, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getSize, getTreeLock, getWidth, getX, getY, gotFocus, handleEvent, hasFocus, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isDoubleBuffered, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isMaximumSizeSet, isMinimumSizeSet, isOpaque, isPreferredSizeSet, isValid, isVisible, keyDown, keyUp, list, list, list, location, lostFocus, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paintAll, prepareImage, prepareImage, printAll, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, requestFocus, requestFocusInWindow, resize, resize, setBackground, setComponentOrientation, setDropTarget, setEnabled, setFocusable, setFocusTraversalKeysEnabled, setForeground, setIgnoreRepaint, setLocale, setLocation, setLocation, setMaximumSize, setName, setPreferredSize, show, size, toString, transferFocus, transferFocusUpCycle
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 
Methods inherited from interface java.awt.MenuContainer
getFont, postEvent
 





Constructor Detail



ExtenXLSWorkBookViewer
public ExtenXLSWorkBookViewer()





ExtenXLSWorkBookViewer
public ExtenXLSWorkBookViewer(String finp)

Constructor which takes a file path.


Parameters:
finp - path to file to open





Method Detail



main
public static void main(String[] args)

Entry point for WorkBook UI





Parameters:
args - file to open





initUI
public void initUI()

Sets the Look and Feel using JGoodies Plastic Look and Feel.











init
public void init(String finp)

Inits the Interface





Parameters:
finp - 
sheetnm - 





initXLSPanel
public void initXLSPanel(String finp)











Splash
public void Splash()

Provides Splashing











exceptionThrown
public void exceptionThrown(Exception e)


Specified by:
exceptionThrown in interface com.extentech.toolkit.ExceptionListener








showMessage
public void showMessage(String msg,
                        String title)

Show a message dialog.





Parameters:
msg - 
title - 





log
public void log(String msg)

Logs a message to System.out











getJMenuBar1
public JMenuBar getJMenuBar1()











getJMenu1
public JMenu getJMenu1()