一个简单的问题,大虾们快来帮帮忙啊!

Fallingstar 2002-04-02 08:37:55

用java怎样才能读取excel表中的数据!希望能给出源码!

...全文

63 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

Fallingstar 2002-04-03

打赏
举报

to CanFly(我会飞)
谢谢!
还有没有别的方法!

kkhui 2002-04-03

打赏
举报

纯java的

http://jakarta.apache.org/poi/hssf/index.html

CanFly 2002-04-03

打赏
举报

http://www.javaworld.com/javaworld/javaqa/2001-06/04-qa-0629-excel.html#resources
可以到这看看!

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

public class ExcelReader
{
public static void main( String [] args )
{
Connection c = null;
Statement stmnt = null;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection( "jdbc:odbc:qa-list", "", "" );
stmnt = c.createStatement();
String query = "select URL from [qas$] where Month='March' and Year=2000;";
ResultSet rs = stmnt.executeQuery( query );

System.out.println( "Found the following URLs for March 2000:" );
while( rs.next() )
{
System.out.println( rs.getString( "URL" ) );
}
}
catch( Exception e )
{
System.err.println( e );
}
finally
{
try
{
stmnt.close();
c.close();
}
catch( Exception e )
{
System.err.println( e );
}
}
}
}

Fallingstar 2002-04-02