Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

java²Ù×÷Excel

// ´´½¨Excel
    String destFileName = tableName + ".xls";//ÎļþÃû
    response.setContentType("application/vnd.ms-excel");
    response.setHeader("Content-Disposition", "attachment; filename=".concat(String .valueOf(destFileName)));
    
WorkbookSettings wbs = new WorkbookSettings();
    WritableWorkbook w = Workbook.createWorkbook(response .getOutputStream(), wbs);//´ò¿ªÎļþ
    jxl.write.WritableSheet ws = w.createSheet("sheet0", 0);// // Éú³ÉÃûΪ“sheet0”µÄ¹¤×÷±í£¬²ÎÊý0±íʾÕâÊǵÚÒ»Ò³   
   // ÔÚLabel¶ÔÏóµÄ¹¹Ôì×ÓÖÐÖ¸Ãûµ¥Ôª¸ñλÖÃÊǵÚÒ»ÁеÚÒ»ÐÐ(0,0)
   // ÒÔ¼°µ¥Ôª¸ñÄÚÈÝΪtest
   Label label = new Label(0, 0, "test123");
  
   // ½«¶¨ÒåºÃµÄµ¥Ôª¸ñÌí¼Óµ½¹¤×÷±íÖÐ
   sheet.addCell(label);
    // ×ÖÌåÉèÖÃ
    WritableFont font = new WritableFont(WritableFont.createFont("¿¬Ìå_GB2312"), 12, WritableFont.BOLD);
    WritableCellFormat format = new WritableCellFormat(font);
    format.setBackground(jxl.format.Colour.GRAY_25);
    format.setLocked(false);//µ¥Ôª¸ñËø¶¨
    format.setBorder(jxl.format.Border.ALL,
      jxl.format.BorderLineStyle.getStyle(1));
    format.setWrap(true);//ÉèÖÃ×Ô¶¯»»ÐÐ
    // ×ÖÌåÉèÖýáÊø
  // µ¥Ôª¸ñÉèÖÃÄÚÈÝ£¨ÒÔϱíʾ£¬µÚiÁУ¬µÚ1ÐУ©
·½Ê½1£º 
   ExcelUtil.makeCellData(ws, i, 0, (String) map.get("BTF_TITLE"), ExcelUtil.LABEL_ALIGN_LEFT,ExcelUtil.BORDER_LINE_ALL, null, ExcelUtil.CELL_TYPE_LABEL,jxl.format.Colour.GRAY_25);
·½Ê½2£º
     ws.addCell(new Label(i, 0, (String) map.get("BTF_TITLE"), format));
//×îºóдÎļþ£¬¹Ø±Õ
  w.write();
  w.close();
//º


Ïà¹ØÎĵµ£º

Java Àà×°ÈëÆ÷Ô­Àí

 
×ªÔØ×Ôhttp://blog.csdn.net/yuekun1172006/archive/2007/06/02/1634878.aspx
Àà×°ÈëÆ÷ÊÇ JVM ÓÃÀ´×°ÈëÀàµÄÀ࣬Ëü¶ÔÓÚ Java ±à³ÌÊǷdz£ÖØÒªµÄÒ»¸ö¸ÅÄî¡£Ò»°ãÇé¿öÏ£¬³ÌÐòÔ±ÔÚ±àд³ÌÐòµÄʱºò¶¼¿ÉÒÔºöÂÔÀà×°ÈëÆ÷µÄ´æÔÚÐÔ¡£µ«ÊǶÔÓÚ·þÎñÆ÷¶Ë±à³Ì»òÕßÊÇÒ»Ð©ÌØÊâÇé¿öÏÂʱºò£¬ÉîÈëÁ˽âÀà×°ÈëÆ÷µÄ»úÖÆÒÔ¼°ÆäÔÚ²»Í¬Çé¿öϵ ......

java¶ÔXMLÎļþµÄ½âÎö¡¢½ÚµãµÄÔö¼Ó¡¢É¾³ý²Ù×÷×ܽá

ÏÈÌù´úÂë°É
¸Ðл£ºhttp://xranming.blog.163.com/blog/static/24204952009914104148872/
 http://www.diybl.com/course/3_program/java/javajs/20090303/157541.html
1¡¢java´úÂ룺
Ö÷Òª²ÉÓÃdomÀ´½øÐвÙ×÷
java¶Ôxml²Ù×÷ÓÐËÄÖÖ·½·¨£ºhttp://passmatlab.bokee.com/3455905.html
 package test;
import java ......

java½øÖÆ×ª»»

¶ÔÓÚ10½øÖÆÊýת»»ÎªN£¨2-36£©½øÖÆÒ»°ã¶¼ÊÇÑ¡ÔñÈ¡Óà³ýµÄËã·¨½øÐÐת»» £¬ÏÂÃæ¸ø³öÁ½ÖÖ·½°¸
Ò»ÖÖÊǵݹ飬һÖÖÊǵü´ú¡£Í¨¹ýЧÂÊÆÀ¼ÛÁ½ÕßÐÔÄÜ
ÆäÖеü´úµÄ·½°¸Ö±½ÓÈ¡×ÔjavaÔ´´úÂë¡£
/*
*Class NotationConvert.java
*Create Date: 2009-11-12
*Author:a276202460
*/
package com.rich.notation;
public class Notat ......

ÕûÀíÓÃJavaʵÏÖÊý×Öת»¯³É×Ö·û´®×ó±ß×Ô¶¯²¹Áã·½·¨

Java ÖиøÊý×Ö×ó±ß²¹0 £¨1£©·½·¨Ò»
import java.text.NumberFormat; public class NumberFormatTest {     public static void main(String[] args) {
        //´ý²âÊÔÊý¾Ý
        int i = 1;
  ......

A example to run the Java APP in bat

@echo off cls REM --- BEG MACHINE-DEPENDENT ---- set HOME_J2RE=C:\Program Files\Java\jdk1.5.0_17 REM --- END MACHINE-DEPENDENT ---- set HOME_JAVA=%HOME_J2RE%\bin\java set HOME_JAVA="%HOME_JAVA%" set ARG_MEMORY=-Xms128m -Xmx196m set PROP_POLICY=-Dorg.ragingcat.kst.uikeytool.policy.extende ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ