operate.java

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

package org.excel.model;

import java.io.File;
import java.util.ArrayList;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

public class Operate {
	
	public String queryById(int line,int row,String xlsname){
		Workbook book = null;
		String result = null;
		try {
			//获取建立好的工作薄
			 book = Workbook.getWorkbook(new File(xlsname));
			//获得第一个工作表对象
			Sheet sheet = book.getSheet(0);
			//获得单元格
			Cell cell1 = sheet.getCell(line,row);
			result = cell1.getContents();
			System.out.println(result);
			book.close();
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return result;
		
		
	
	}
}