POI是Apache的一个开源项目,它支持使用纯Java方式的操作Word、Excel以及PowerPoint等Microsoft格式的文件。它包含了HSSF、HWPF、HSLF、HPSF和POI-Utils等几个子项目。其中HSSF是纯Java实现Excel ''97(-2007)文件格式的子项目。不过HSSF还不支持Excel2007的.xlsx文件格式,因为该格式不是基于OLE2的。
HSSF提供了创建、修改、读取和写入XLS文件的方式,这里通过一个简单的例子来演示它的使用方法:
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.Region;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class ExcelHandler ...{
private HSSFSheet sheet;
private HSSFWorkbook wb;
public ExcelHandler() ...{
}
private boolean writeCellHeader() ...{
// 表头单元格的字体样式
HSSFFont font = wb.createFont();
// 高度
font.setFontHeightInPoints((short) 12);
// 表头单元格的对齐方式
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style.setFont(font);
// 创建第一行
HSSFRow hssfRowHeader = sheet.createRow(0);
// 创建单元格
HSSFCell cell = hssfRowHeader.createCell((short) 0);
// 设置单元格样式
cell.setCellStyle(style);
// 设置单元格值
cell.setCellValue(new HSSFRichTextString("序号"));
// 合并单元格,Region中的参数依次为:行索引、列索引、行索引+要合并的行数、列索引+要合并的列数
// 注意:涉及到列的参数都是short类型,需要强制类型转化
sheet.addMergedRegion(new Region(0, (short) 0, 1, (short) 0));
HSSFCell cellBasicInfo = hssfRowHeader.createCell((short) 1);
cellBasicInfo.setCellStyle(style);
cellBasicInfo.setCellValue(new HSSFRichTextString("基本信息"));
sheet.addMergedRegion(new Region(0, (short) 1, 0, (short) 3));
// 创建第二行
HSSFRow hssfRowHeader1 = sheet.createRow(1);
// 第二行的单元格
HSSFCell cellName = hssfRowHeader1.createCell((short) 1);
cellName.setCellValue(new HSSFRichTextString("姓名"));
HSSFCell cellAge = hssfRowHeader1.createCell((short) 2);
cellAge.setCellValue(new HSSFRichTextString("年龄"));
HSSFCell cellHeight = hssfRowHeader1.createCell((short) 3);
cellHeight.setCellValue(new HSSFRichTextString("身高"));
return true;
}
private boolean writeCellData() ...{
//创建数据行
HSSFRow row = sheet.createRow(2);
//依次写入序号、姓名、年龄和身高等信息
HSSFCell cellNum = row.createCell((short) 0);
cellNum.setCellValue(1);
HSSFCell cellName = row.createCell((short) 1);
cellName.setCellValue(new HSSFRichTextString("张三"));
HSSFCell cellAge = row.createCell((short) 2);
cellAge.setCellValue(18);
HSSFCell cellHeight = row.createCell((short) 3);
cellHeight.setCellValue(183);
return true;
}
public boolean createFile(String filePath) ...{
try ...{
File file = new File(filePath);
if (file.exists()) ...{
// 如果文件存在,则读取以后表单(sheet)
POIFSFileSystem tempPS = new POIFSFileSystem(
new FileInputStream(filePath));
wb = new HSSFWorkbook(tempPS);
sheet = wb.getSheetAt(0);
} else ...{
// 文件不存在则创建新的Workbook和Sheet
wb = new HSSFWorkbook();
sheet = wb.createSheet("sheet1");
}
writeCellHeader();
if (writeCellData()) ...{
//通过文件输出流保存文件到本地
FileOutputStream fos = new FileOutputStream(filePath);
wb.write(fos);
//关闭输出流
fos.close();
}
} catch (Exception e) ...{
e.printStackTrace();
return false;
}
return true;
}
/** *//**
* @param args
*/
public static void main(String[] args) ...{
ExcelHandler handler = new ExcelHandler();
handler.createFile("c:/test.xls");
}
}
文章出处:http://www.diybl.com/course/3_program/java/javajs/2008224/100834.html?
HSSF提供了创建、修改、读取和写入XLS文件的方式,这里通过一个简单的例子来演示它的使用方法:
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.Region;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class ExcelHandler ...{
private HSSFSheet sheet;
private HSSFWorkbook wb;
public ExcelHandler() ...{
}
private boolean writeCellHeader() ...{
// 表头单元格的字体样式
HSSFFont font = wb.createFont();
// 高度
font.setFontHeightInPoints((short) 12);
// 表头单元格的对齐方式
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style.setFont(font);
// 创建第一行
HSSFRow hssfRowHeader = sheet.createRow(0);
// 创建单元格
HSSFCell cell = hssfRowHeader.createCell((short) 0);
// 设置单元格样式
cell.setCellStyle(style);
// 设置单元格值
cell.setCellValue(new HSSFRichTextString("序号"));
// 合并单元格,Region中的参数依次为:行索引、列索引、行索引+要合并的行数、列索引+要合并的列数
// 注意:涉及到列的参数都是short类型,需要强制类型转化
sheet.addMergedRegion(new Region(0, (short) 0, 1, (short) 0));
HSSFCell cellBasicInfo = hssfRowHeader.createCell((short) 1);
cellBasicInfo.setCellStyle(style);
cellBasicInfo.setCellValue(new HSSFRichTextString("基本信息"));
sheet.addMergedRegion(new Region(0, (short) 1, 0, (short) 3));
// 创建第二行
HSSFRow hssfRowHeader1 = sheet.createRow(1);
// 第二行的单元格
HSSFCell cellName = hssfRowHeader1.createCell((short) 1);
cellName.setCellValue(new HSSFRichTextString("姓名"));
HSSFCell cellAge = hssfRowHeader1.createCell((short) 2);
cellAge.setCellValue(new HSSFRichTextString("年龄"));
HSSFCell cellHeight = hssfRowHeader1.createCell((short) 3);
cellHeight.setCellValue(new HSSFRichTextString("身高"));
return true;
}
private boolean writeCellData() ...{
//创建数据行
HSSFRow row = sheet.createRow(2);
//依次写入序号、姓名、年龄和身高等信息
HSSFCell cellNum = row.createCell((short) 0);
cellNum.setCellValue(1);
HSSFCell cellName = row.createCell((short) 1);
cellName.setCellValue(new HSSFRichTextString("张三"));
HSSFCell cellAge = row.createCell((short) 2);
cellAge.setCellValue(18);
HSSFCell cellHeight = row.createCell((short) 3);
cellHeight.setCellValue(183);
return true;
}
public boolean createFile(String filePath) ...{
try ...{
File file = new File(filePath);
if (file.exists()) ...{
// 如果文件存在,则读取以后表单(sheet)
POIFSFileSystem tempPS = new POIFSFileSystem(
new FileInputStream(filePath));
wb = new HSSFWorkbook(tempPS);
sheet = wb.getSheetAt(0);
} else ...{
// 文件不存在则创建新的Workbook和Sheet
wb = new HSSFWorkbook();
sheet = wb.createSheet("sheet1");
}
writeCellHeader();
if (writeCellData()) ...{
//通过文件输出流保存文件到本地
FileOutputStream fos = new FileOutputStream(filePath);
wb.write(fos);
//关闭输出流
fos.close();
}
} catch (Exception e) ...{
e.printStackTrace();
return false;
}
return true;
}
/** *//**
* @param args
*/
public static void main(String[] args) ...{
ExcelHandler handler = new ExcelHandler();
handler.createFile("c:/test.xls");
}
}
文章出处:http://www.diybl.com/course/3_program/java/javajs/2008224/100834.html?