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);
Ïà¹ØÎĵµ£º
¹ØÓÚJavaÄÚ´æ·ÖÅ䣬ºÜ¶àÎÊÌⶼģģºýºý£¬²»ÄÜÈ«Ãæ¹áͨÀí½â¡£½ñ²éÔÄ×ÊÁÏ£¬ÓûÇóÉîÈëÍÚ¾ò£¬³¹µ×ÀíÇåjavaÄÚ´æ·ÖÅäÂöÂ磬ֻÒòˮƽÓÐÏÞ£¬Ã»´ïµ½Ô¤ÆÚЧ¹û£¬½öÒÔ´ËÎĶÔËùÑо¿µ½Ö®´¦×÷ÒԼǼ£¬ÎªÒÔºóѧϰÌṩ²Î¿¼£¬±ÜÃâÖØÍ·ÔÙÀ´¡£
Ò»¡¢JavaÄÚ´æ·ÖÅä
1¡¢ JavaÓм¸ÖÖ´æ´¢ÇøÓò£¿
* ¼Ä´æÆ÷
-- ÔÚCP ......
if(null != agent && -1 != agent.indexOf("MSIE")){
filename = URLEncoder.encode(filename
,"UTF8");
}else if ......
JAVA²Ù×÷XMLµÄÍêÕûÀý×Ó——W3C DOM
JAVA²Ù×÷XMLµÄÍêÕûÀý×Ó——W3C DOMƪÊÕ²Ø
ÕâÊÇÒ»¸öÓÃJAVA W3C DOM ½øÐÐXML²Ù×÷µÄÀý×Ó£¬°üº¬Á˲éѯ¡¢Ôö¼Ó¡¢Ð޸ġ¢É¾³ý¡¢±£´æµÄ»ù±¾²Ù×÷¡£½ÏÍêÕûµÄÃèÊöÁËÒ»¸öXMLµÄÕû¸ö²Ù×÷Á÷³Ì¡£ÊʺϸÕÈëÃÅJAVA XML²Ù×÷µÄÅóÓѲο¼ºÍѧϰ¡£
¼ÙÉèÓÐXMLÎļþ£ºtest1.xml
<?xml v ......
Ç×°®µÄ Java ÐÂÊÖÃÇ£º
ºÜ¸ßÐËÄãÃÇÔ¸ÒâÀ´ÕâÀﹲͬѧϰ£¬
Java Õâ¸öÓïÑÔ£¬ÒѾ²»ÔÙÊÇÓïÑÔÁË£¬Ëû¹´ÀÕ³öÒ»¸ö¿ª·ÅʽµÄ¿ª·¢»·¾³£¬
»ù±¾ÉÏ java.sum.com ºÜ´ÖÂÔµØ°Ñ Java ·ÖΪÈý¸ö²¿·Ö£º
(1) J2SE ( Java 2 Standard Edition )
(2) J2EE ( Java 2 Enterprise Edition )
(3) J2ME ( Java 2 Micro Edition ) ......
JavaÖеıäÁ¿Óë¶ÔÏóÓÐÇø±ðÂð£¿
Òý×Ó£º±äÁ¿Óë¶ÔÏó
±äÁ¿ÊÇJavaÖÐ×î»ù±¾µÄ´æ´¢µ¥Ôª£¬Îª±äÁ¿¸³Öµ¿ÉÒÔʹÓø³Öµ±í´ïʽ¡£È磺
int i = 10;
¸Ã±í´ïʽµÄº¬ÒåÊǽ«Ò»¸ö×ÖÃæÁ¿£¨literal£©10¸³Öµ¸øÒ»¸öÀàÐÍΪintÐ͵ıäÁ¿£¬±äÁ¿ÃûΪi¡£ÕâÊÇÒ»¸öΪ»ù±¾Êý¾ÝÀàÐ͵ıäÁ¿¸³ÖµµÄÀý×Ó£¬Ëü±í´ïÁËÒ»¸ö·Ç³£ÆÓËØµÄÐÅÏ¢£¬ÄǾÍÊDZäÁ¿iµÄֵΪ10¡£
Ä ......