package main.shishi;
import org.apache.commons.compress.archivers.dump.InvalidFormatException;
import org.apache.poi.hssf.usermodel.;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;
import main.java.ExportExcelUtils;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.;
import javax.swing.filechooser.FileSystemView;
import java.awt.;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.;
import java.nio.charset.Charset;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.;
import java.util.List;
import java.util.zip.ZipFile;
public class POIMergeExcelUtil extends JFrame implements ActionListener {
JButton open = null;
/**
* 讀取某個文件夾下的所有文件
*/
public static boolean readfile(List<String> lisst) throws FileNotFoundException, IOException {
try {
OutputStream out = new FileOutputStream("C:\\Users\\conghan\\Desktop\\new.xls");
ExportExcelUtils eeu = new ExportExcelUtils();
HSSFWorkbook workbooks = new HSSFWorkbook();
Sheet sheet = null;
List<List<String>> data = new ArrayList<List<String>>();
List<List<String>> datas = new ArrayList<List<String>>();
List<List<String>> datasf = new ArrayList<List<String>>();
List<String> list = new ArrayList<>();
Object sell = null;
Object sells = null;
//第1個sheet
for (int i = 0; i < lisst.size(); i++) {
File readfile = new File(lisst.get(i));
File file = new File(lisst.get(i));
String region = file.getName().substring(10, 12);
if (!readfile.isDirectory()) {
FileInputStream fileInputStream = new FileInputStream(readfile.getPath());
Workbook workbook = new HSSFWorkbook(fileInputStream); //讀取excel
//循環sheet
for (int f = 0; f < 1; f++) {
sheet = workbook.getSheetAt(f);//獲取sheet
//循環行
for (int j = 0; j < 1; j++) {
Row row = sheet.getRow(j); // 獲取行
//循環列
for (int k = 0; k < row.getPhysicalNumberOfCells(); k++) {
if (f == 2 && i == 0) {
Cell cell = row.getCell(k); //獲取單元格
sells = (Object) cell;
list.add(sells.toString());
}
}
}
for (int j = 1; j < sheet.getPhysicalNumberOfRows(); j++) {
List<String> lista = new ArrayList<>();
Row row = sheet.getRow(j); // 獲取行
for (int k = 0; k < row.getPhysicalNumberOfCells(); k++) {
Cell cell = row.getCell(k); //獲取單元格
sell = (Object) cell;
if (sell != null) {
lista.add(sell.toString());
}
}
data.add(lista);
}
datas = data;
}
} else if (readfile.isDirectory()) {
// readfile(filepath + “\” + filelist[i]);
}
}
try {
String[] headers = new String[list.size()];
for (int b = 0; b < list.size(); b++) {
headers[b] = list.get(b);
}
eeu.exportExcel(workbooks, 0, sheet.getSheetName(), headers, data, out);
data.clear();
list.clear();
} catch (Exception e) {
e.printStackTrace();
}
workbooks.write(out);
out.close();
} catch (FileNotFoundException e) {
System.out.println("readfile() Exception:" + e.getMessage());
}
return true;
}
public static void main(String[] args) {
new POIMergeExcelUtil();
}
public static List<String> traverseFolder1(String path) {
int fileNum = 0;
int folderNum = 0;
List<String> listdd = new ArrayList<>();
File file = new File(path);
if (file.exists()) {
LinkedList<File> list = new LinkedList<File>();
File[] files = file.listFiles();
for (File file2 : files) {
if (file2.isDirectory()) {
list.add(file2);
folderNum++;
} else {
listdd.add(file2.getAbsolutePath());
fileNum++;
}
}
File temp_file;
while (!list.isEmpty()) {
temp_file = list.removeFirst();
files = temp_file.listFiles();
for (File file2 : files) {
if (file2.isDirectory()) {
list.add(file2);
folderNum++;
} else {
listdd.add(file2.getAbsolutePath());
fileNum++;
}
}
}
} else {
System.out.println("文件不存在!");
}
return listdd;
}
public POIMergeExcelUtil() {
open = new JButton("open");
this.add(open);
this.setBounds(500, 500, 400, 400);
this.setVisible(true);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
open.addActionListener(this);
}
@Override
public void actionPerformed(ActionEvent e) {
//文件選擇器獲取文件或者文件夾
//========================================
JFileChooser jfc = new JFileChooser();
FileSystemView fsv = FileSystemView.getFileSystemView();
jfc.setCurrentDirectory(fsv.getHomeDirectory());
//JFileChooser.FILES_AND_DIRECTORIES 選擇路徑和文件
jfc.setFileSelectionMode(JFileChooser.FILES_AND_DIRECTORIES);
//用戶選擇的路徑或文件
if (jfc.showOpenDialog(POIMergeExcelUtil.this) == JFileChooser.APPROVE_OPTION) {
File file = jfc.getSelectedFile();
if (file.isDirectory()) {
List list = traverseFolder1(file.getAbsolutePath());
try {
readfile(list);
} catch (IOException e1) {
e1.printStackTrace();
}
} else if (file.isFile()) {
List list = traverseFolder1(file.getAbsolutePath());
try {
readfile(list);
} catch (IOException e1) {
e1.printStackTrace();
}
}
}
maisssn();
}
public void maisssn() {
JOptionPane.showMessageDialog(null, "合并完成！！");
}
工具類
package main.java;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.HSSFColor;
import java.io.File;
import java.io.OutputStream;
import java.util.List;
public class ExportExcelUtils {
/**
* @Title: exportExcel
* @Description: 導出Excel的方法
* @author: evan @ 2014-01-09
* @param workbook
* @param sheetNum (sheet的位置，0表示第一個表格中的第一個sheet)
* @param sheetTitle （sheet的名稱）
* @param headers （表格的標題）
* @param result （表格的數據）
* @param out （輸出流）
* @throws Exception
*/
public void exportExcel(HSSFWorkbook workbook, int sheetNum,
String sheetTitle, String[] headers, List<List> result,
OutputStream out) throws Exception {
// 生成一個表格
HSSFSheet sheet = workbook.createSheet();
workbook.setSheetName(sheetNum, sheetTitle
);
HSSFCellStyle style = workbook.createCellStyle();
// 指定當單元格內容顯示不下時自動換行
style.setWrapText(true);
// 產生表格標題行
HSSFRow row = sheet.createRow(0);
for (int i = 0; i < headers.length; i++) {
HSSFCell cell = row.createCell(i);
cell.setCellStyle(style);
HSSFRichTextString text = new HSSFRichTextString(headers[i]);
cell.setCellValue(text.toString());
}
// 遍歷集合數據，產生數據行
if (result != null) {
int index = 1;
for (List<String> m : result) {
row = sheet.createRow(index);
int cellIndex = 0;
for (String str : m) {
HSSFCell cell = row.createCell(cellIndex);
cell.setCellValue(str.toString());
cellIndex++;
}
index++;
}
}
}
public void traverseFolder2(String path) {
File file = new File(path);
if (file.exists()) {
File[] files = file.listFiles();
if (null == files || files.length == 0) {
System.out.println("文件夾是空的!");
return;
} else {
for (File file2 : files) {
if (file2.isDirectory()) {
System.out.println("文件夾:" + file2.getAbsolutePath());
traverseFolder2(file2.getAbsolutePath());
} else {
System.out.println("文件:" + file2.getAbsolutePath());
}
}
}
} else {
System.out.println("文件不存在!");
}
}
}
本站文章版權歸原作者及原出處所有 。內容為作者個人觀點， 并不代表本站贊同其觀點和對其真實性負責，本站只提供參考并不構成任何投資及應用建議。本站是一個個人學習交流的平臺，網站上部分文章為轉載，并不用于任何商業目的，我們已經盡可能的對作者和來源進行了通告，但是能力有限或疏忽，造成漏登，請及時聯系我們，我們將根據著作權人的要求，立即更正或者刪除有關內容。本站擁有對此聲明的最終解釋權。
