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
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
Èí»Ø³µ£¨Soft Return£©£ºÈí»Ø³µÊÇÔÚ×Ö´¦Àí³ÌÐòÖÐ×÷Ϊ×Ô¶¯ÒÆÐй¦ÄܵÄÒ»²¿·Ö×Ô¶¯²åÈëµÄ£¬Ò²½Ð»»Ðзû£¬ÔÚwordÖп´²»¼û¡£Èç¹ûÎı¾Ò»Ðеij¤¶È³¬¹ýÎĵµËù¶¨ÒåµÄÓұ߾àʱ£¬¼´µ±Ç°ÐÐûÓÐ×ã¹»µÄ¿Õ¼ä·ÅÖÃÏÂÒ»¸ö×Ö·ûʱ£¬ÎÄ×Ö´¦ÀíÈí¼þ½«ÔÚÕâÒ»ÐÐÎı¾µÄĩβ×Ô¶¯²åÈëÒ»¸öÈí»Ø³µ·û£¬Îı¾ÁíÆðÒ»ÐС£Õâ¸öÈí»Ø³µ·ûÊÇÓɱ༳ÌÐò×Ô¶¯²úÉúµÄ£¬½Ð× ......
1¡¢Óï»ãµ¥ÔªµÄ×é³É£º
1£©¾¹ý·ÖÎö²úÉúµÄ»ù±¾µ¥Ôª¡£ÔÚË÷Òýʱ£¬LuceneʹÓÃÌØ¶¨µÄ·ÖÎöÆ÷À´´¦ÀíÐèÒª±»Óï»ãµ¥Ôª»¯µÄÖ¸¶¨Óò£¬²¢½«Ã¿¸öÓï»ãµ¥ÔªÒÔÏîµÄÐÎʽдÈëË÷Òý¡£
2£©ÆðµãÆ«ÒÆÁ¿ÊÇÖ¸Óï»ãµ¥ÔªÎı¾µÄÆðʼ×Ö·ûÔÚÔ¹ãÎ÷ÖеÄλÖ㬶øÖÕµãµÄÆ«ÒÆÁ¿Ôò±íʾÓï»ãµ¥ÔªÖÕÖ¹×Ö·ûµÄÏÂÒ»¸öλÖá£
3£©Îı¾±»Óï»ãµ¥Ôª»¯ºó£¬Ïà¶ÔÓÚǰһÓï»ãµ¥ ......
ÌâÄ¿£ºÊ¹ÓÃJavaʵÏÖÁ´±í
˼·£º
Á´±íµÄÌØµã£ºÁ´±íµÄµÄÔªËØÖ®¼äͨ¹ýÖ¸ÕëÁ¬½ÓÆðÀ´¡£Í¨³£ÓÐÒ»¸öÍ·Ö¸ÕëÖ¸ÏòµÚÒ»¸öÔªËØ£¬Í¨¹ýµÚÒ»¸öÔªËØ¿ÉÒÔ·ÃÎʵ½ÆäËûµÄÔªËØ¡£
Á´±íÖÐÊý¾ÝÈçºÎ´æ´¢£ºÁ´±íÖеÄÿ¸öÔªËØÓ¦¸ÃÓɱíʾÊý¾ÝµÄÓòºÍÖ¸ÏòÆäËûÔªËØµÄÖ¸Õë×é³É¡£
Á´±íµÄ³£ÓòÙ×÷£º´´½¨Á´±í¡¢ÔÚÁ´±íÖÐÌí¼ÓÔªËØ£¨ÔÚ×îºóÌí¼Ó»òÕßÔÚij¸ö¾ßÌåµÄ ......
01. ˵³öArrayList,VectorµÄÇø±ð£¬HashMapºÍHashtableµÄÇø±ð¡£
02. final, finally, finalizeµÄÇø±ð¡£
03. abstract classºÍinterfaceÓÐÊ²Ã´Çø±ð?
04. ʲôʱºòÓÃassert¡£
05. GCÊÇʲô? ΪʲôҪÓÐGC?&nb ......