如何向text文本框中导入excel表中的数据？

[豆虫]

我要向一个text中填写一数据，由于数据库中的数据很多，用下拉列表的形式实现不太现实，所以我希望能从excel中导入到文本框中去，请高手们指点小弟一二，感激不尽了！！

[Jacky_Zhu_1983]

try {
			String fileToBeRead = request.getParameter("fileName");
			POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(
					fileToBeRead));
			HSSFWorkbook workbook = new HSSFWorkbook(fs);
			HSSFSheet sheet = workbook.getSheetAt(0);
			int rows = sheet.getPhysicalNumberOfRows();
			for (int r = 0; r < rows; r++) {
				HSSFRow row = sheet.getRow(r);
				if (row != null) {
					int cells = row.getPhysicalNumberOfCells();
					String value = "";
					for (short c = 0; c < cells; c++) {
						HSSFCell cell = row.getCell(c);
						if (cell != null) {
							switch (cell.getCellType()) {
							case HSSFCell.CELL_TYPE_FORMULA:
								//   
								break;
							case HSSFCell.CELL_TYPE_NUMERIC:
								value += (long) cell.getNumericCellValue()
										+ ",";
								break;
							case HSSFCell.CELL_TYPE_STRING:
								value += cell.getStringCellValue() + ",";
								break;
							default:
								value += ",";
							}
						}
					}
					// 下面可以处理查找到的行内容	然后返回到JSP里的
				         System.out.println(value);
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
			return mapping.findForward("error");
		}