java²Ù×÷Excel
½«ÏÂÔØºóµÄÎļþ½â°ü£¬µÃµ½jxl.jar£¬·ÅÈëclasspath£¬°²×°¾ÍÍê³ÉÁË¡£
»ù±¾²Ù×÷
Ò»¡¢´´½¨Îļþ
ÄâÉú³ÉÒ»¸öÃûΪ“²âÊÔÊý¾Ý.xls”µÄExcelÎļþ£¬ÆäÖеÚÒ»¸ö¹¤×÷±í±»ÃüÃûΪ“µÚÒ»Ò³”£¬´óÖÂЧ¹ûÈçÏ£º
´úÂ루CreateXLS.java£©£º
//Éú³ÉExcelµÄÀà
import java.io.*;
import jxl.*;
import jxl.write.*;
public class CreateXLS
{
public static void main(String args[])
{
try
{
//´ò¿ªÎļþ
WritableWorkbook book=
Workbook.createWorkbook(new File(“²âÊÔ.xls”));
//Éú³ÉÃûΪ“µÚÒ»Ò³”µÄ¹¤×÷±í£¬²ÎÊý0±íʾÕâÊǵÚÒ»Ò³
WritableSheet sheet=book.createSheet(“µÚÒ»Ò³”,0);
//ÔÚLabel¶ÔÏóµÄ¹¹Ôì×ÓÖÐÖ¸Ãûµ¥Ôª¸ñλÖÃÊǵÚÒ»ÁеÚÒ»ÐÐ(0,0)
//ÒÔ¼°µ¥Ôª¸ñÄÚÈÝΪtest
Label label=new Label(0,0,”test”);
//½«¶¨ÒåºÃµÄµ¥Ôª¸ñÌí¼Óµ½¹¤×÷±íÖÐ
sheet.addCell(label);
/*Éú³ÉÒ»¸ö±£´æÊý×ֵĵ¥Ôª¸ñ
±ØÐëʹÓÃNumberµÄÍêÕû°ü·¾¶£¬·ñÔòÓÐÓï·¨ÆçÒå
jxl.write.Number number = new jxl.write.Number(1,0,789.123);
sheet.addCell(number);
//дÈëÊý¾Ý²¢¹Ø±ÕÎļþ
book.write();
book.close();
}catch(Exception e)
{
System.out.println(e);
}
}
}
¶þ¡¢¶ÁÈ¡Îļþ
ÒÔ¸Õ²ÅÎÒÃÇ´´½¨µÄExcelÎļþΪÀý£¬×öÒ»¸ö¼òµ¥µÄ¶ÁÈ¡²Ù×÷£¬³ÌÐò´úÂëÈçÏ£º
³ÌÐò´úÂë
//¶ÁÈ¡ExcelµÄÀà
import java.io.*;
import jxl.*;
public class ReadXLS
{
public static void main(String args[])
{
try
{
Workbook book=
Workbook.getWorkbook(new File(“²âÊÔ.xls”));
//»ñµÃµÚÒ»¸ö¹¤×÷±í¶ÔÏó
Sheet sheet=book.getSheet(0);
//µÃµ½µÚÒ»ÁеÚÒ»Ðеĵ¥Ôª¸ñ
Cell cell1=sheet.getCell(0,0);
String result=cell1.getContents();
System.out.println(result);
book.close();
}catch(Exception e)
{
System.out.println(e);
}
}
}
³ÌÐòÖ´Ðнá¹û£ºtest
Èý¡¢ÐÞ¸ÄÎļþ
ÀûÓÃjExcelAPI¿ÉÒÔÐÞ¸ÄÒÑÓеÄExcelÎļþ£¬ÐÞ¸ÄExcelÎļþµÄʱºò£¬³ýÁË´ò¿ªÎļþµÄ·½Ê½²»Í¬Ö®Í⣬ÆäËû²Ù×÷ºÍ´´½¨ExcelÊÇÒ»ÑùµÄ¡£ÏÂÃæµÄÀý×ÓÊÇÔÚÎÒÃÇÒѾÉú
Ïà¹ØÎĵµ£º
Jsp
·½Ãæ
jspµÄ³£ÓõÄÃüÁî´ð£ºpage, include, talib, forward,
Servlet
·½Ãæ
1
¡¢ËµÒ»Ëµ
Servlet
µÄÉúÃüÖÜÆÚ
?
´ð:servletÓÐÁ¼ºÃ
µÄÉú´æÆÚµÄ¶¨Ò壬°üÀ¨¼ÓÔØºÍʵÀý»¯¡¢³õʼ»¯¡¢´¦ÀíÇëÇóÒÔ¼°·þÎñ½áÊø¡£Õâ¸öÉú´æÆÚÓÉjavax.servlet.Servlet½Ó¿ÚµÄ
init,serviceºÍdestroy·½·¨±í´ï¡£
2
¡¢
Servlet
°æ±¾¼ä
(
ÍüÁ ......
package com.qiao.java;
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.util.HashMap;
import java.util.Iter ......
POIFSFileSystem fs=new POIFSFileSystem(new FileInputStream(cfname));
HSSFWorkbook wb = new HSSFWorkbook(fs);
......
1.»ù±¾¸ÅÄîµÄÀí½â
¾ø¶Ô·¾¶£º¾ø¶Ô·¾¶¾ÍÊÇÄãµÄÖ÷Ò³ÉϵÄÎļþ»òĿ¼ÔÚÓ²ÅÌÉÏÕæÕýµÄ·¾¶£¬(URLºÍÎïÀí·¾¶)ÀýÈ磺 C:\xyz\test.txt ´ú±íÁËtest.txtÎļþµÄ¾ø¶Ô·¾¶¡£http://www.sun.com/index.htmÒ²´ú±íÁËÒ»¸ö URL¾ø¶Ô·¾¶¡£
Ïà¶Ô·¾¶£ºÏà¶ÔÓëij¸ö»ù׼Ŀ¼µÄ·¾¶¡£°üº¬WebµÄÏà¶Ô·¾¶(HTMLÖеÄÏà¶ÔĿ¼)£¬ÀýÈ磺ÔÚ ServletÖУ ......
Ò»¡¢¸øUbuntuÅäÖÃJAVA»·¾³
¡¡
¡¡¡¡²Ù×÷ϵͳ°æ±¾£ºUbuntu 7.10 Gutsy
¡¡
¡¡¡¡JAVA°æ±¾£ºJAVA 6
¡¡
¡¡¡¡ÔÚUbuntuϰ²×°JAVAÐéÄâ»úºÍSDK£¨¿ª·¢°ü£©ÊǷdz£ÇáËÉÈÝÒ׵ģº
¡¡
¡¡¡¡ÁªÍøµÄÇé¿öÏÂÔÚÖÕ¶ËÏÂÊäÈëÃüÁî
¡¡
¡¡¡¡$sudo apt-get& ......