try{
InputStream books1 = new FileInputStream(FilePath);
jxl.Workbook rwb = Workbook.getWorkbook(books1);
Sheet rs = rwb.getSheet(0);//取得行数
int rsColumns = rs.getColumns();
//取得列数
int rsRows = rs.getRows();
String ErrorMsgeS[] = new String[rsRows];
//out.print(rsColumns);
//out.print(rsRows);int i,j,k;
String strCell[][] = new String[rsRows][rsColumns];
for (i=1;i<rsRows;i++){
for(j=0;j<rsColumns;j++){
//行列是调过来的
Cell c00 = rs.getCell(j,i);
strCell[i][j] = c00.getContents();
}
}
}catch(Exception e){}
InputStream books1 = new FileInputStream(FilePath);
jxl.Workbook rwb = Workbook.getWorkbook(books1);
Sheet rs = rwb.getSheet(0);//取得行数
int rsColumns = rs.getColumns();
//取得列数
int rsRows = rs.getRows();
String ErrorMsgeS[] = new String[rsRows];
//out.print(rsColumns);
//out.print(rsRows);int i,j,k;
String strCell[][] = new String[rsRows][rsColumns];
for (i=1;i<rsRows;i++){
for(j=0;j<rsColumns;j++){
//行列是调过来的
Cell c00 = rs.getCell(j,i);
strCell[i][j] = c00.getContents();
}
}
}catch(Exception e){}
解决方案 »
- freemarker循环输出json时,怎么去掉最后一行后面的逗号?
- 我jsp查询出来的表单如何设置成可编辑的,比方说下代码
- jdk更新数据库连接问题
- 100分,求JAVA 计算自然周
- 网页在html下可以显示图片,但是在MYECLIPSE下为JSP文件的时候怎么也打不开图片,这是为什么,代码如下,请高手指点啊~
- 为什么我在myeclipse里建的jsp运行不起来
- 分类查询代码!下拉列表、文本框、搜索数据库数据。立马给分!急!
- jive配置完成后怎么访问刚配置的论坛呢
- JavaWebStudio是国产的吗 免费吗?
- jps中这数组怎么用request传到javaBean
- JSP在2000下环境架设
- JSP里中文的问题
import java.sql.*;
public class TestExcel {
public TestExcel() throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:driver={Microsoft Excel Driver (*.xls)};DBQ=d:\\data\\mlb.xls";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String sSql;
sSql = "select * from [Sheet1$]";
ResultSet rs = stmt.executeQuery(sSql);
ResultSetMetaData meta=rs.getMetaData();
int col=meta.getColumnCount();
System.out.println("共"+col+"列");
for(int i=1;i<=col;i++){
System.out.println("第"+i+"列:"+meta.getColumnName(i)+"||类型:"+meta.getColumnType(i)+"||类型名:"+meta.getColumnTypeName(i));
}
while(rs.next()){
System.out.println(rs.getString(3)+"|"+rs.getString(5));
}
rs.getStatement().close();
stmt.close();
conn.close();
}
public static void main(String s[]) throws Exception{
new TestExcel();
}
}