EXCEL用java代码生成-优快云博客

public class TestExc {
public static void main(String[] args){
  HSSFWorkbook hssfwork =new HSSFWorkbook();
  HSSFSheet sheet =hssfwork.createSheet("sheet1");
  HSSFRow row=sheet.createRow(1);
  HSSFCell cell =row.createCell((short)0);
  cell.setCellValue("123");
  HSSFCell cel =row.createCell((short)1);
  cel.setCellValue("123");
  HSSFCell ce =row.createCell((short)2);
  ce.setCellValue("123");
  HSSFCell c =row.createCell((short)3);
  c.setCellValue("123");

  try {
   hssfwork.write(new FileOutputStream("c:\\love.xls"));
  } catch (FileNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }



}

}

=============================================================

下面是批量修改时能用到的方法

<body>
<h1><center>人员添加后信息列表</center></h1><br><hr>
<%
     request.setCharacterEncoding("utf-8");
%>
<%
        String driver="oracle.jdbc.driver.OracleDriver";
        String url="jdbc:oracle:thin:@localhost:1521:orcl";
        String uname="scott";
        String password="tiger";
        Connection conn=null;

        Statement stmt=null;

%>

<%
   try {
        Class.forName(driver);
        conn= DriverManager.getConnection(url,uname,password);
        stmt=conn.createStatement();
        conn.setAutoCommit(false);
        stmt.addBatch("insert into reyuan (name,age,tel) values ('love',3,5)");
        stmt.addBatch("insert into reyuan (name,age,tel) values ('love',3,5)");
        stmt.addBatch("insert into reyuan (name,age,tel) values ('love',3,5)");
        stmt.addBatch("insert into reyuan (name,age,tel) values ('love',3,5)");
        stmt.addBatch("insert into reyuan (name,age,tel) values ('love',3,5)");
        stmt.addBatch("insert into reyuan (name,age,tel) values ('love',3,5)");
        stmt.addBatch("insert into reyuan (name,age,tel) values ('love',3,5)");
        stmt.addBatch("insert into reyuan (name,age,tel) values ('love',3,5)");

        stmt.executeBatch();
        conn.commit();

%>

<%

     }catch(Exception e){
     try{
      conn.rollback();
      stmt.close();
      conn.close();
     }catch(Exception ee){

     }

       e.printStackTrace();
     }
   %>

</body>
</html>