Jakarta POI - Java API To Access Microsoft Format Files
POI 代表 Poor Obfuscation Implementation,即不良模糊化实现,绝妙!
http://jakarta.apache.org/poi/
http://jakarta.apache.org/builds/jakarta-poi/
http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/dm-0402bhogal/index.shtml
Example: access excel
POI 代表 Poor Obfuscation Implementation,即不良模糊化实现,绝妙!
http://jakarta.apache.org/poi/
http://jakarta.apache.org/builds/jakarta-poi/
http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/dm-0402bhogal/index.shtml
Example: access excel
HSSF 代表 Horrible Spreadsheet Format(可怕的电子表格格式)。
//创建
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new sheet");
HSSFHeader header = sheet.getHeader();
header.setCenter("二奶");
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell(0);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
//注意:cellValue值不能太大,具体值未知,应根据具体情况。
//eg.当超过4行时,第五行某一Cell设置>8k的,生成的文件打开将不能显示。 当只有一行时却可以。
//另外可能与机器有关,cell超长,打开生成文件时偶尔报内存不足。
cell.setCellValue("编号");
...
sheet.setGridsPrinted(true);
HSSFFooter footer = sheet.getFooter();
footer.setRight("Page " + HSSFFooter.page() + " of " +HSSFFooter.numPages());
OutputStream os = new FileOutputStream(fileName);
wb.write(os);
os.flush();
//WEB:服务端设置ContentType 类型 response.setContentType("application/vnd.ms-excel");
//读取
POIFSFileSystem fs = null;
HSSFWorkbook wb = null;
try {
fs = new POIFSFileSystem(new FileInputStream(xlsFile);
wb = new HSSFWorkbook(fs);
} catch (IOException e) {
e.printStackTrace();
}
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell(0);
String msg = cell.getStringCellValue();