How to add Help menu to a Swing application

A good tester, don’t suppose customers to ramble for needy  material with application in hand. A simple help file should do the needful. Let’s jump to cram about Help file in Swing. JavaHelp is an Open Source help system. To Download JavaHelp, visit http://javahelp.java.net/. I have used Eclipse IDE for this snippet. Configuring JavaHelp in Eclipse and Creating a HelpSet will be covered in future posts.

Prerequisite

·         JavaHelp should be Downloaded.

·         HelpSet(.hs) should be available.

·         Path of HelpSet(.hs) should be configured in your current class path.

import java.awt.event.KeyEvent;

import javax.help.CSH;

import javax.help.HelpBroker;

import javax.help.HelpSet;

import javax.help.HelpSetException;

import javax.swing.Box;

import javax.swing.JFrame;

import javax.swing.JMenu;

import javax.swing.JMenuBar;

import javax.swing.JMenuItem;

public class SwingAppwithhelp

{

                JFrame appFrame;              

                JMenuBar bar;

                JMenu helpMenu ;

                JMenuItem helpMenuItem;

                HelpSet helpset;

        

               

   public static void main(String args[]){

      new SwingAppwithhelp();

   }

   public SwingAppwithhelp()

   {

                    createGUI();     

   }

                public void createGUI(){

                               

                                appFrame = new JFrame("Swing App with Help");

                                bar=new JMenuBar();        

                               

                                //Arrange components on contentPane and set Action Listeners to each component

                                arrangeComponents();

                               

                                appFrame.setSize(240,300);

                                appFrame.setResizable(false);

                                appFrame.setVisible(true);

                                appFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

                }

               

                public void arrangeComponents(){

                               

                               

                      // Move help menu to right side           

                    bar.add(Box.createHorizontalGlue());

                    helpMenu = new JMenu("Help");

                    helpMenu.setMnemonic(KeyEvent.VK_H);

                    helpMenuItem = new JMenuItem("Launch Help");

                    helpMenu.add(helpMenuItem);

                    bar.add(helpMenu);

                    appFrame.setJMenuBar(bar); 

                               

                                ClassLoader loader = null;

                    java.net.URL url = HelpSet.findHelpSet(loader, "HelpSet.hs");

                    System.out.println(url.getPath());

                    try {

         helpset = new HelpSet(loader, url);

       } catch (HelpSetException e) {

         System.err.println("Error loading");

         return;

       }

                    

                    HelpBroker helpbroker = helpset.createHelpBroker();                                                          

                               

                                helpMenuItem.addActionListener(new CSH.DisplayHelpFromSource(helpbroker));

                }   

   }

So this how your app should look like, if you followed the above code.Signing off, with this quote "We can't help everyone, but everyone can help someone"



Click Launch help menu item, to invoke Help file

Read any Row in Excel - HSSF POI

This function helps to read any row in excel using HSSF POI. Instantiate this class in your main class and call ReadRow (int, int) function by providing row & column value as parameters.

Anatomy of ReadRow () function

·         Parameters – Two integers, Former denoting row & Later for column to be referenced

·         Return value – String Value of the corresponding cell

Here we go with implementation..

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

public class ExcelRead

{

                                public ExcelRead()           {}

       public String ReadRow(int i ,int j)    {

                FileInputStream  inputStream=null;

                String cellvalue=null;     

                try

                {              //Input File to be read    

                    inputStream = new FileInputStream ("Input.xls");

                }

                catch (FileNotFoundException e)

                {

                System.out.println ("File not found in the specified path.");

                e.printStackTrace ();

                }

               

                try

                {

                HSSFWorkbook workbook = new HSSFWorkbook(inputStream);

              // Get the first sheet on the workbook.

              HSSFSheet sheet = workbook.getSheetAt(0);

              HSSFRow row=sheet.getRow(i);       

             HSSFCell myCell = row.getCell(j);            

             cellvalue=myCell.toString();        

                }

                catch(Exception e)

                {

              System.out.println ("IO Exception");

                e.printStackTrace ();

                }

                                return cellvalue;        

    }

  

    public static void main(String[] args) throws Exception {                            

                ExcelRead ob=new ExcelRead();   

         String value=null;

                value=ob.ReadRow(1,1);

                System.out.println(op);

    }   

}