readxls.java

来自「java实现动态更新,可以利用javascipt和远程java的互动完成」· Java 代码 · 共 38 行

package org.excel.demo;

import java.io.File;
import java.io.IOException;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.WritableWorkbook;

public class ReadXLS {
	public Workbook book = null;
	public Sheet sheet = null;
	public  void create() throws BiffException, IOException
	{
		book = Workbook.getWorkbook(new File("test.xls"));
		//获得第一个工作表对象
		/*sheet = book.getSheet(0);
		//获得第一行第一列的单元格
		Cell cell1 = sheet.getCell(45,0);
		String result = cell1.getContents();
		System.out.println(result);*/
		book.close();
	}
	public static void main(String[] args) throws BiffException, IOException {
		ReadXLS rx = new ReadXLS();
		rx.create();
		rx.book = Workbook.getWorkbook(new File("test.xls"));
		rx.sheet = rx.book.getSheet(0);
		Cell cell1 = rx.sheet.getCell(45,0);
		String result = cell1.getContents();
		System.out.println(result);
		
		
	}
}