java ʵÏÖxlsÎļþתxml
package com.dongyang;
/*
* ¶Áxlsдxml
*/
import java.io.FileOutputStream;
import java.io.FileInputStream;
import java.io.InputStream;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.XMLOutputter;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class Excel2xml
{
public static void main(String[] args)
{
Excel2xml e = new Excel2xml();
e.ret();
}
public void ret(){
jxl.Workbook readwb = null;
try
{
//¹¹½¨Workbook¶ÔÏó, Ö»¶ÁWorkbook¶ÔÏó
//Ö±½Ó´Ó±¾µØÎļþ´´½¨Workbook
InputStream instream = new FileInputStream("E:/123.xls");
readwb = Workbook.getWorkbook(instream);
//SheetµÄϱêÊÇ´Ó0¿ªÊ¼
//»ñÈ¡µÚÒ»ÕÅSheet±í
Sheet readsheet = readwb.getSheet(0);
//»ñÈ¡Sheet±íÖÐËù°üº¬µÄ×ÜÁÐÊý
int rsColumns = readsheet.getColumns();
//»ñÈ
Ïà¹ØÎĵµ£º
OpenJWeb(1.8) Java WebÓ¦ÓÿìËÙ¿ª·¢Æ½Ì¨µÄ×÷ÕßÊÇÎÒÃǼ¼ÊõÁªÃ˵ijÉÔ±£¬Ëû×î½üÍÆ³öÁËа汾µÄ¿ìËÙÓ¦Óÿª·¢Æ½Ì¨ OpenJWeb(1.8)£¬ÎÒ°ïËû×ö×öÐû´«
OpenJWeb¿ìËÙ¿ª·¢Æ½Ì¨ÒÔ¿ìËÙ¿ª·¢ÎªºËÐÄ£¬ÕûºÏÏȽøµÄjava
¿ªÔ´¿ò¼Ü£¬±¾×Å×ÔÖ÷¿ª·¢+Ó¦Óü¯³ÉÏà½áºÏµÄÔÔò£¬Ö¼ÔÚΪÕþ¸®¡¢ÆóÊÂÒµµ¥Î»¡¢Èí¼þ¹«Ë¾µÈƽ̨Óû§Ìṩһ ......
±ØÐëÓÃthis¹Ø¼ü×ÖµÄÈýÖÖÇé¿ö:
1.ÎÒÃÇÏëͨ¹ý¹¹Ôì·½·¨½«Íⲿ´«ÈëµÄ²ÎÊý¸³Öµ¸ø³ÉÔ±±äÁ¿,¶ø¹¹Ôì·½·¨µÄÐÎʽ²ÎÊýÓëÀà³ÉÔ±µÄ±äÁ¿ÃûÏàͬ,Õâʱ¾ÍÐèÒªthisÕâ¸ö¹Ø¼ü×ÖÀ´Çø±ð¾Ö²¿±äÁ¿ÓëÀà±äÁ¿;
2.¼ÙÉèÓÐÒ»¸öÈÝÆ÷ÀàºÍÒ»¸ö²¿¼þÀà,ÔÚÈÝÆ÷ÀàµÄij¸ö·½·¨ÖÐÒª´´½¨²¿¼þÀàµÄʵÀý¶ÔÏó,¶ø²¿¼þÀàµÄ¹¹Ôì·½·¨Òª½ÓÊÕÒ»¸ö´ú±íÆäËùÔÚÈÝÆ÷µÄ²ÎÊý,ÕâÊ±Ò²Ò ......
1.java¹ýÂËÆ÷¶ÔextÒì²½ÇëÇóÌø×ª
Óû§·ÃÎʳ¬Ê±
½â¾öÁ½ÖÖÇé¿öϵÄÓû§·ÃÎʳ¬Ê±¡£
a£©ÆÕͨhttpÇëÇóµÄsession³¬Ê±¡£
b£©Òì²½httpÇëÇóµÄsession³¬Ê±£¬Ê¹ÓÃextºó´ó²¿·ÖµÄ½çÃæË¢Ð¶¼ÊÇÒì²½µÄajaxÇëÇó¡£
²»¹ÜÊÇÄÇÖÖÀàÐ͵ÄhttpÇëÇó×ÜÊÇ¿ÉÒÔÓÉÒ»¸ö¹ýÂËÆ÷À´²¶×½¡£
·ÖÀࣺÆÕͨhttpÇëÇóµÄheader²ÎÊýÖÐûÓÐx-requested-with: ......
1.FileÀàΪ¹ÜÀíÎļþºÍĿ¼ÌṩÁË·½·¨£¬Æä¶ÔÏó±íʾһ¸öÎļþ»òÕßĿ¼¡£ËüÌṩÁËÈô¸É·½·¨¶ÔÎļþ»òÎļþ¼Ð½øÐвÙ×÷¡£ÆäÖеÄlist()·½·¨ºÍlistFiles()·½·¨¿ÉÒÔÆðµ½¶¨Î»Ìض¨ÎļþµÄ×÷Óá£
2.ObjectÀ࣬ÊÇËùÓÐJavaÀàµÄ׿ÏÈ£¬ÈôÒ»¸öÀàÉùÃ÷ʱûÓаüº¬extends¹Ø¼ü×Ö£¬ÔòÆäÖ±½Ó¼Ì³ÐÓÚObjetcÀà¡£ÆäÖÐÓÐÐí¶àÖØÒª·½·¨£º
equals(),notify(), ......