jackyrong

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

   JAVA操作EXCEL有两种办法,一个用POI,一个用JXI,好象听说JXI对中文的支持会稍微好些.

1 用POI,一个写的例子:
  

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.poifs.filesystem.*;
import java.io.*;

public class Write {

 /**
  * @param args
  */
 public static void main(String[] args) {
  try
  {
  // TODO Auto-generated method stub
HSSFWorkbook wb=new HSSFWorkbook();
   HSSFSheet sheet=wb.createSheet("new sheet");
   HSSFRow row=sheet.createRow((short)1);  
   row.createCell((short)1).setCellValue(1.2);  
   row.createCell((short)2).setCellValue("hellow way"); 
   row.createCell((short)3).setCellValue("aaaaa");    
   FileOutputStream fileout=new FileOutputStream("c:\\aa.xls"); 
      wb.write(fileout);                         
      fileout.close();
     
      System.out.println("aaa");
  }
  catch(Exception e)
  {}
 }

2 读的例子:
   CustomerDAO customerDAO = new CustomerDAO();
   String accounts = (String) request.getSession()
     .getValue("accounts");

   String fileToBeRead = request.getRealPath("/")
     + "customer\\excel\\upload_" + accounts + ".xls";
   try {
    HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(
      fileToBeRead));
    HSSFSheet sheet = workbook.getSheetAt(0);
    /* 读取文件中的信息,并把数据存入数据库 */
    for (int j = 1;; j++) {
     HSSFRow row = sheet.getRow(j);
     if (row != null) {
      CustomerDTO customerDTO = new CustomerDTO();
      HSSFCell cell;
      int i = 0;
      /* 跳过第一列的customerInformationID */
      i++;
      cell = row.getCell((short) i++);
      customerDTO.setCompanyName(cell.getStringCellValue());
      cell = row.getCell((short) i++);
      customerDTO.setCustomerName(cell.getStringCellValue());
      cell = row.getCell((short) i++);
      customerDTO.setNameForShort(cell.getStringCellValue());
      cell = row.getCell((short) i++);
      customerDTO
        .setCompanyAddress(cell.getStringCellValue());
      cell = row.getCell((short) i++);
      customerDTO.setCountry(cell.getStringCellValue());
      cell = row.getCell((short) i++);
      customerDTO.setProvince(cell.getStringCellValue());
      cell = row.getCell((short) i++);
      customerDTO.setCity(cell.getStringCellValue());
      cell = row.getCell((short) i++);
      customerDTO.setPostalcode(cell.getStringCellValue());
      cell = row.getCell((short) i++);
      customerDTO.setCompanyHomePage(cell
        .getStringCellValue());
      
      customerDAO.insertCustomer(customerDTO);
     } else {
      break;
     }
    }
   } catch (Exception e) {
    e.printStackTrace();
   }

  而JXI的话,可以看这两篇文介绍
  http://malipei.javaeye.com/blog/70044

http://www.alchemistrex.com/article.asp?id=138

http://www.blogjava.net/jhengfei/archive/2006/05/22/47480.html

 

 

 

posted on 2008-09-13 12:15  jackyrong的世界  阅读(672)  评论(0编辑  收藏  举报