aspose file tools*
The moose likes Servlets and the fly likes Reading excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Reading excel file" Watch "Reading excel file" New topic
Author

Reading excel file

Sundar Gopal
Greenhorn

Joined: Jun 20, 2003
Posts: 17
can anybody tell me how to read an excel file stored in the client machine thru a servlet and populate the datas to the db .


Regards,<br />SundarGopal.<br />Scjp, Scwcd, Scbcd.
din dee
Greenhorn

Joined: Aug 11, 2004
Posts: 9
I have the coding abt to read excel sheet shell by sheel and and store the Database (oracle). using jsp,servlet,VO
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12803
    
    5
Interpreting an EXCEL file in Java can be done with the HSSF toolkit from the Apache POI project.
Bill
Sundar Gopal
Greenhorn

Joined: Jun 20, 2003
Posts: 17
hi,
thanks for your response. i used poi only to generate the excel file and i send it to client with a URL in it. the client after modifying the excel when he cliks the url has to update the modified data to the db. this is the scenario.
if i use HSSS i am not getting the values in the excel from the client side since i cannot load the file from the client and read it.
i am having a java class which reads the data good. but if i access the class via servlet its not working. my java class is like this........

package excel;

/**
* @author gsundar
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/


import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;

public class ExcelReaderClass{
public static void main( String [] args )
{
Connection c = null;
Statement stmnt = null;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection( "jdbc dbc:Report_sheet");
stmnt = c.createStatement();

String table = "Report_Sheet$";

String query = "select * from" +"\"" + table + "\"";
ResultSet rs = stmnt.executeQuery(query);

System.out.println( "Found the following in the excel:" );
while( rs.next() )
{
System.out.print( rs.getString(1)+" " );
System.out.print( rs.getString(2)+" " );
System.out.print( rs.getString(3)+" " );
System.out.print( rs.getString(4)+" " );
}
}
catch( Exception e )
{
System.err.println( "Exception in class :"+e );
}
finally
{
try
{
stmnt.close();
c.close();
}
catch( Exception e )
{
System.err.println("Exception in connection close() :"+ e );
}
}
}
}
Sundar Gopal
Greenhorn

Joined: Jun 20, 2003
Posts: 17
but the above java class also works only if i configure datasource in my system for the excel file so that each worksheet will be like a table. this is not the solution i am searching for. i am in need of a better solution. your valueble inputs highly appreciated...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading excel file