Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÊÇÒ»ÑùµÄ¡£ÏÂÃæµÄÀý×ÓÊÇÔÚÎÒÃÇÒѾ­Éú


Ïà¹ØÎĵµ£º

java ÃæÊÔÌâ 2

Jsp
·½Ãæ
jspµÄ³£ÓõÄÃüÁî´ð£ºpage, include, talib, forward,
Servlet
·½Ãæ
1
¡¢ËµÒ»Ëµ
Servlet
µÄÉúÃüÖÜÆÚ
?
´ð:servletÓÐÁ¼ºÃ
µÄÉú´æÆڵĶ¨Ò壬°üÀ¨¼ÓÔغÍʵÀý»¯¡¢³õʼ»¯¡¢´¦ÀíÇëÇóÒÔ¼°·þÎñ½áÊø¡£Õâ¸öÉú´æÆÚÓÉjavax.servlet.Servlet½Ó¿ÚµÄ
init,serviceºÍdestroy·½·¨±í´ï¡£
2
¡¢
Servlet
°æ±¾¼ä
(
ÍüÁ ......

excel java ʵÀý

POIFSFileSystem fs=new POIFSFileSystem(new   FileInputStream(cfname));  
                 HSSFWorkbook   wb   =   new   HSSFWorkbook(fs);  
  ......

javaʵÏÖÑéÖ¤Âë

javaÑéÖ¤ÂëµÄʵÏÖ(Ò»)
ÊÕ²Ø



1.ImageServletÀàµÄʵÏÖ£º
package com.mobile.control;
import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.image.BufferedImage;
import java.io.IOExcep ......

Javaµ÷ÓÃWMICÃüÁîµÄ·½·¨

    ½ñÌìҪд¸öÔ¶³ÌÖØÆô·þÎñµÄ¹¦ÄÜ£¬ÎªÁË¿ª·¢Ëٶȣ¬ÔÝʱ¶¨ÎªJava´úÂë+WMICÃüÁîµÄ·½·¨£¬¼òµ¥µÄ˵£¬¾ÍÊÇÀûÓÃJavaµ÷Óñ¾»úÓ¦ÓóÌÐòµÄ·½·¨¡£Éæ¼°µ½µÄJavaÀàÓÐjava.lang°üÀïÃæµÄRuntime¡¢Process¡¢ProcessBuilderÈý¸öÀ࣬ÒÔ¼°wmicÖÐÖØÆô·þÎñµÄÃüÁî¡£ÒòΪ֮ǰҲд¹ýÕâ·½ÃæµÄ¶«Î÷£¬ËùÒÔºÜÏ°¹ßÐÔµÄд³öÁË´úÂ룺
&nb ......

JavaÖÐÏà¶Ô·¾¶£¬¾ø¶Ô·¾¶ÎÊÌâ×ܽá


1.»ù±¾¸ÅÄîµÄÀí½â
¾ø¶Ô·¾¶£º¾ø¶Ô·¾¶¾ÍÊÇÄãµÄÖ÷Ò³ÉϵÄÎļþ»òĿ¼ÔÚÓ²ÅÌÉÏÕæÕýµÄ·¾¶£¬(URLºÍÎïÀí·¾¶)ÀýÈ磺 C:\xyz\test.txt ´ú±íÁËtest.txtÎļþµÄ¾ø¶Ô·¾¶¡£http://www.sun.com/index.htmÒ²´ú±íÁËÒ»¸ö URL¾ø¶Ô·¾¶¡£
Ïà¶Ô·¾¶£ºÏà¶ÔÓëij¸ö»ù׼Ŀ¼µÄ·¾¶¡£°üº¬WebµÄÏà¶Ô·¾¶(HTMLÖеÄÏà¶ÔĿ¼)£¬ÀýÈ磺ÔÚ ServletÖУ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ