java读写excel2003

来源：互联网发布：java组件化开发编辑：程序博客网时间：2024/06/03 19:04

org.apache.poi对更高excel2003文档的操作

1.导入jar包

dom4j-20040902.021138.jar

ooxml-schemas-1.1.jar

poi-3.9.jar

poi-ooxml-3.9.jar

xmlbeans-2.5.0.jar

2.范例代码

package xls;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import org.apache.poi.hssf.usermodel.HSSFCell;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.poifs.filesystem.POIFSFileSystem;import org.apache.poi.ss.util.WorkbookUtil;/** * @description 读写excel2003文档 * @author YHZ * @url http://blog.csdn.net/howareyoutodaysoft  * @qq 2481151614 * @date 2013-1-14 * */public class Xls2003Util {/** * @param args */public static void main(String[] args) {Xls2003Util test = new Xls2003Util();test.writeXls("C:\\Documents and Settings\\不了了之\\桌面\\写入2003.xls");test.readXls("C:\\Documents and Settings\\不了了之\\桌面\\挂车未检.xls");}/** * 写入2003版本的xls *  * @param path */private void writeXls(String path) {HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet1 = wb.createSheet("new sheet");HSSFRow row = sheet1.createRow(2);row.createCell(0).setCellValue(1.1);row.createCell(1).setCellValue(new java.util.Date());row.createCell(2).setCellValue("a string内容信息");row.createCell(3).setCellValue(true);row.createCell(4).setCellType(HSSFCell.CELL_TYPE_ERROR);HSSFSheet sheet2 = wb.createSheet(); // create with default namesHSSFRow row2 = sheet2.createRow(2);row2.createCell(0).setCellValue(1.1);row2.createCell(1).setCellValue(new java.util.Date());final String name = "second sheet";wb.setSheetName(1, WorkbookUtil.createSafeSheetName(name)); // settingFileOutputStream fileOut;try {fileOut = new FileOutputStream(path);wb.write(fileOut);fileOut.close();} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}}/** * 读取2003版本的xls文件 *  * @param path */private void readXls(String path) {FileInputStream fileIn = null;try {fileIn = new FileInputStream(path);POIFSFileSystem fs = new POIFSFileSystem(fileIn);HSSFWorkbook wb = new HSSFWorkbook(fs);HSSFSheet sheet = wb.getSheetAt(0);System.out.println("开始行数："+sheet.getFirstRowNum()+"，结束行数：" + sheet.getLastRowNum());for(int i=sheet.getFirstRowNum(); i<=sheet.getLastRowNum(); i++){HSSFRow row = sheet.getRow(i);System.out.println("第"+i+"行：");for(int k=row.getFirstCellNum();k<row.getLastCellNum();k++){System.out.print("cell内容：["+row.getCell(k).getRichStringCellValue()+"]");}System.out.println("");row = null;}HSSFRow row = sheet.getRow(2);if (row == null)row = sheet.createRow(2);HSSFCell cell = row.getCell(3);if (cell == null)cell = row.createCell(3);cell.setCellType(HSSFCell.CELL_TYPE_STRING);cell.setCellValue("a test");fileIn.close();} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}}}

访问地址：http://www.massapi.com/class/hs/HSSFWorkbook.html