15 Responses so far.

1. asposeseo says:

   18th July 2013 at 9:41 am

   I have found an API that uses java language to not only read excel file but also create and convert MS Office documents even if you don’t have Office installed.

   • Nits says:

     18th July 2013 at 10:07 am

     Thats fantastic mate, it would be good for organisations willing to pay for the product though… as its a licensed product.

2. Sujith says:

   22nd July 2012 at 4:52 am

   Can u breif the idea that how a time value can be read from excel. I will make it little bit clear. The excel column with format time. For example i have value as ‘1:12:23 AM’. The HSSFRow is raeding that value as a date itself. So my time ‘1:12:23 AM’ becomes 1899-12-12. So is there any way i can handle this situation?

   • Nits says:

     22nd July 2012 at 8:58 am

     Hi Sujit,

     I did this years ago and can’t remember the details but surely you will have to use a custome date formatter to pick it in the desired format.

3. Dheeraj Umardand says:

   26th September 2011 at 6:54 am

   Hello sir,
   I want to open an image in excelsheet.Is this possible ?

4. sridharkandula says:

   27th June 2011 at 4:23 am

   hi nithin i have a small problem while reading the excel sheet data what iam trying to do is trying to read the the date values from one cell and time values from another cell but as both are using the same class so iam getting the values in time format or date format iam not able to get how to differentiate the both the below is my sample code thanks in advance

   if (HSSFDateUtil.isCellDateFormatted(cell)) {
   // format in form of M/D/YY

   cal.setTime(HSSFDateUtil.getJavaDate(num));
   cellText = (String.valueOf(cal.get(Calendar.YEAR))).substring(2);
   cellText = cal.get(Calendar.MONTH)+1 + “/” +cal.get(Calendar.DAY_OF_MONTH) + “/” +cellText;

   // cal.setTime(cell.getDateCellValue());

   datetext = cal.get(Calendar.HOUR) + “:” +cal.get(Calendar.MINUTE) + “:” +cal.get(Calendar.SECOND);

   }

5. 2010 in review « Nitin's JAVA and SOA BLOG says:

   2nd January 2011 at 8:37 am

   […] Reading contents of Excel using java code February 20098 comments 3 […]

6. PTZ Network camera says:

   1st December 2010 at 12:20 am

   Thanks for taking the time to discuss this, I feel strongly about information and love learning more on this. If possible,it is very helpful for me.

7. Writing to Excel using java code | nitinaggarwal says:

   10th July 2009 at 3:35 pm

   […] order to read from an excel file Click Here : […]

8. raj1402 says:

   26th June 2009 at 5:47 am

   i got a class file what next !!!

9. Sandeep Manyam says:

   14th May 2009 at 1:26 pm

   Hello, I have already wrote a program to read data from an Excel file using POI API. Now the problem is I want to dump that read data into Oracle database. Can u provide me code to do that. The following is the code I have written for reading the data. Please guide if I have done anything wrong.

   import org.apache.poi.hssf.usermodel.HSSFCell;
   import org.apache.poi.hssf.usermodel.HSSFRichTextString;
   import org.apache.poi.hssf.usermodel.HSSFRow;
   import org.apache.poi.hssf.usermodel.HSSFSheet;
   import org.apache.poi.hssf.usermodel.HSSFWorkbook;
   import org.apache.poi.poifs.filesystem.POIFSFileSystem;

   import java.io.*;
   import java.util.*;
   import java.sql.*;
   /**
   * This java program is used to read the data from a Excel file and display them
   * on the console output.
   *
   * @author Sandeep
   */
   public class POIExcelReader
   {
   /** Creates a new instance of POIExcelReader */
   public POIExcelReader ()
   {
   try
   {
   Class.forName(“oracle.jdbc.driver.OracleDriver”);
   Connection con = DriverManager.getConnection(“jdbc:oracle:thin:@localhost:1521:xe”, “scott”, “tiger”);
   Statement stmt=con.createStatement();
   }
   catch(Exception e)
   {
   e.printStackTrace();
   }
   }
   /**
   * This method is used to display the Excel content to command line.
   * @param xlsPath
   */
   @SuppressWarnings (“unchecked”)
   public void displayFromExcel (String xlsPath)
   {
   InputStream inputStream = null;
   try
   {
   inputStream = new FileInputStream (xlsPath);
   }
   catch (FileNotFoundException e)
   {
   System.out.println (“File not found in the specified path.”);
   e.printStackTrace ();
   }
   POIFSFileSystem fileSystem = null;
   try
   {
   fileSystem = new POIFSFileSystem (inputStream);
   HSSFWorkbook workBook = new HSSFWorkbook (fileSystem);
   HSSFSheet sheet = workBook.getSheetAt (0);
   Iterator rows = sheet.rowIterator ();
   while (rows.hasNext ())
   {
   HSSFRow row = rows.next ();
   // once get a row its time to iterate through cells.
   Iterator cells = row.cellIterator ();
   while (cells.hasNext ())
   {
   HSSFCell cell = cells.next ();
   // Now we will get the cell type and display the values accordingly.
   System.out.println();
   switch (cell.getCellType ())
   {
   case HSSFCell.CELL_TYPE_NUMERIC :
   {
   // cell type numeric.
   System.out.print (cell.getNumericCellValue ()+”t”);
   break;
   }
   case HSSFCell.CELL_TYPE_STRING :
   {
   // cell type string.
   HSSFRichTextString richTextString = cell.getRichStringCellValue();
   System.out.print (richTextString.getString()+”t”);
   break;
   }
   default :
   {
   // types other than String and Numeric.
   System.out.println (“Type not supported.”);
   break;
   }
   }
   System.out.println();
   }
   }
   }
   catch (IOException e)
   {
   e.printStackTrace ();
   }
   }
   public static void main (String[] args)
   {
   POIExcelReader poiExample = new POIExcelReader ();
   String xlsPath = “e:/data.xls”;
   poiExample.displayFromExcel(xlsPath);
   }
   }

10. Nitin says:

    14th March 2009 at 11:12 am

    Hi Meera, Looking at the issue you are facing, i would advice you to recreate a fresh excel file and try to read that. Because it might have to do with the excel file you are using.
    Its working fine for everybody else and I haven’t received any other complaints, still I would be happy to resolve your query.

    In case you still face the issue, share your error stack trace. this will provide me a better insight of the problem.

11. Meerasaaheb says:

    10th March 2009 at 1:48 pm

    I am running the code . But it is raising an exception stating that Unable to read entire header; 22 bytes read; expected 512 bytes.
    Can u please help me……………………??????
    Thanks in advance.
    I want to read the contents of the cell

12. Writing to Excel using java code « Nitinaggarwal’s Blog says:

    21st February 2009 at 12:29 am

    […] order to read from an excel file Click Here : […]

    • Nitin says:

      26th June 2009 at 6:45 am

      Answers will be provided on my new site only.
      and please elaborate your problem.