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);
Ïà¹ØÎĵµ£º
package cn.com.xml.vo;
public class RosterVo {
private String id; //ѧºÅ
private String name; //ѧÉúÐÕÃû
private String age; //ÄêÁä
private String skill; //¿ÆÄ¿ ......
Ô¤±¸ÖªÊ¶—³ÌÐòµÄÄÚ´æ·ÖÅä
Ò»¸öÓÉC/C++±àÒëµÄ³ÌÐòÕ¼ÓõÄÄÚ´æ·ÖΪÒÔϼ¸¸ö²¿·Ö
1¡¢Õ»Çø£¨stack£©— ÓɱàÒëÆ÷×Ô¶¯·ÖÅäÊÍ·Å £¬´æ·Åº¯ÊýµÄ²ÎÊýÖµ£¬¾Ö²¿±äÁ¿µÄÖµµÈ¡£Æä²Ù×÷·½Ê½ÀàËÆÓÚÊý¾Ý½á¹¹ÖеÄÕ»¡£
2¡¢¶ÑÇø£¨heap£© — Ò»°ãÓɳÌÐòÔ±·ÖÅäÊÍ·Å£¬ Èô³ÌÐòÔ±²»ÊÍ·Å£¬³ÌÐò½áÊøÊ±¿ÉÄÜÓÉOS»ØÊÕ ......
¹À¼ÆÑ§Ï°javaµÄÂòÁËBruce Eckle¡¶Thinking In Java 4th Edition¡·µÄÐÂÊÖÃÇ£¨ÎÒÒ²ÊÇ£©£¬¹À¼Æ¶à»áÓöµ½Ò»¸öÎÊÌ⣺
±àÒëʱimport static net.mindview.util.Print.*;ÕÒ²»µ½ÏàÓ¦µÄ°ü£¬print·½·¨¾ÍÓò»ÁË¡£ÏÂÃæ°ÑÎҵIJÙ×÷·½·¨Ìù³öÀ´£¬Ï£ÍûÄܰﵽÄã¡£
1¡¢°ÑÊé±¾µÄÔ´´úÂë ......
1. ¸ÅÊö
±¾ÎÄÖ÷Òª°üÀ¨ÒÔϼ¸¸ö·½Ã棺±àÂë»ù±¾ÖªÊ¶£¬java£¬ÏµÍ³Èí¼þ£¬url£¬¹¤¾ßÈí¼þµÈ¡£
ÔÚÏÂÃæµÄÃèÊöÖУ¬½«ÒÔ"ÖÐÎÄ"Á½¸ö×ÖΪÀý£¬¾²é±í¿ÉÒÔÖªµÀÆäGB2312±àÂëÊÇ"d6d0 cec4"£¬Unicode±àÂëΪ"4e2d 6587"£¬UTF±àÂë¾ÍÊÇ"e4b8ad e69687"¡£×¢Ò⣬ÕâÁ½¸ö×ÖûÓÐiso8859-1±àÂ룬µ«¿ÉÒÔÓÃiso8859-1±àÂëÀ´"±íʾ"¡£
2. ±àÂë»ù±¾ÖªÊ ......
JavaÖеıäÁ¿Óë¶ÔÏóÓÐÇø±ðÂð£¿
Òý×Ó£º±äÁ¿Óë¶ÔÏó
±äÁ¿ÊÇJavaÖÐ×î»ù±¾µÄ´æ´¢µ¥Ôª£¬Îª±äÁ¿¸³Öµ¿ÉÒÔʹÓø³Öµ±í´ïʽ¡£È磺
int i = 10;
¸Ã±í´ïʽµÄº¬ÒåÊǽ«Ò»¸ö×ÖÃæÁ¿£¨literal£©10¸³Öµ¸øÒ»¸öÀàÐÍΪintÐ͵ıäÁ¿£¬±äÁ¿ÃûΪi¡£ÕâÊÇÒ»¸öΪ»ù±¾Êý¾ÝÀàÐ͵ıäÁ¿¸³ÖµµÄÀý×Ó£¬Ëü±í´ïÁËÒ»¸ö·Ç³£ÆÓËØµÄÐÅÏ¢£¬ÄǾÍÊDZäÁ¿iµÄֵΪ10¡£
Ä ......