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

java excel ÎļþÏÂÔØ

ʹÓÃservletÀ´ÏÂÔØÎļþ£¬ÆäÔ­Àí·Ç³£¼òµ¥£¬Ö»ÒªµÃµ½ÎļþµÄÊäÈëÁ÷£¨»òÏàÓ¦×Ö½Ú£©£¬È»ºóдÊä³öÁ÷¼´¿É¡£ÏÖ¾ÍÆäÖеöϸ½ÚÎÊÌâÕ¹¿ª£º
1. MIMEÀàÐ͵ÄÉèÖãº
Web ä¯ÀÀÆ÷ʹÓà MIME ÀàÐÍÀ´Ê¶±ð·Ç HTML Îĵµ£¬²¢¾ö¶¨ÈçºÎÏÔʾ¸ÃÎĵµÄÚµÄÊý¾Ý¡£
ÀýÈçEXCELÎļþµÄ MIME ÀàÐÍÊÇ "application/vnd.ms-excel "¡£ÒªÓÃservlet À´´ò¿ªÒ»¸ö EXCEL Îĵµ£¬ÐèÒª½« response ¶ÔÏóÖÐ header µÄ contentType ÉèÖóɓapplication/vnd.ms-excel ”¡£
response.setContentType(contentType);
2. Content disposition
HTTP response headerÖеÄcontent-disposition ÔÊÐí servlet Ö¸¶¨Îĵµ±íʾµÄÐÅÏ¢¡£Ê¹ÓÃÕâÖÖheader £¬Äã¾Í¿ÉÒÔ½«ÎĵµÖ¸¶¨³Éµ¥¶À´ò¿ª£¨¶ø²»ÊÇÔÚä¯ÀÀÆ÷Öдò¿ª£©£¬»¹¿ÉÒÔ¸ù¾ÝÓû§µÄ²Ù×÷À´ÏÔʾ¡£
Èç¹ûÓû§Òª±£´æÎĵµ£¬Ä㻹¿ÉÒÔΪ¸ÃÎĵµ½¨ÒéÒ»¸öÎļþÃû¡£Õâ¸ö½¨ÒéÃû³Æ»á³öÏÖÔÚ Save As ¶Ô»°¿òµÄ“ÎļþÃû”À¸ÖС£Èç¹ûûÓÐÖ¸¶¨£¬Ôò¶Ô»°¿òÖоͻá³öÏÖ servlet µÄÃû×Ö¡£
servlet ÖУ¬½« header ÉèÖóÉÏÂÃæÕâÑù£º
response.setHeader("Content-disposition","attachment;filename="+ "Example.xls" );
response.setHeader("Content-Disposition", "inline; filename="fliename)
µã»÷´ò¿ª»áÔÚieÖдò¿ª¡£
ÐèҪ˵Ã÷µÄÓÐÈýµã£º
Ø ÖÐÎÄÎļþÃûÐèÒª½øÐÐiso8859-1תÂë·½¿ÉÕýÈ·ÏÔʾ£º
fileName = new String(fileName.getBytes("GBK"),"iso8859-1");
Ø ´«µÝµÄÎļþÃû£¬ÐèÒª°üº¬ºó׺Ãû£¨Èç¹û´ËÎļþÓкó׺Ãû£©£¬·ñÔò¶ªÊ§ÎļþµÄÊôÐÔ£¬¶ø²»ÄÜ×ÔÐÐÑ¡ÔñÏà¹Ø³ÌÐò´ò¿ª¡£
Ø ÓÐÏÂÔØÇ°Ñ¯ÎÊ£¨ÊÇ´ò¿ªÎļþ»¹ÊDZ£´æµ½¼ÆËã»ú£©ºÍͨ¹ýIEä¯ÀÀÆ÷Ö±½ÓÑ¡ÔñÏà¹ØÓ¦ÓóÌÐò²å¼þ´ò¿ªÁ½ÖÖ·½Ê½£¬Ç°ÕßÈçÉÏ´úÂëËùʾ£¬ºóÕßÈçÏ£º
response.setHeader("Content-disposition","filename="+ "Example.xls" );
3. ÔÚÑо¿ÎļþµÄÉÏ´«¼°ÏÂÔØ¹ý³ÌÖУ¬Óм¸µãÌå»á
³ÌÐòµÄI/O²Ù×÷ÍùÍùÊÇÐÔÄܵį¿¾±ËùÔÚ£¬java io¶¨ÒåÁËÁ½¸ö»ù±¾µÄ³éÏóÀà:InputStreamºÍOutputStream,¶ÔÓÚ²»Í¬µÄÊý¾ÝÀàÐͱÈÈç´ÅÅÌ£¬ÍøÂçÓÖÌṩÁ˲»Í¬µÄʵÏÖ£¬java.ioÒ²ÌṩÁËһЩ»º³åÁ÷(BufferedStream)£¬Ê¹Ó²ÅÌ¿ÉÒԺܿìµÄ¶Áдһ´ó¿éµÄÊý¾Ý, ¶øJava»ù±¾µÄI/OÀàÒ»´ÎÖ»ÄܶÁдһ¸ö×Ö½Ú,µ«»º³åÁ÷(BufferedStream)¿ÉÒÔÒ»´Î¶ÁдһÅúÊý¾Ý£¬,»º³åÁ÷(Buffered Stream)´ó´óÌá¸ßÁËI/OµÄÐÔÄÜ¡£ËùÒÔ:
ØÐ¡¿éС¿éµÄ¶ÁдÊý¾Ý»á·Ç³£Âý,Òò´Ë,¾¡Á¿´ó¿éµÄ¶ÁдÊý¾Ý
ØÊ¹ÓÃBufferedInputStreamº


Ïà¹ØÎĵµ£º

24±¾Javaµç×ÓÊéÏÂÔØ


Core Java Volume I Fundamentals 8th Edition

Core Java Volume II Advanced Features 8th Edition

Java CAPS Basics Implementing Common EAI Patterns

Java³ÌÐòÉè¼Æ´óѧ½Ì³Ì

Ajax on Java

......

JAVA ÈÕÆÚ¹¤¾ßÀà

package com.gamvan.tools;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
public class FormatDateTime {

/**
* ÈÕÆÚÀà²Ù×÷¹¤¾ß
*/
public static String formatDateTime(String ymd){
//¸ñʽ»¯µ±Ç°Ê±¼ä
java.text ......

JAVAʼþµÄ×ܽá

JAVAʼþÎ޷ǾÍÊǼüÅÌʼþ£¬Êó±êʼþ£¬°´Å¥µÈʼþ¡£×¨Òµµã¿ÉÒÔ·ÖΪÓïÒåʼþ£¨°´Å¥µÈµ½Ê¼þ£©ºÍµÍ²ãʼþ£¨¼üÅÌʼþ£¬Êó±êʼþ£©£»
ÏÂÃæÎÒ¼òÒªµÄ×ܽáһϣº
1¡¢Êó±êʼþ£ºµãÊó±ê°´Å¥ÊÂËü»áµ÷ÓÃÈý¸ö¼àÌýÆ÷·½·¨£ºmousePressed,mouseReleased,mouseClicked.
Êó±êʼþÌṩÁËmousePressed,mouseClicked,mouseDragged,mouseEnter ......

Java »ù´¡Ìâ

 ÔÚÍøÉÏÕÒÁ˵ã»ù´¡ÌâÄ¿,×Ô¼º×öÁË×ö,ÏÂÃæÊÇÌâÄ¿:
  1.JavaÓÐÄÇЩ»ù±¾Êý¾ÝÀàÐÍ£¬StringÊDz»ÊÇ»ù±¾Êý¾ÝÀàÐÍ£¬ËûÃÇÓкÎÇø±ð¡£
  2.×Ö·û´®µÄ²Ù×÷£º
   Ð´Ò»¸ö·½·¨£¬ÊµÏÖ×Ö·û´®µÄ·´×ª£¬È磺ÊäÈëabc£¬Êä³öcba
   Ð´Ò»¸ö·½·¨£¬ÊµÏÖ×Ö·û´®µÄÌæ»»£¬È磺ÊäÈëbbbwlirbbb£¬Êä³öbbbhhtc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ