第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

row 行

cell 列

sheet表

生成導(dǎo)入模板

使用POI導(dǎo)出excel

public?class?PoiReadExcel?{

	public?static?void?main(String[]?args)?{
		//需要解析的Excel文件
		File?file?=?new?File("e:/poi_test.xls");
		try?{
			//創(chuàng)建工作簿，讀取文件內(nèi)容
			HSSFWorkbook?workbook?=?new?HSSFWorkbook(FileUtils.openInputStream(file));
			//讀取Excel文件的第一個(gè)工作頁
			//方式一
			//HSSFSheet?sheet?=?workbook.getSheet("sheet0");
			//方式二
			HSSFSheet?sheet?=?workbook.getSheetAt(0);
			int?firstRowNum?=?0;??//第一行
			//獲取sheet中最后一行行號(hào)
			int?lastRowNum?=?sheet.getLastRowNum();??//獲取最后一行
			for(int?i=0;i<=lastRowNum;i++){
				HSSFRow?row?=?sheet.getRow(i);
				//獲取當(dāng)前行最后單元格列號(hào)
				int?lastCellNum?=?row.getLastCellNum();
				//循環(huán)這一行來讀取每一個(gè)單元格中的內(nèi)容
				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創(chuàng)建EXCEL

引入POI相關(guān)的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"};
????????//創(chuàng)建Excel工作簿
????????HSSFWorkbook?workbook?=?new?HSSFWorkbook();
????????//創(chuàng)建一個(gè)工作表sheet
????????HSSFSheet?sheet?=?workbook.createSheet();
????????//創(chuàng)建第一行
????????HSSFRow?row?=?sheet.createRow(0);
????????HSSFCell?cell?=?null;
????????//插入第一行數(shù)據(jù)?id,name,sex
????????for?(int?i?=?0;?i?<?title.length;?i++)?{
????????????cell?=?row.createCell(i);
????????????cell.setCellValue(title[i]);
????????}
????????//追加數(shù)據(jù)
????????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("男");
????????}
????????//創(chuàng)建一個(gè)文件
????????File?file?=?new?File("e:/poi_test.xls");
????????try?{
????????????file.createNewFile();
????????????//將Excel內(nèi)容存盤//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?{
			//創(chuàng)建工作簿
			Workbook?workbook?=?Workbook.getWorkbook(new?File("e:/jxl_test.xls"));
			//獲取第一個(gè)工作表sheet頁
			Sheet?sheet?=?workbook.getSheet(0);
			//循環(huán)獲取
			//1.循環(huán)行
			for(int?i=0;i<sheet.getRows();i++){
				//2.循環(huán)列
				for(int?j=0;j<sheet.getColumns();j++){
					//獲取單元格內(nèi)容
					Cell?cell?=?sheet.getCell(j,i);
					System.out.print(cell.getContents()+"?");
				}
				System.out.println();
			}
			//關(guān)閉流
			workbook.close();
		}?catch?(Exception?e)?{
			e.printStackTrace();
		}

	}

}

JXL創(chuàng)建Excel

下載并導(dǎo)入jxl.jar

public?class?JxlExcel?{
	public?static?void?main(String[]?args)?{
		//用數(shù)組存表頭
		String[]?title={"id","name","sex","age"};
		
		//創(chuàng)建Excel文件
		File?file?=?new?File("e:/jxl_test.xls");
		try?{
			file.createNewFile();
			//創(chuàng)建工作簿
			WritableWorkbook?workbook?=?Workbook.createWorkbook(file);
			//創(chuàng)建sheet
			WritableSheet?sheet?=?workbook.createSheet("sheet1",?0);
			//往sheet中添加數(shù)據(jù)
			Label?label?=?null;
			//第一行設(shè)置列名
			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);
			}
			//追加數(shù)據(jù)
			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三種常用技術(shù)

1. POI

2. JXL

3. FASTEXCEL

POI和JXL對(duì)比

讀寫excel三種常用技術(shù)

1. POI

2. JXL

3. FASTEXCEL
   

定制excel導(dǎo)入模板