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

java parse excel

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
/**
* EXCELÎĵµ½âÎö¹¤¾ßÀà
* ¸Ã¹¤¾ßÄܽ«EXCELÎĵµÖеıí½âÎöΪÓÉJAVA»ù´¡À๹³ÉµÄÊý¾Ý¼¯ºÏ
* Õû¸öEXCEL±íÓɶà¸öÐÐ×é³É.ÿÐÐÓÃÒ»¸öLIST±íʾ.
* EXCELÖеÄÐÐÓÉÒ»¸öLIST±íʾ,¸÷ÁеÄÊý¾ÝË÷Òý´Ó0¿ªÊ¼Ò»Ò»¶ÔÆë´æ·ÅÔÚÕâ¸öLISTÖÐ;
* ¶à¸öÐй¹³ÉÕû¸ö±í,ÓÉÒ»¸öLIST´æ·Å¶à¸öÐÐ.
*
*******************************************
* com.trumptech.common.fileParser.excel
* 2007-6-15
* 16:20:38
* author linfan
*******************************************
*/
public class ExcelSheetParser {
private Logger logger= Logger.getLogger(ExcelSheetParser.class);
private HSSFWorkbook workbook ;
public ExcelSheetParser(File excelFile) throws FileNotFoundException, IOException{
   workbook = new HSSFWorkbook(new FileInputStream(excelFile));
}
/**
* »ñµÃ±íÖеÄÊý¾Ý
* @param sheetNumber ±í¸ñË÷Òý(EXCEL ÊǶà±íÎĵµ,ËùÒÔÐèÒªÊäÈë±íË÷ÒýºÅ)
* @return ÓÉLIST¹¹³ÉµÄÐкͱí
* @throws FileNotFoundException
* @throws IOException
*/
public List<List> getDatasInSheet(int sheetNumber) throws FileNotFoundException, IOException{
   List<List> result = new ArrayList<List>();
  
   //»ñµÃÖ¸¶¨µÄ±í
   HSSFSheet sheet = workbook.getSheetAt(sheetNumber);
  
   //»ñµÃÊý¾Ý×ÜÐÐÊý
   int rowCount = sheet.getLastRowNum();
   logger.info("found excel rows count: " + rowCount);
   if (rowCount < 1) {
    return result;
   }
  
   //ÖðÐжÁÈ¡Êý¾Ý
   for (int rowIndex = 0; rowIndex <= rowCount; rowIndex++) {
   
  &n


Ïà¹ØÎĵµ£º

javaÁгöijÎļþ¼ÐϵÄËùÓÐÎļþ


File   f=new   File("DerectoryName");      
  String   []results=f.list();   
  
import java.io.*;    
¡¡¡¡public class listFile    
¡¡¡¡{  &nb ......

javaµ÷ÓÃdllÀý×Ó


×î¼Ñ´ð°¸
1. ±àд·¶ÀýÎĵµ
public class TestNative
{
private native static int Max(int a,int b);
public static void main(String[] args)
{
System.out.println(Max(4,5));
}
static
{
System.loadLibrary("VCdll");
}
}
ÆäÖÐ
LoadLibraryÖеÄDLLÎļþÃû³Æ¿ÉÒÔ ......

javaÖеÄstringÀàÐÍÈ«Ãæ½âÎö

1. Ê×ÏÈString²»ÊôÓÚ8ÖÖ»ù±¾Êý¾ÝÀàÐÍ£¬StringÊÇÒ»¸ö¶ÔÏó¡£
¡¡¡¡ÒòΪ¶ÔÏóµÄĬÈÏÖµÊÇnull£¬ËùÒÔStringµÄĬÈÏÖµÒ²ÊÇnull£»µ«ËüÓÖÊÇÒ»ÖÖÌØÊâµÄ¶ÔÏó£¬ÓÐÆäËü¶ÔÏóûÓеÄÒ»Ð©ÌØÐÔ¡£
¡¡¡¡2. new String()ºÍnew String(“”)¶¼ÊÇÉêÃ÷Ò»¸öеĿÕ×Ö·û´®£¬Êǿմ®²»ÊÇnull£»
¡¡¡¡3. String str=”kvill”£»
......

java±¨±íJXLºÍPOI´òÓ¡ÉèÖÃ


JXLµÄ´òÓ¡ÉèÖÃÔÚjxl.SheetSettingsÕâ¸öÀàÖУ¬ÎÒÃÇ¿ÉÒÔͨ¹ý·½·¨Sheet£¨»òÕßWritableSheet£©#getSettings()»ñÈ¡¡£
1.Ò³Ãæ
1.1·½Ïò
SheetSetting#setOrientation(PageOrientation po)£»
²ÎÊý£º  PageOrientation#LANDSCAPE       ºáÏò´òÓ¡
PageOrientation# PO ......

javaÖÐÒì³£·ÖÀà


1. Òì³£»úÖÆ
      Òì³£»úÖÆÊÇÖ¸µ±³ÌÐò³öÏÖ´íÎóºó£¬³ÌÐòÈçºÎ´¦Àí¡£¾ßÌåÀ´Ëµ£¬Òì³£»úÖÆÌṩÁ˳ÌÐòÍ˳öµÄ°²È«Í¨µÀ¡£µ±³öÏÖ´íÎóºó£¬³ÌÐòÖ´ÐеÄÁ÷³Ì·¢Éú¸Ä±ä£¬³ÌÐòµÄ¿ØÖÆÈ¨×ªÒƵ½Òì³£´¦ÀíÆ÷¡£
      ´«Í³µÄ´¦ÀíÒì³£µÄ°ì·¨ÊÇ£¬º¯Êý·µ»ØÒ»¸öÌØÊâµÄ½á¹ûÀ´±íʾ³öÏÖÒì³££¨Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ