/**
* 读取Excel流
*/
POIFSFileSystem fs = new POIFSFileSystem(in);
// 得到Excel工作簿对象
HSSFWorkbook wb = new HSSFWorkbook(fs);
for (int i = 0; i < wb.getNumberOfSheets(); i++) {
HSSFSheet sheet = wb.getSheetAt(i);
for (int j = 0; j <= sheet.getLastRowNum(); j++) {
HSSFRow row = sheet.getRow(j);
for (int k = 0; k < row.getLastCellNum(); k++) {
HSSFCell cell = row.getCell((short) k);
System.out.print("\t"+cell.toString());
}
System.out.println();
}
System.out.println("\n");
}
/**
* 生成Excel
* @throws Exception
*/
public HSSFWorkbook exportExcel() throws Exception
{
HSSFWorkbook wb = new HSSFWorkbook();
// 设置样式
HSSFCellStyle topStyle = wb.createCellStyle();
HSSFCellStyle infoStyle = wb.createCellStyle();
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载