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
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
Èí»Ø³µ£¨Soft Return£©£ºÈí»Ø³µÊÇÔÚ×Ö´¦Àí³ÌÐòÖÐ×÷Ϊ×Ô¶¯ÒÆÐй¦ÄܵÄÒ»²¿·Ö×Ô¶¯²åÈëµÄ£¬Ò²½Ð»»Ðзû£¬ÔÚwordÖп´²»¼û¡£Èç¹ûÎı¾Ò»Ðеij¤¶È³¬¹ýÎĵµËù¶¨ÒåµÄÓұ߾àʱ£¬¼´µ±Ç°ÐÐûÓÐ×ã¹»µÄ¿Õ¼ä·ÅÖÃÏÂÒ»¸ö×Ö·ûʱ£¬ÎÄ×Ö´¦ÀíÈí¼þ½«ÔÚÕâÒ»ÐÐÎı¾µÄĩβ×Ô¶¯²åÈëÒ»¸öÈí»Ø³µ·û£¬Îı¾ÁíÆðÒ»ÐС£Õâ¸öÈí»Ø³µ·ûÊÇÓɱ༳ÌÐò×Ô¶¯²úÉúµÄ£¬½Ð× ......
Ò»¡¢Java¶àÏ̻߳¥³â¼°Í¬²½¿ØÖƺÍͨÐÅ
¶à¸öÏ̵߳ÄÖ´ÐÐÊDz¢·¢µÄ£¬Ò²¾ÍÊÇÔÚÂß¼Éϓͬʱ”£¬¶ø²»¹ÜÊÇ·ñÊÇÎïÀíÉϵēͬʱ”¡£Èç¹ûϵͳֻÓÐÒ»¸öCPU£¬ÄÇ̫;ÕýµÄ“ͬʱ”ÊDz»¿ÉÄܵ쬵«ÊÇÓÉÓÚCPUµÄËٶȷdz£¿ì£¬Óû§¸Ð¾õ²»µ½ÆäÖеÄÇø±ð£¬Òò´ËÎÒÃÇÒ²²»ÓùØÐÄËü£¬Ö»ÐèÒªÉèÏë¸÷¸öÏ ......
ѧϰÁËÏß³Ì,ÏòÁ¿·ºÐͱà³Ì,¿ÉÒÔͨ¹ýÒ»¸öʵÀýÀ´Ó¦ÓÃËùѧ֪ʶ,±¾¿ÎʵÏÖÁ˾µäÓÎϷ̰ʳÉß,×ÔÈÏΪ½á¹¹»¹ËãºÏÀíÓÚ2009Äê8ÔÂ12ÈÕ,16:05·Ö
ʵÏÖ̰ʳÉßµÄ˼·
1¡£Ê×Ïȶ¨Òå´°¿Ú200X400 £¬ÊµÏÖ¿ØÖÆ1¸ö¾ØÐη½¿é20X20
2¡£Í¨¹ý°´¼ü¿ØÖÆ·½¿éÒÆ¶¯
3¡£ÊµÏÖÏ߳̿ØÖÆ·½¿éÒÆ¶¯Ã¿´ÎÒ»¸ñ(20X20),ͨ¹ý°´¼ü¸Ä±ä·½Ïò
......
JavaÕýÔò±í´ïʽµÄ½âÊÍ˵Ã÷
±í´ïʽÒâÒ壺
1.×Ö·û
x ×Ö·û x¡£ÀýÈça±íʾ×Ö·ûa
\\ ·´Ð±Ïß×Ö·û¡£ÔÚÊéдʱҪдΪ\\\\¡££¨×¢Ò⣺ÒòΪjavaÔÚµÚÒ»´Î½âÎöʱ,°Ñ\\\\½âÎö³ÉÕýÔò±í´ïʽ\\£¬ÔÚµÚ¶þ´Î½âÎöʱÔÙ½âÎöΪ\£¬ËùÒÔ·²ÊDz»ÊÇ1.1Áоٵ½µÄתÒå×Ö·û£¬°üÀ¨1.1µÄ\\,¶øÓÖ´øÓÐ\µÄ¶¼ÒªÐ´Á½´Î£©
\0 ......