import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class test {
public static void main(String[] args) {
File file = new File("/home/c/下載/SCHEMA(1).xls");
BufferedInputStream in;
try {
in = new BufferedInputStream(new FileInputStream(
file));
POIFSFileSystem fs = new POIFSFileSystem(in);
Workbook workbook = new HSSFWorkbook(fs);
Sheet sheet = null;
Row row = null;
int rowCount = 0;
if (null != workbook) {
sheet = workbook.getSheetAt(32);// sheet的位置0开始
} else {
throw new Exception();
}
rowCount = sheet.getPhysicalNumberOfRows();
StringBuffer a =new StringBuffer();
for (int i = 1; i <= rowCount; i++) {
row = sheet.getRow(i);
if (row == null) {
continue;
}
a = a.append(row.getCell(1).getRichStringCellValue().getString()).append(",");
}
System.out.print(a);
} catch (Exception e) {
e.printStackTrace();
}
}
}