| 12
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 
 |  
package packExcel;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.OutputStream;
 
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
 
/**
 * Servlet implementation class ExcelWeb
 */
public class ExcelWeb extends HttpServlet {
	private static final long serialVersionUID = 1L;
 
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ExcelWeb() {
        super();
        // TODO Auto-generated constructor stub
    }
 
	/**
         * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
         */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		try {
		      OutputStream out = response.getOutputStream();
 
		      response.setContentType("application/vnd.ms-excel");
 
		      //response.setHeader("Content-disposition", "inline; filename=monfichier.xls");  // attachment
		      response.setHeader("Content-disposition", "attachment; filename=monfichier.xls");
 
		      HSSFWorkbook wb = new HSSFWorkbook();
 
		      HSSFSheet sheet = wb.createSheet("ma feuille");
 
		      HSSFRow row = sheet.createRow(0);
		      HSSFCell cell = row.createCell((short) 0);
		      cell.setCellValue(10);
 
		      row.createCell((short) 1).setCellValue(20);
 
		      wb.write(out);
		      out.flush();
		      out.close();
		    } catch (FileNotFoundException e) {
		      e.printStackTrace();
		    } catch (IOException e) {
		      e.printStackTrace();
		    }
	}
 
	/**
         * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
         */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}
 
} | 
Partager