import 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();
	}
}