java读取excel文件内容

java读取excel文件内容

					<div> 
														 BretGui															
														 2024-10-27 07:55:34 

				</div>
									<pre>&lt;!-- jxl 操作excel --&gt;<br/>

<dependency>

&lt;groupId&gt;org.jxls&lt;/groupId&gt;<br/>
&lt;artifactId&gt;jxls-jexcel&lt;/artifactId&gt;<br/>
&lt;version&gt;1.0.6&lt;/version&gt;<br/>

</dependency>

jxl.Workbook wb =null;

InputStream is = new FileInputStream(“D://G201.xls”);

wb = Workbook.getWorkbook(is);

wb.getSheet(0);

sheet.getRow(j)

package com.bret.test;
import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;

import org.junit.Test;
import java.io.FileInputStream;

import java.io.IOException;

import java.io.InputStream;
public class ExcelUtil {
@Test


public void test(){<br/>
    try{<br/>
        jxl.Workbook wb =null;<br/>
        InputStream is = new FileInputStream(&#34;D://G201.xls&#34;);<br/>
        wb = Workbook.getWorkbook(is);


int sheetSize = wb.getNumberOfSheets();


        Sheet sheet = wb.getSheet(0);<br/>
        int row_total = sheet.getRows();<br/>
        for (int j = 0; j &lt; row_total; j++) {<br/>
            if(j == 0){<br/>
                Cell[] cells = sheet.getRow(j);


System.out.println(cells[0].getContents());


                System.out.println(cells[1].getContents());<br/>
                System.out.println(cells[2].getContents());<br/>
            }<br/>
        }<br/>
    }catch (IOException e) {<br/>
        // TODO Auto-generated catch block<br/>
        e.printStackTrace();<br/>
    } catch (BiffException e){<br/>
        e.printStackTrace();<br/>
    }<br/>
}


}

														<div>