How to read excel2007 file or both .xls and .xlsx files using apache poi

[harini veerapur]

Dear sir,
How to read a .xlsx files using poi ,i am able to read only .xls files using poi and if i read a .xlsx file it throws an exception so give me some sample code to read both .xls and .xlsx files using poi .
Thanks........

[Ulf Dittmer]

Note that POI versions before 3.5 do not support XSLX.

If you are, in fact, using a POI version that does support XLSX, post the code you're using. Knowing what exception is thrown would also be useful.

[harini veerapur]

My code as follows...

   

if (filename != null && !filename.equals("")) {//1
		try {//2
			/*int l=0;
			for(int i=0;i<arlMessage.size();i++){
			String str = (String) arlMessage.get(i);
			String s=str.replace("~","");
			int intValue=Integer.parseInt(s);
			intValue-=1;*/

			FileInputStream fs = new FileInputStream(strFileAttachment);
			Attachment = strFileAttachment.split("\n");
			HSSFWorkbook wb = new HSSFWorkbook(fs);
			for (int k = 0; k < wb.getNumberOfSheets(); k++) {//3
				HSSFSheet sheet = wb.getSheetAt(k);
				int rows = sheet.getPhysicalNumberOfRows();
				for (int r = 1; r < rows; r++) {//4
					HSSFRow row = sheet.getRow(r);
					if (row != null) {//5
						int cells = row.getPhysicalNumberOfCells();

						// int l=0;
						HSSFCell cell = row.getCell(0);
						if (cell != null) {//6
							//String value = null;
							switch (cell.getCellType()) {//7
							case HSSFCell.CELL_TYPE_FORMULA:
								value = "FORMULA ";
								break;

							case HSSFCell.CELL_TYPE_NUMERIC:
								value = "" + cell.getNumericCellValue();
								break;

							case HSSFCell.CELL_TYPE_STRING:
								value = cell.getStringCellValue();
								break;

							default:
							}//7
%><%--=value--%><input type="hidden" name="email" value="<%=value%>">
<%
	arlExcelValueEmail.add(value);
							session.setAttribute("ArrayEmailValue",
									arlExcelValueEmail);
						}//6
					}//5
				}//4
			}//3

		} //2
		catch (Exception ex) {
			ex.printStackTrace();
		}
	}//1

 

Thanks...

[Ulf Dittmer]

The HSSF* classes are for working with XLS files, not XLSX. There are other classes (in some package called *.ss.*) that work with both formats; the POI documentation has the details on that.