• Post Reply Bookmark Topic Watch Topic
  • New Topic

how to implement a jsp by inputing the external excel  RSS feed

 
mike ding
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import=" org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import=" org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@page import=" org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import=" org.apache.poi.hssf.usermodel.HSSFCell"%>
<form >
<%
short a=0;
short b=1;
short c=2;
short d=3;
int i=0;
String filename ="/WebContent/myexcel.xlsx";
if (filename != null && !filename.equals("")) {
try{
FileInputStream fs =new FileInputStream(filename);
HSSFWorkbook wb = new HSSFWorkbook(fs);
for (int k = 0; k < wb.getNumberOfSheets(); k++){
int j=i+1;
%>
Sheet <%=j%><%
HSSFSheet sheet = wb.getSheetAt(k);
int rows = sheet.getPhysicalNumberOfRows();
for (int r = 1; r < rows; r++){
HSSFRow row = sheet.getRow(r);
if (row != null) {
int cells = row.getPhysicalNumberOfCells(); %><br><%
HSSFCell cell1 = row.getCell(a);
if (cell1 != null){
String value = null;
switch (cell1.getCellType()){
case HSSFCell.CELL_TYPE_FORMULA :
value = "FORMULA ";
break;
case HSSFCell.CELL_TYPE_NUMERIC :
value = ""+cell1.getNumericCellValue();
break;
case HSSFCell.CELL_TYPE_STRING :
value = cell1.getStringCellValue();
break;
}
%>
<input type="text" name="roll" value="<%=value%>"><%
}
HSSFCell cell2 = row.getCell(b);
if (cell2 != null){
String value = null;
switch (cell2.getCellType()){
case HSSFCell.CELL_TYPE_FORMULA :
value = "FORMULA ";
break;
case HSSFCell.CELL_TYPE_NUMERIC :
value = ""+cell2.getNumericCellValue();
break;
case HSSFCell.CELL_TYPE_STRING :
value = cell2.getStringCellValue();
break;
}%>
<input type="text" name="name" value="<%=value%>">
<% }
HSSFCell cell3 = row.getCell(c);
if (cell3 != null){
String value = null;
switch (cell3.getCellType()){
case HSSFCell.CELL_TYPE_FORMULA :
value = "FORMULA ";
break;
case HSSFCell.CELL_TYPE_NUMERIC :
value = ""+cell3.getNumericCellValue();
break;
case HSSFCell.CELL_TYPE_STRING :
value = cell3.getStringCellValue();
break;
} %>
<input type="text" name="marks" value="<%=value%>">
<% }
HSSFCell cell4 = row.getCell(d);
if (cell4 != null){
String value = null;
switch (cell4.getCellType()){
case HSSFCell.CELL_TYPE_FORMULA :
value = "FORMULA ";
break;
case HSSFCell.CELL_TYPE_NUMERIC :
value = ""+cell4.getNumericCellValue();
break;
case HSSFCell.CELL_TYPE_STRING :
value = cell4.getStringCellValue();
break;
}
%> <input type="text" name="grade" value="<%=value%>">
<% } }%>
<input type="submit" value="Edit">
<% }%>
<br><br><br><br><%
i++;}}
catch (Exception ex){
} }
%> </form>

i deployed the above code to the jboss server, but it seemed that it didn't work, can you shed some lights on this?
thanks in advance.
 
Stefan Evans
Bartender
Posts: 1834
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Some suggestions
1 - Don't do java code in a JSP. Thats what java classes are for
2 - Use CODE tags when posting code. There is even a handy button for "Code" when you post your message. Also format your code so it is more readable.

3 -"it didn't work"... what didn't work? What did you expect? What does it do? Are there any exceptions? anything printed in the log?

Will removing the bit of code that catches all exceptions and silently swallow them help you diagnose your issue?


 
Paul Clapham
Sheriff
Posts: 22185
38
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


My crystal ball says that there is no such file on the host server. However it just came back from the repair shop and it might not be calibrated just right.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!