91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 1.45MB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2023-10-21
  • 語言: 其他
  • 標簽: POIExcel??

資源簡介

利用POI進行多張Excel表的合并。附源代碼。

資源截圖

代碼片段和文件信息

package?class_demo;

import?java.io.FileInputStream;
import?java.io.FileNotFoundException;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFCellstyle;
import?org.apache.poi.hssf.usermodel.HSSFFont;
import?org.apache.poi.hssf.usermodel.HSSFRow;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.hssf.util.Region;
import?org.apache.poi.poifs.filesystem.POIFSFileSystem;

public?class?Excel_Sheet?{
/*
?*?示例,在d盤放兩個示例Excel文件(單個Sheet)。
?*?生成后會在D盤產生一個合并好Sheet的Excel文件。exlsample_2.xls
?*/
public?static?void?main(String[]?args)?{
try?{
POIFSFileSystem?fs?=?new?POIFSFileSystem(new?FileInputStream(“d:\\exlsample.xls“));
POIFSFileSystem?fs_1?=?new?POIFSFileSystem(new?FileInputStream(“d:\\exlsample_1.xls“));
HSSFWorkbook?wb?=?new?HSSFWorkbook(fs);
HSSFWorkbook?wb_1?=?new?HSSFWorkbook(fs_1);
HSSFWorkbook?wbt?=?new??HSSFWorkbook();
//?source?target?為源sheet?頁和目標sheet頁
wbt?=?copyRows(wbwbt);
wbt?=?copyRows(wb_1wbt);
FileOutputStream?fileOut?=?new?FileOutputStream(“d:\\exlsample_2.xls“);
wbt.write(fileOut);
fileOut.flush();
fileOut.close();
System.out.println(“生成完成!“);
}?catch?(Exception?e)?{
e.printStackTrace();
}
}

/*
?*?對SHeet進行復制,將源Excle保存到目標Excle中
?*/
public?static?HSSFWorkbook?copyRows(HSSFWorkbook?wb?HSSFWorkbook?pTargetWb?)?{
int?pStartRow?=?0;???????????????????????//開始行
int?pEndRow?=0;??????????????????????????//結束行
int?pPosition?=?0;???????????????????????//位置
String?pSourceSheetName=““;
String?pTargetSheetName?=““;
HSSFRow?sourceRow?=?null;
HSSFRow?targetRow?=?null;
HSSFCell?sourceCell?=?null;
HSSFCell?targetCell?=?null;
HSSFSheet?sourceSheet?=?null;
HSSFSheet?targetSheet?=?null;
Region?region?=?null;
int?cType;
int?i;
short?j;
int?targetRowFrom;
int?targetRowTo;
if?((pStartRow?==?-1)?||?(pEndRow?==?-1))?{
return?null;
}
pSourceSheetName?=?wb.getSheetName(0);
pTargetSheetName?=?pSourceSheetName;
int?pTargetSheetNumber?=?pTargetWb.getNumberOfSheets()+1;
if(pTargetWb.getSheet(pTargetSheetName)?!=null){
pTargetSheetName?=?pTargetSheetName+pTargetSheetNumber;
}
pTargetWb.createSheet(pTargetSheetName);
sourceSheet?=?wb.getSheet(pSourceSheetName);
targetSheet?=?pTargetWb.getSheet(pTargetSheetName);
pEndRow?=?sourceSheet.getPhysicalNumberOfRows();
//?拷貝合并的單元格
for?(i?=?0;?i? region?=?sourceSheet.getMergedRegionAt(i);
if?((region.getRowFrom()?>=?pStartRow)
&&?(region.getRowTo()?<=?pEndRow))?{
targetRowFrom?=?region.getRowFrom()?-?pStartRow?+?pPosition;
targetRowTo?=?region.getRowTo()?-?pStartRow?+?pPosition;
region.setRowFrom(targetRowFrom);
region.setRowTo(targetRowTo);
targetSheet.addMergedRegion(region);
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????379??2012-03-31?09:53??POI_Excel_Sheet\Java_Demo\.classpath

?????文件????????784??2012-03-31?10:24??POI_Excel_Sheet\Java_Demo\.myeclipse\profiler\Excel_Sheet.xml

?????文件????????385??2012-03-31?09:13??POI_Excel_Sheet\Java_Demo\.project

?????文件????????629??2012-03-31?09:14??POI_Excel_Sheet\Java_Demo\.settings\org.eclipse.jdt.core.prefs

?????文件???????9299??2012-03-31?11:43??POI_Excel_Sheet\Java_Demo\bin\class_demo\Excel_Sheet.class

?????文件???????8491??2012-03-31?11:43??POI_Excel_Sheet\Java_Demo\src\class_demo\Excel_Sheet.java

?????文件????1675036??2011-08-22?11:25??POI_Excel_Sheet\poi-3.7-20101029.jar

?????文件??????16151??2012-03-31?15:24??POI_Excel_Sheet\POI_Excel_Sheet.docx

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\.myeclipse\profiler

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\bin\class_demo

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\src\class_demo

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\.myeclipse

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\.settings

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\bin

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\src

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet

-----------?---------??----------?-----??----

??????????????1711154????????????????????17


評論

共有 條評論