Open File xls

[karno]

hi I am new in Java i had code this to open file .xls in java...
but why i dont get all of data in the file .xls..
any body help me.....???

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;
import javax.swing.JFileChooser;
import javax.swing.filechooser.FileNameExtensionFilter;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 *
 * @author ifnu
 */
public class Main {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws IOException {
        JFileChooser chooser = new JFileChooser();
        chooser.setCurrentDirectory(new  File(System.getProperty("user.home")));
        chooser.setFileFilter(new FileNameExtensionFilter("Excell File (*.xls)", "xls","XLS"));
        chooser.showOpenDialog(null);
        if(chooser.getSelectedFile()!=null){
            File selectedFile = chooser.getSelectedFile();
            HSSFWorkbook workbook = new HSSFWorkbook(new        FileInputStream(selectedFile));
            HSSFSheet sheet = workbook.getSheetAt(0);
            HSSFRow row = null;
            
            for(int i =0;i<=sheet.getLastRowNum();i++){
                row = sheet.getRow(i);
                 System.out.println(row.getCell((short)0).getRichStringCellValue().getString());
                System.out.println(row.getCell((short)1).getRichStringCellValue().getString());
                System.out.println(String.valueOf((int)row.getCell((short)2).getNumericCellValue()));
                System.out.println(row.getCell((short)4).getDateCellValue());
                System.out.println(new BigDecimal(row.getCell((short)5).getNumericCellValue()));
               
            }
           
        }
    }

}

:confused:

[Eranga]

Did you come up with any error?

[karno]

how I get the number of sheet of .xls file in java ?
i am using jdk 1.6 and POI 3.6 ...

[FON]

	InputStream inp = new FileInputStream("workbook.xls");
HSSFWorkbook workbook = new HSSFWorkbook(new POIFSFileSystem(inp));
	
System.out.println("Number Of Sheets:" +  workbook.getNumberOfSheets() );
		
	int numberOfSheets = workbook.getNumberOfSheets();
		
	for ( int i = 0; i < numberOfSheets; i++) {
		 HSSFSheet sheet = workbook.getSheetAt(i);
		 System.out.println(sheet.getSheetName());
	}

[karno]

thank you FON ....
i've got it