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

java ½«EXCEL±í¸ñÊý¾Ýת»»³ÉXML¸ñʽ

ÓÐʱºòÎÒÃÅÐèÒª°ÑEXCEL±í¸ñÖеÄÊý¾Ýת»»³ÉXML¸ñʽ ÕâÐèÒªÓõ½JXL(·ÖÎöEXCEL)°üºÍJDOM°ü(¹¹³ÉXML)
import java.io.*;
import jxl.*;
import org.jdom.Element;
import org.jdom.Document;
import org.jdom.output.XMLOutputter;
/**
 *
 * @author guo
 */
public class EtoX {
   
    /** Creates a new instance of EtoX */
    public EtoX() {
    }
   
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        try{           
           InputStream is= new FileInputStream("C:\\Documents and Settings\\guo\\EXCELtoXML\\src\\exceltoxml\\ningxia.xls");
           Workbook rwb=Workbook.getWorkbook(is);
           //System.out.println(rwb.getNumberOfSheets());     //»ñµÃ¹¤×÷±¡£¨Workbook£©Öй¤×÷±í£¨Sheet£©µÄ¸öÊý
           Sheet rs=rwb.getSheet(0);
           int l=rs.getColumns();             //·µ»Ø±íÖеÄ×ÜÁÐÊý
           int w=rs.getRows();               //·µ»Ø±íÖаüº¬×ÜÐÐÊý
           System.out.println("Îļþ×ܹ²"+w+"ÐÐ");
           Element root=new Element("allmetadata");
           Document doc=new Document(root);
         


Ïà¹ØÎĵµ£º

SAX½âÎöXMLÎĵµ£¨×ª£©


package cn.com.xml.vo;
public class RosterVo {
   
private String id; //ѧºÅ

private String name;   //ѧÉúÐÕÃû
  
   private String age;    //ÄêÁä
  
   private String skill;   //¿ÆÄ¿ ......

JavaÕýÔò±í´ïʽ(×ܽá¶þ)

±¾´ÎÖ÷ÒªÒÔÀý×ÓΪÖ÷£º
 1.Æ¥ÅäͼÏñ /**
* Æ¥ÅäͼÏó <br>
* ¸ñʽ: /Ïà¶Ô·¾¶/ÎļþÃû.ºó׺ (ºó׺Ϊgif,dmp,png)
* Æ¥Åä : /forum/head_icon/admini2005111_ff.gif »ò admini2005111.dmp<br>
* ²»Æ¥Åä: c:/admins4512.gif
*/
public static final String icon_regexp = "^(/{0,1}\ ......

µÚÈýƪ£ºJAVA×Ö·û±àÂëϵÁÐÈý£ºJavaÓ¦ÓÃÖеıàÂëÎÊÌâ

1. ¸ÅÊö
±¾ÎÄÖ÷Òª°üÀ¨ÒÔϼ¸¸ö·½Ã棺±àÂë»ù±¾ÖªÊ¶£¬java£¬ÏµÍ³Èí¼þ£¬url£¬¹¤¾ßÈí¼þµÈ¡£
ÔÚÏÂÃæµÄÃèÊöÖУ¬½«ÒÔ"ÖÐÎÄ"Á½¸ö×ÖΪÀý£¬¾­²é±í¿ÉÒÔÖªµÀÆäGB2312±àÂëÊÇ"d6d0 cec4"£¬Unicode±àÂëΪ"4e2d 6587"£¬UTF±àÂë¾ÍÊÇ"e4b8ad e69687"¡£×¢Ò⣬ÕâÁ½¸ö×ÖûÓÐiso8859-1±àÂ룬µ«¿ÉÒÔÓÃiso8859-1±àÂëÀ´"±íʾ"¡£
2. ±àÂë»ù±¾ÖªÊ ......

Java³ÌÐòµÄÎÊÌâ

ÕâÊÇÒ»¶ÎÎҲο¼µÄJava³ÌÐò×ֶΣ¬ÒѾ­µ÷ÊÔ¿ÉÒÔͨEclipseÔËÐÐÁË£¬´úÂëÓе㿴²»¶®£¬ÄÄλ¸ßÊÖ¿ÉÒÔ°ïÎÒ×ö¸öÖÐÎÄ×¢ÊÍ£¿Ð»Ð»À²~~
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import ja ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ