i am trying to retrieve data from an Excel file using servlet
could you please tell me why this code does not work.i dont get any error while i compile,i dont get any output as well.
my code
package mypackage1;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.InputStream;
import java.io.IOException;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.poifs.files
ystem.POIF
SFileSyste
m;
import org.apache.poi.hssf.record
.*;
import org.apache.poi.hssf.model.
*;
import org.apache.poi.hssf.usermo
del.*;
//org.apache.poi.hssf.user
model.HSSF
Cell
import org.apache.poi.hssf.util.*
;
import org.apache.poi.poifs.event
filesystem
.POIFSRead
er;
import jxl.*;
public class Test2 extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
{
PrintWriter out = response.getWriter();
response.setContentType("t
ext/html")
;
//String path = getServletContext().getRea
lPath("/Bo
ok1.xsl");
try {
//FileReader objFile =new FileReader("C:/Book1.xls")
;
//POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("C:/Book1.
xls"));
// System.out.println(fs);
//POIFSReader pfr = new POIFSReader();
//InputStream ins = new InputStream(new FileReader("C:/Book1.xls")
);
/* myxls = null;
try {
myxls = new FileInputStream("Book1.xsl
");
}*/
//HSSFWorkbook wb = new HSSFWorkbook(ins);
//HSSFSheet sheet1 = wb.getSheetAt(1);
//HSSFCell sheet=new HSSFCell(wb,sheet1,1,1);
jxl.Workbook workbook = jxl.Workbook.getWorkbook(n
ew File("C:/Book1.xls"));
jxl.Sheet sheet=workbook.getSheet(0)
;
Cell a1 = sheet.getCell(0,0);
Cell b2 = sheet.getCell(1,1);
Cell c2 = sheet.getCell(2,1);
String stringa1 = a1.getContents();
String stringb2 = b2.getContents();
String stringc2 = c2.getContents();
System.out.print(stringa1)
;
System.out.print(stringb2)
;
System.out.print(stringc2)
;
out.println(stringa1);
out.println(stringb2);
out.println(stringc2);
//pfr.read(ins);
} catch (FileNotFoundException e)
{
System.out.println("File not found");
}
catch(Exception e)
{
System.out.println(e.getMe
ssage());
}
}
}
Start Free Trial