亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

row 行

cell 列

sheet表

生成導入模板

使用POI導出excel

public?class?PoiReadExcel?{

	public?static?void?main(String[]?args)?{
		//需要解析的Excel文件
		File?file?=?new?File("e:/poi_test.xls");
		try?{
			//創建工作簿，讀取文件內容
			HSSFWorkbook?workbook?=?new?HSSFWorkbook(FileUtils.openInputStream(file));
			//讀取Excel文件的第一個工作頁
			//方式一
			//HSSFSheet?sheet?=?workbook.getSheet("sheet0");
			//方式二
			HSSFSheet?sheet?=?workbook.getSheetAt(0);
			int?firstRowNum?=?0;??//第一行
			//獲取sheet中最后一行行號
			int?lastRowNum?=?sheet.getLastRowNum();??//獲取最后一行
			for(int?i=0;i<=lastRowNum;i++){
				HSSFRow?row?=?sheet.getRow(i);
				//獲取當前行最后單元格列號
				int?lastCellNum?=?row.getLastCellNum();
				//循環這一行來讀取每一個單元格中的內容
				for(int?j=0;j<lastCellNum;j++){
					//讀取
					HSSFCell?cell?=?row.getCell(j);
					String?value?=?cell.getStringCellValue();
					System.out.print(value+"?");
					
				}
				System.out.println();
			}
		}?catch?(Exception?e)?{
			e.printStackTrace();
		}
		

	}

}

通過POI創建EXCEL

引入POI相關的jar包poi-xxx.jar

import?org.apache.commons.io.FileUtils;
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;

import?java.io.File;
import?java.io.FileOutputStream;
import?java.io.IOException;

/**
?*?@author?xueli.li
?*?@create?2018/12/13?20:00
?*?@Description:
?**/
public?class?PoiExpExcel?{//POI生成Excel文件

????public?static?void?main(String[]?args)?{
????????String[]?title?=?{"id",?"name",?"sex"};
????????//創建Excel工作簿
????????HSSFWorkbook?workbook?=?new?HSSFWorkbook();
????????//創建一個工作表sheet
????????HSSFSheet?sheet?=?workbook.createSheet();
????????//創建第一行
????????HSSFRow?row?=?sheet.createRow(0);
????????HSSFCell?cell?=?null;
????????//插入第一行數據?id,name,sex
????????for?(int?i?=?0;?i?<?title.length;?i++)?{
????????????cell?=?row.createCell(i);
????????????cell.setCellValue(title[i]);
????????}
????????//追加數據
????????for?(int?i?=?1;?i?<=?10;?i++)?{
????????????HSSFRow?nextrow?=?sheet.createRow(i);
????????????HSSFCell?cell2?=?nextrow.createCell(0);
????????????cell2.setCellValue("a"?+?i);
????????????cell2?=?nextrow.createCell(1);
????????????cell2.setCellValue("user"?+?i);
????????????cell2?=?nextrow.createCell(2);
????????????cell2.setCellValue("男");
????????}
????????//創建一個文件
????????File?file?=?new?File("e:/poi_test.xls");
????????try?{
????????????file.createNewFile();
????????????//將Excel內容存盤//FileUtils類來自commons-io.jar包
????????????FileOutputStream?stream?=?FileUtils.openOutputStream(file);
????????????workbook.write(stream);
????????????stream.close();
????????}?catch?(IOException?e)?{
????????????e.printStackTrace();
????????}
????}
}

jXL讀取EXCEL

public?class?JslReadExcel?{

	public?static?void?main(String[]?args)?{
		//File?file?=?new?File("e:/jxl_test.xls");
		try?{
			//創建工作簿
			Workbook?workbook?=?Workbook.getWorkbook(new?File("e:/jxl_test.xls"));
			//獲取第一個工作表sheet頁
			Sheet?sheet?=?workbook.getSheet(0);
			//循環獲取
			//1.循環行
			for(int?i=0;i<sheet.getRows();i++){
				//2.循環列
				for(int?j=0;j<sheet.getColumns();j++){
					//獲取單元格內容
					Cell?cell?=?sheet.getCell(j,i);
					System.out.print(cell.getContents()+"?");
				}
				System.out.println();
			}
			//關閉流
			workbook.close();
		}?catch?(Exception?e)?{
			e.printStackTrace();
		}

	}

}

JXL創建Excel

下載并導入jxl.jar

public?class?JxlExcel?{
	public?static?void?main(String[]?args)?{
		//用數組存表頭
		String[]?title={"id","name","sex","age"};
		
		//創建Excel文件
		File?file?=?new?File("e:/jxl_test.xls");
		try?{
			file.createNewFile();
			//創建工作簿
			WritableWorkbook?workbook?=?Workbook.createWorkbook(file);
			//創建sheet
			WritableSheet?sheet?=?workbook.createSheet("sheet1",?0);
			//往sheet中添加數據
			Label?label?=?null;
			//第一行設置列名
			for(int?i=0;i<title.length;i++){
				//Label(i,0,title[i])?表示第i列第0行，值為title[i]
				label?=?new?Label(i,0,title[i]);
				//添加單元格
				sheet.addCell(label);
			}
			//追加數據
			for(int?i=1;i<10;i++){
				//Label(0,i,"a"+1)?表示第0列，第i行，值為“a”+1
				label?=?new?Label(0,i,"a"+i);
				sheet.addCell(label);
				label?=?new?Label(1,i,"user"+i);
				sheet.addCell(label);
				label?=?new?Label(2,i,"男");
				sheet.addCell(label);
				label?=?new?Label(3,i,"20");
				sheet.addCell(label);
			}
			workbook.write();
			workbook.close();
		}?catch?(Exception?e)?{
			e.printStackTrace();
		}
	}

}
?}

讀寫excel三種常用技術

1. POI

2. JXL

3. FASTEXCEL

POI和JXL對比

讀寫excel三種常用技術

1. POI

2. JXL

3. FASTEXCEL
   

定制excel導入模板