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

Java Excel API ʹÓ÷½·¨

WorkbookÀàÌṩµÄ·½·¨ 
¡¡¡¡1. int getNumberOfSheets() 
¡¡¡¡»ñµÃ¹¤×÷±¡£¨Workbook£©Öй¤×÷±í£¨Sheet£©µÄ¸öÊý£¬Ê¾Àý£º 
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File(sourcefile)); 
int sheets = rwb.getNumberOfSheets();  
¡¡¡¡2. Sheet[] getSheets() 
¡¡¡¡·µ»Ø¹¤×÷±¡£¨Workbook£©Öй¤×÷±í£¨Sheet£©¶ÔÏóÊý×飬ʾÀý£º 
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File(sourcefile)); 
Sheet[] sheets = rwb.getSheets();  
¡¡¡¡3. String getVersion() 
¡¡¡¡·µ»ØÕýÔÚʹÓõÄAPIµÄ°æ±¾ºÅ£¬ºÃÏñÊÇûʲô̫´óµÄ×÷Óᣠ
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File(sourcefile)); 
String apiVersion = rwb.getVersion();  
¡¡¡¡Sheet½Ó¿ÚÌṩµÄ·½·¨ 
¡¡¡¡1) String getName() 
¡¡¡¡»ñÈ¡SheetµÄÃû³Æ£¬Ê¾Àý£º 
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File(sourcefile)); 
jxl.Sheet rs = rwb.getSheet(0); 
String sheetName = rs.getName();  
¡¡¡¡2) int getColumns() 
¡¡¡¡»ñÈ¡Sheet±íÖÐËù°üº¬µÄ×ÜÁÐÊý£¬Ê¾Àý£º 
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File(sourcefile)); 
jxl.Sheet rs = rwb.getSheet(0); 
int rsColumns = rs.getColumns();  
¡¡¡¡3) Cell[] getColumn(int column) 
¡¡¡¡»ñȡijһÁеÄËùÓе¥Ôª¸ñ£¬·µ»ØµÄÊǵ¥Ôª¸ñ¶ÔÏóÊý×飬ʾÀý£º 
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File(sourcefile)); 
jxl.Sheet rs = rwb.getSheet(0); 
Cell[] cell = rs.getColumn(0);  
¡¡¡¡4) int getRows() 
¡¡¡¡»ñÈ¡Sheet±íÖÐËù°üº¬µÄ×ÜÐÐÊý£¬Ê¾Àý£º 
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File(sourcefile)); 
jxl.Sheet&n


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

¸÷ÖÖÅÅÐòËã·¨JAVAʵÏÖ

public class Sort {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
int[] arry = { 19, 10, 5, 45, 100, 30, 35, 29 };
int[] sortArry = mergeSort(arry);
for (int i = 0; i < sortArry.le ......

JAVA ÍøÉÏʰÒÅ

public String makeStars(int size, char ch) {
    if(size < 1) {
        throw new IllegalArgumentException("size must be greater than 0");
    }
    char[] chs = new char[size];
    for(int i = 0; ......

JavaÖÐÏ̵߳ĸ߼¶Ó¦ÓÃ

Ò»¡¢Java¶àÏ̻߳¥³â¼°Í¬²½¿ØÖƺÍͨÐÅ
    ¶à¸öÏ̵߳ÄÖ´ÐÐÊDz¢·¢µÄ£¬Ò²¾ÍÊÇÔÚÂß¼­Éϓͬʱ”£¬¶ø²»¹ÜÊÇ·ñÊÇÎïÀíÉϵēͬʱ”¡£Èç¹ûϵͳֻÓÐÒ»¸öCPU£¬ÄÇ̫;ÕýµÄ“ͬʱ”ÊDz»¿ÉÄܵ쬵«ÊÇÓÉÓÚCPUµÄËٶȷdz£¿ì£¬Óû§¸Ð¾õ²»µ½ÆäÖеÄÇø±ð£¬Òò´ËÎÒÃÇÒ²²»ÓùØÐÄËü£¬Ö»ÐèÒªÉèÏë¸÷¸öÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ