java - Excel not getting exported in proper format -

java - Excel not getting exported in proper format -

i trying export info excel using jsp. not getting exported in excel format, whole html page getting exported. dont know how utilize apache poi. using below code

response.setheader("content-disposition", "attachment;filename=name.xls"); response.setcontenttype("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet);

check this tutorial

you need utilize poi libary, , can write info excel file simple code , this:

//blank workbook xssfworkbook workbook = new xssfworkbook(); //create blank sheet xssfsheet sheet = workbook.createsheet("employee data"); //this info needs written (object[]) map<string, object[]> info = new treemap<string, object[]>(); data.put("1", new object[] {"id", "name", "lastname"}); data.put("2", new object[] {1, "amit", "shukla"}); data.put("3", new object[] {2, "lokesh", "gupta"}); data.put("4", new object[] {3, "john", "adwards"}); data.put("5", new object[] {4, "brian", "schultz"}); //iterate on info , write sheet set<string> keyset = data.keyset(); int rownum = 0; (string key : keyset) { row row = sheet.createrow(rownum++); object [] objarr = data.get(key); int cellnum = 0; (object obj : objarr) { cell cell = row.createcell(cellnum++); if(obj instanceof string) cell.setcellvalue((string)obj); else if(obj instanceof integer) cell.setcellvalue((integer)obj); } } seek { //write workbook in file scheme fileoutputstream out = new fileoutputstream(new file("howtodoinjava_demo.xlsx")); workbook.write(out); out.close(); system.out.println("howtodoinjava_demo.xlsx written on disk."); } grab (exception e) { e.printstacktrace(); }

java excel