rendered paste bodyimport javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.io.File;import jxl.*;import java.util.*;import jxl.read.biff.*;import java.util.ArrayList;import java.util.Iterator;import java.util.ListIterator;public class Appli extends HttpServlet implements Servlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { res.setContentType("text/xml"); // instanciation du buffer de sortie PrintWriter out = res.getWriter(); out.println("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); out.println("<elements>"); try{ JExcel jxl = new JExcel("/home/xwz/public_html/jexcel/xls/input.xls"); String act = req.getParameter("action"); if(act != null && act.equals("details")){ out.println("<tabs>"); String[] names = jxl.getSheetNames(); int n = names.length; for(int i=0; i < n; i++) out.println("<tab>"+names[i]+"</tab>"); out.println("</tabs>"); }else if(act != null && act.equals("HNumList")){ String title = req.getParameter("title"); String line = req.getParameter("line"); if(!title.equals(null) && !line.equals(null)){ ArrayList<Double> l = jxl.getHorizontalNumberList("Feuille1", Integer.decode(line), title); Iterator<Double> itr = l.iterator(); out.println("<values>"); while (itr.hasNext()) out.println("<value>"+itr.next()+"</value>"); out.println("</values>"); }else{ out.println("<errors>"); if(title.equals(null)) out.println("<error>le titre de colonne doit etre definit</error>"); if(line.equals(null)) out.println("<error>la ligne contenant les titres de colonnes doit etre definit</error>"); out.println("</errors>"); } }else{ out.println("<errors>"); out.println("<error>Une action doit etre definie</error>"); out.println("</errors>"); } }catch(IOException e){ out.println("IOException"); out.println(e.getMessage()); }catch(BiffException e){ out.println("BiffException"); out.println(e.getMessage()); } out.println("</elements>"); out.close(); }}