java jxl 复制单元格_如何用JAVA（如poi、jxl等）读取excel文件中的下拉框单元格的值。...

import jxl.*;

import jxl.format.UnderlineStyle;

import jxl.write.*;

import jxl.write.Number;

import jxl.write.Boolean;

import java.io.*;

class excel {

public excel() {

}

/**

* 读取excel

*

* @param filepath

*/

public static void readexcel(String filepath) {

try {

InputStream is = new FileInputStream(filepath);

Workbook rwb = Workbook.getWorkbook(is);

// sheet st = rwb.getsheet("0")这里有两种方法获取sheet表,1为名字，2为下标，从0开始

Sheet st = rwb.getSheet(0);

Cell c00 = st.getCell(1, 0);

// 通用的获取cell值的方式,返回字符串

String strc00 = c00.getContents();

// 获得cell具体类型值的方式

if (c00.getType() == CellType.LABEL) {

LabelCell labelc00 = (LabelCell) c00;

strc00