poi操作excel中sheet的复制(java版)

《poi操作excel中sheet的复制(java版)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、packagecn.labsoft.labos.utils.exportexcel;importjava.io.File;importjava.io.FileInputStream;importjava.io.FileNotFoundException;importjava.io.FileOutputStream;importjava.io.IOException;importjava.io.InputStream;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.p

2、oi.hssf.usermodel.HSSFCellStyle;importorg.apache.poi.hssf.usermodel.HSSFFont;importorg.apache.poi.hssf.usermodel.HSSFRichTextString;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;im

3、portorg.apache.poi.hssf.util.Region;importorg.apache.poi.ss.usermodel.Font;publicclassCopyExcelSheet{@SuppressWarnings("deprecation")publicstaticvoidmain(String[]args)throwsFileNotFoundException,IOException{StringfromPath="C:\Users\Administrator\Desktop\quinn\1.xls";/

4、/excel存放路径StringtoPath="C:\Users\Administrator\Desktop\quinn\5.xls";//保存新EXCEL路径copyExcelSheet(fromPath,toPath);}/***@Title:根据文件路径复制sheet*@Description:将fromPath文件中的sheet全部复制到toPath中*@param@paramfromPath源文件全路径*@param@paramtoPath新文件全路径*@param@throwsIOException*@return返回

5、类型*@throws*/@SuppressWarnings("deprecation")publicstaticvoidcopyExcelSheet(StringfromPath,StringtoPath)throwsIOException{//创建新的excelFiletoFile=newFile(toPath);HSSFWorkbookwbCreat=null;if(!toFile.isFile()){wbCreat=newHSSFWorkbook();//建立新HSSFWorkbook对象}else{InputStreamout=ne

6、wFileInputStream(toFile);wbCreat=newHSSFWorkbook(out);}FilefromFile=newFile(fromPath);if(fromFile.exists()){try{InputStreamin=newFileInputStream(fromFile);HSSFWorkbookwb=newHSSFWorkbook(in);for(intii=0;ii

7、reat.getSheetIndex(sheet.getSheetName())>=0){continue;}HSSFSheetsheetCreat=wbCreat.createSheet(sheet.getSheetName());//复制源表中的合并单元格MergerRegion(sheetCreat,sheet);intfirstRow=sheet.getFirstRowNum();intlastRow=sheet.getLastRowNum();for(inti=firstRow;i<=lastRow;i++){//创建新建exce

8、lSheet的行HSSFRowrowCreat=sheetCreat.createRow(i);//取得源有excelSheet的行HSSFRowrow=sheet.getRow