java²Ù×÷excelÎļþ
Õâ¸öÊÇ×Ô¼º¹ýȥΪÁË·½±ã²Ù×÷excelÊý¾Ý,дµÄÒ»¸ö¹¤¾ßÀà,ûÓÐÓÅ»¯¹ý,ºÇºÇ
ÉÏÃæµÄÊǹ¤¾ßÀà,ÏÂÃæÌáÓ÷¨,д·¨ºÜ±¿,µ«ÓÃ×Å»¹ºÜ·½±ã
package com.dtb.utils;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
* JAVA ²Ù×÷ excel ÖÐµÄ .xlsÎļþ¸ñʽ
* @author dtb
*
*/
public class ExcelUtil {
/** ¹¤×÷±í*/
private Workbook rwb;
/** д²Ù×÷±í*/
private WritableWorkbook wwb;
public ExcelUtil(){}
/**
* ¹¹Ô캯Êý
* @param fileName - ÎļþÃû
*/
public ExcelUtil(String fileName) {
try {
rwb = Workbook.getWorkbook(new FileInputStream(fileName));
} catch (BiffException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* ¾²Ì¬¹¤³§·½·¨,·µ»Ø¶Á²Ù×÷µÄExcelUtil¶ÔÏó
* @param fileName - ÎļþÃû
* @return this
*/
public static ExcelUtil getReadExcelUtil(String fileName) {
ExcelUtil eu = new ExcelUtil();
try {
eu.rwb = Workbook.getWorkbook(new FileInputStream(fileName));
} catch (BiffException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return eu;
}
/**
* ¾²Ì¬¹¤³§·½·¨,·µ»ØÐ´²Ù×÷µÄExcelUtil¶ÔÏó
* @param fileName - ÎļþÃû
* @return this
*/
public static ExcelUtil getWriteExcelUtil(String fileName) {
ExcelUtil eu = new ExcelUtil();
try {
eu.wwb = Workbook.createWorkbook(new FileOutputStream(fileName));
} catch (FileNotFoundException e) {
e.printStackTrace();
} cat
Ïà¹ØÎĵµ£º
Ò»£º×¼±¸ www.savarese.org download
1. rocksaw-1.0.0-src.tar.gz
2. vserv-tcpip-0.9.2-src.tar.gz
¶þ£º±àÒëÔ´ÎļþµÃµ½jar°ü ʹÓÃAnt
1. build vserv-tcpip-0.9.2-src
ÔÚvserv-tcpip-0.9.2Ŀ¼ÏÂÃæ½¨Ò»¸ötestsĿ¼£¬È»ºóÔÚcmd´°¿ÚϽøÈë ......
Java ÌṩÁ½ÖÖ²»Í¬µÄÀàÐÍ£ºÒýÓÃÀàÐͺÍÔʼÀàÐÍ£¨»òÄÚÖÃÀàÐÍ£©¡£IntÊÇjavaµÄÔʼÊý¾ÝÀàÐÍ£¬IntegerÊÇjavaΪintÌṩµÄ·â×°Àà¡£JavaΪÿ¸öÔʼÀàÐÍÌṩÁË·â×°Àà¡£
ÔʼÀàÐÍ·â×°Àà
boolean -->Boolean
char --->Character
byte -->Byte
short -->Short
int -->Integer
long -->Long
float -- ......
Õ»Óë¶Ñ¶¼ÊÇJavaÓÃÀ´ÔÚRAMÖдæ·ÅÊý¾ÝµÄµØ·½¡£ÓëC++²»Í¬£¬Java×Ô¶¯¹ÜÀíÕ»ºÍ¶Ñ£¬³ÌÐòÔ±²»ÄÜÖ±½ÓµØÉèÖÃÕ»»ò¶Ñ¡£
JavaµÄ¶ÑÊÇÒ»¸öÔËÐÐʱÊý¾ÝÇø,ÀàµÄ¶ÔÏó´ÓÖзÖÅä¿Õ¼ä¡£ÕâЩ¶ÔÏóͨ¹ýnew¡¢newarray¡¢anewarrayºÍmultianewarrayµÈÖ¸ÁÁ¢£¬ËüÃDz»ÐèÒª³ÌÐò´úÂëÀ´ÏÔʽµÄÊÍ·Å¡£¶ÑÊÇÓÉÀ¬»ø»ØÊÕÀ´¸ºÔðµÄ£¬¶ÑµÄÓÅÊÆÊÇ¿ÉÒÔ¶¯Ì¬µØ·ÖÅäÄÚ´æ´ ......
Ãû´Ê½âÊÍ£º
²¹Â룺1 ÔÚ¼ÆËã»úϵͳÖУ¬ÊýÖµÒ»ÂÉÓв¹ÂëÀ´±íʾ(´æ´¢). ʹÓò¹Âë,¿ÉÒÔ½«·ûºÅλºÍÆäËûλͳһ´¦Àí;ͬʱ,¼õ·¨Ò²¿É°´¼Ó·¨À´´¦Àí.ÁíÍâ,Á½¸öÓò¹Âë±íʾµÄÊý¾ÝÏà¼Óʱºò,Èç¹û×î¸ßλ(·ûºÅλ)ÓнøÎ»,Ôò½øÎ¥±»ÉáÆú.
2 ²¹ÂëÓëÔ ......