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);
Ïà¹ØÎĵµ£º
1.ÕýÔò±í´ïʽ½á¹¹¼ò½é£º
С֪ʶ£º{}¡¡¶¨ÒåÁËÒ»¸ö·¶Î§¡¡ [] ¶¨ÒåÁËÒ»¸ö×Ö·ûÀà¡¡() ¶¨ÒåÁËÒ»¸ö×é
*Ç°Ãæ³öÏÖ0´ÎÒÔÉÏ +¡¡Ç°ÃæÆ¥ÅäÒ»´ÎÒÔÉÏ¡¡?Ç°Ãæ³öÏÖ0´Î»òÒ»´Î
1).×Ö·û£º
x------×Ö·ûx
\\-----·´Ð±¸Ü
\0n----Ê®½øÖÆÊý (0 <= n <= 7)
\0nn---Ê®½øÖÆÊý0nn (0 <= n <= 7)
\0mnn--Ê®½øÖÆÊý ......
Ê×ÏÈboolean²»ÄܸúÆäËûÀàÐÍת»»¡£
1.¸³ÖµÊ±£º
ÕûÊýĬÈϵÄÊÇint ¸¡µãĬÈÏÊÇdouble£¬¼´ÕûÐ͵ȺÅÓÒ²àÈ«²¿×Ô¶¯×ª»¯Îªint£¬¸¡µãÐ͵ȺÅÓÒ²à×Ô¶¯×ª»»Îªdouble¡£µ±´óÈÝÁ¿µÄÊý¾ÝÀàÐ͸³Öµ¸øÐ¡ÈÝÁ¿µÄÊý¾ÝÀàÐÍʱ ÐèÒªÇ¿ÖÆÀàÐÍת»»µ«ÊÇÓÐ ......
1. ¸ÅÊö
±¾ÎÄÖ÷Òª°üÀ¨ÒÔϼ¸¸ö·½Ã棺±àÂë»ù±¾ÖªÊ¶£¬java£¬ÏµÍ³Èí¼þ£¬url£¬¹¤¾ßÈí¼þµÈ¡£
ÔÚÏÂÃæµÄÃèÊöÖУ¬½«ÒÔ"ÖÐÎÄ"Á½¸ö×ÖΪÀý£¬¾²é±í¿ÉÒÔÖªµÀÆäGB2312±àÂëÊÇ"d6d0 cec4"£¬Unicode±àÂëΪ"4e2d 6587"£¬UTF±àÂë¾ÍÊÇ"e4b8ad e69687"¡£×¢Ò⣬ÕâÁ½¸ö×ÖûÓÐiso8859-1±àÂ룬µ«¿ÉÒÔÓÃiso8859-1±àÂëÀ´"±íʾ"¡£
2. ±àÂë»ù±¾ÖªÊ ......
ÕâÊÇÒ»¶ÎÎҲο¼µÄ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 ......
Spring Framework ¡¾Java¿ªÔ´ J2EE¿ò¼Ü¡¿
SpringÊÇÒ»¸ö½â¾öÁËÐí¶àÔÚJ2EE¿ª·¢Öг£¼ûµÄÎÊÌâµÄÇ¿´ó¿ò¼Ü¡£ SpringÌṩÁ˹ÜÀíÒµÎñ¶ÔÏóµÄÒ»Ö·½·¨²¢ÇÒ¹ÄÀøÁË×¢Èë¶Ô½Ó¿Ú±à³Ì¶ø²»ÊǶÔÀà±à³ÌµÄÁ¼ºÃϰ¹ß¡£SpringµÄ¼Ü¹¹»ù´¡ÊÇ»ùÓÚʹÓÃJavaBeanÊôÐÔµÄInversion of ControlÈÝÆ÷¡£È»¶ø£¬Õâ½ö½öÊÇÍêÕûͼ¾°ÖеÄÒ»²¿·Ö£ºSpringÔÚʹÓÃIoCÈÝÆ÷ ......