combining excel and display in JSP / Servlet

[Tom Triolo]

Has anyone ever combined several excel files into one excel file and then displayed it either with JSP or Servlets?
Thanks,
Tom

[Debashish Chakrabarty]

I think my multiple excel files you mean having sheets in your spreadsheet. These sheets can be treated as tables. Then the rest is as usual. I remeber having used the following:

//con is connection object
//DatabaseLocation will be your fully qualified
//path for the xls file
try{
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  con = DriverManager.getConnection("jdbc :-o	 dbc :mrgreen: river={Microsoft Excel Driver (*.xls)};DBQ=" + DatabaseLocation + ";DriverID=22;READONLY=true","","");
}
catch(Exception e){
      System.err.println(e);
}

Do verify it before using this. I used this long time back. Hope this helps

[Seba Lenoir]

You can also have a look at the Apache POI project.
http://jakarta.apache.org/poi/index.html.
You can then have access to xls files without having to configure a ODBC data sources.