Database Excel Export

1. Create an Excel template (Demo.xls)

2. Write Test class

 Public Static void Main(String args[]) { Public void Showhouse(HttpServletRequest request,httpservletresponse response)throwsioexception{Suitevo Suitevo =New Suitevo(); Suitevo.setaddress("Shanghai"); Suitevo.Setarea(300d); Suitevo.setfacedirection(2); Suitevo.Setsuitenum(" the"); Suitevo.Setfloornum( -); Suitevo SuiteVo1 =New Suitevo(); SuiteVo1.setaddress("Shanghai"); SuiteVo1.Setarea(300d); SuiteVo1.setfacedirection(2); SuiteVo1.Setsuitenum(" the"); SuiteVo1.Setfloornum( -); list<suitevo> details =NewArraylist<> (); Details.Add(Suitevo); Details.Add(SUITEVO1); Excelutils.AddValue("PrintDate",NewDate ()); Excelutils.AddValue("List", details); Excelutils.AddValue("Suitevo", Suitevo); String config ="Demo.xls"; Response.Reset(); Response.setContentType("Application/vnd.ms-excel");Try{excelutils.Export(config, response.Getoutputstream()); }Catch(FileNotFoundException ex) {System. out.println("file path not found"); }Catch(Excelexception ex) {          }    }

3. After running, get Response.xls file as follows:

Official homepage

Database Excel Export