这是一个URL它提供了Java项目所推荐的处理此项目所用的类库

http://www.oschina.net/project/tag/258/excel-tools?company=0&sort=score&tag=258&lang=19&recommend=false

Java用Apache的POI库对Excel进行操作；

其他Excel开发库: 

Apache POI 下载地址: 

 

转载链接：http://www.cnblogs.com/wunaozai/p/4179270.html

 

 

Excel 2003 (xls后缀)

　　读：

1 import java.io.FileInputStream; 2  3 import org.apache.poi.hssf.usermodel.HSSFRow; 4 import org.apache.poi.hssf.usermodel.HSSFSheet; 5 import org.apache.poi.hssf.usermodel.HSSFWorkbook; 6  7 public class ReadExcel2003 { 8     public static void main(String[] args) { 9         try {10             FileInputStream file = new FileInputStream("C:\\dd.xls");11             12             HSSFWorkbook workbook = new HSSFWorkbook(file);13             HSSFSheet sheet = workbook.getSheetAt(0);14             HSSFRow row = null;15 16             for(int i=0;sheet.getRow(i)!=null;i++){17                 row = sheet.getRow(i);18                 for(int j=0;row.getCell(j)!=null;j++){19                     System.out.print(row.getCell(j)+"");20                 }21                 System.out.println();22             }23         } catch (Exception e) {24             e.printStackTrace();25         }26     }27 }

　　写：

1 import java.io.FileOutputStream; 2  3 import org.apache.poi.hssf.usermodel.HSSFCell; 4 import org.apache.poi.hssf.usermodel.HSSFRow; 5 import org.apache.poi.hssf.usermodel.HSSFSheet; 6 import org.apache.poi.hssf.usermodel.HSSFWorkbook; 7  8 public class WriteExcel2003 { 9     public static void main(String[] args) {10         try {11             HSSFWorkbook workbook = new HSSFWorkbook();12             HSSFSheet sheet = workbook.createSheet("test"); //页签13             HSSFRow row = sheet.createRow(1);14             HSSFCell cell = row.createCell(2);15             cell.setCellValue("test");16             for (int i=0;i<100;i++){17                 row = sheet.createRow(i);18                 for(int j=0;j<100;j++){19                     cell = row.createCell(j);20                     cell.setCellValue("("+i+","+j+")");21                 }22             }23             FileOutputStream os = null;24             os = new FileOutputStream("C:\\dd.xls");25             workbook.write(os);26             os.flush();27             os.close();28         } catch (Exception e) {29             e.printStackTrace();30         }31         System.out.println("Ok");32     }33 }

Excel 2007 (xlsx 后缀)

　　读：

1 import java.io.FileInputStream; 2  3 import org.apache.poi.xssf.usermodel.XSSFRow; 4 import org.apache.poi.xssf.usermodel.XSSFSheet; 5 import org.apache.poi.xssf.usermodel.XSSFWorkbook; 6  7 public class ReadExcel2007 { 8     public static void main(String[] args) { 9         try {10             FileInputStream file = new FileInputStream("C:\\bb.xlsx");11             XSSFWorkbook workbook  = new XSSFWorkbook(file);12             XSSFSheet sheet = workbook.getSheetAt(0);13             14             XSSFRow row = null;15             16             for(int i=0;sheet.getRow(i)!=null;i++){17                 row = sheet.getRow(i);18                 for(int j=0;row.getCell(j)!=null;j++){19                     System.out.print(row.getCell(j)+" ");20                 }21                 System.out.println();22             }23         } catch (Exception e) {24             e.printStackTrace();25         }26     }27 }

　　写：

1 import java.io.FileOutputStream; 2  3 import org.apache.poi.xssf.usermodel.XSSFCell; 4 import org.apache.poi.xssf.usermodel.XSSFRow; 5 import org.apache.poi.xssf.usermodel.XSSFSheet; 6 import org.apache.poi.xssf.usermodel.XSSFWorkbook; 7  8 public class WriteExcel2007 { 9     public static void main(String[] args) {10         try {11             XSSFWorkbook workbook = new XSSFWorkbook();12             XSSFSheet sheet = workbook.createSheet("test"); //页签13             XSSFRow row = sheet.createRow(1);14             XSSFCell cell = row.createCell(2);15             cell.setCellValue("test");16             for (int i=0;i<100;i++){17                 row = sheet.createRow(i);18                 for(int j=0;j<100;j++){19                     cell = row.createCell(j);20                     cell.setCellValue("("+i+","+j+")");21                 }22             }23             FileOutputStream os = null;24             os = new FileOutputStream("C:\\dd.xlsx");25             workbook.write(os);26             os.flush();27             os.close();28         } catch (Exception e) {29             e.printStackTrace();30         }31         System.out.println("Ok");32     }33 }