java操作excel表（看到的別人的文章）

package excel;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream; import jxl.Cell;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;

public class ReadExcel
{
public void readExcel()
{
try {
//構建Workbook物件, 只讀Workbook物件
//直接從本地檔案建立Workbook //從輸入流建立Workbook
File file = new File("E:/temp/HodeOA_2005/Book1.xls");
InputStream is = new FileInputStream(file);
Workbook rwb = Workbook.getWorkbook(is);

//獲得工作薄（Workbook）中工作表（Sheet）的個數
//int sheets = rwb.getNumberOfSheets();
//返回工作薄（Workbook）中工作表（Sheet）物件陣列
Sheet[] sheets = rwb.getSheets();
for (int i = 0; i {
System.out.println("-------------------------------");
System.out.println("【工作表Sheet"+i+"的資訊】");
//獲取獲取工作表（Sheet）的名稱
String sheetName = sheets[i].getName();
System.out.println("Sheet名稱:" + sheetName);
//獲取Sheet表中所包含的總列數
int rsColumns = sheets[i].getColumns();
System.out.println("Sheet總列數:" + rsColumns);
//獲取Sheet表中所包含的總行數
int rsRows = sheets[i].getRows();
System.out.println("Sheet總行數:" + rsRows);
//逐行輸出單元格資訊
System.out.println("Sheet內容:" + rsRows);
for (int j = 0; j {
System.out.print("行"+j+":");
//獲取某一行的所有單元格，返回的是單元格物件陣列，示例子：
Cell[] cell = sheets[i].getRow(j);
for (int k = 0; k {
//獲取單元內容
String cellContent = cell[k].getContents();
//獲取單元型別
CellType cellType= cell[k].getType();

System.out.print(" "+cellContent+"["+cellType+"] ");
}
System.out.println();
}
}
rwb.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}

public static void main(String[] args)
{
ReadExcel re = new ReadExcel();
re.readExcel();
}
}
[@more@]package excel;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream; import jxl.Cell;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;

public class ReadExcel
{
public void readExcel()
{
try {
//構建Workbook物件, 只讀Workbook物件
//直接從本地檔案建立Workbook //從輸入流建立Workbook
File file = new File("E:/temp/HodeOA_2005/Book1.xls");
InputStream is = new FileInputStream(file);
Workbook rwb = Workbook.getWorkbook(is);

//獲得工作薄（Workbook）中工作表（Sheet）的個數
//int sheets = rwb.getNumberOfSheets();
//返回工作薄（Workbook）中工作表（Sheet）物件陣列
Sheet[] sheets = rwb.getSheets();
for (int i = 0; i {
System.out.println("-------------------------------");
System.out.println("【工作表Sheet"+i+"的資訊】");
//獲取獲取工作表（Sheet）的名稱
String sheetName = sheets[i].getName();
System.out.println("Sheet名稱:" + sheetName);
//獲取Sheet表中所包含的總列數
int rsColumns = sheets[i].getColumns();
System.out.println("Sheet總列數:" + rsColumns);
//獲取Sheet表中所包含的總行數
int rsRows = sheets[i].getRows();
System.out.println("Sheet總行數:" + rsRows);
//逐行輸出單元格資訊
System.out.println("Sheet內容:" + rsRows);
for (int j = 0; j {
System.out.print("行"+j+":");
//獲取某一行的所有單元格，返回的是單元格物件陣列，示例子：
Cell[] cell = sheets[i].getRow(j);
for (int k = 0; k {
//獲取單元內容
String cellContent = cell[k].getContents();
//獲取單元型別
CellType cellType= cell[k].getType();

System.out.print(" "+cellContent+"["+cellType+"] ");
}
System.out.println();
}
}
rwb.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}

public static void main(String[] args)
{
ReadExcel re = new ReadExcel();
re.readExcel();
}
}