输入sheet表名
package com.brains.crm.i18;
import java.io.*;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import org.apache.ofbiz.base.util.Debug;
import org.apache.ofbiz.base.util.UtilValidate;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;
public class ExcelToXml {
public static void main(String[] args) {
try {
InputStream inp = new FileInputStream(new File("D:\CRM-中英文-王金强.xlsx"));
String sheetName = "order";
List
直接整个Excle表
package com.brains.crm.i18;
import java.io.*;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import org.apache.ofbiz.base.util.Debug;
import org.apache.ofbiz.base.util.UtilValidate;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;
public class ExcelToXmlList {
public static void main(String[] args) throws FileNotFoundException {
InputStream inp = new FileInputStream(new File("D:\CRM-中英文-partygroup.xlsx"));
List> list = readExcel(inp);
}
public static List> readExcel(InputStream inputStream) {
//定义工作簿
XSSFWorkbook xssfWorkbook = null;
try {
xssfWorkbook = new XSSFWorkbook(inputStream);
} catch (Exception e) {
System.out.println("Excel data file cannot be found!");
}
int numberOfSheets = xssfWorkbook.getNumberOfSheets();
List> list = new ArrayList>();
for (int i = 0; i < numberOfSheets; i++) {
List> sheetList = new ArrayList>();
XSSFSheet sheetAt = xssfWorkbook.getSheetAt(i);
//定义工作表
String sheetName = xssfWorkbook.getSheetName(i);
int maxRow = sheetAt.getLastRowNum();
//默认第一行为标题行,index = 0
XSSFRow titleRow = sheetAt.getRow(0);
for (int row = 1; row <= maxRow; row++) {
XSSFRow xss = sheetAt.getRow(row);
if (xss != null) {
int maxRol = sheetAt.getRow(row).getLastCellNum();
Map map = new LinkedHashMap();
for (int rol = 1; rol < maxRol; rol++) {
XSSFCell cell = sheetAt.getRow(row).getCell(rol);
if (UtilValidate.isNotEmpty(cell)) {
cell.setCellType(CellType.STRING);
//System.out.print(cell.getStringCellValue());
if (UtilValidate.isNotEmpty(titleRow.getCell(rol))) {
map.put(titleRow.getCell(rol).getStringCellValue(), cell.getStringCellValue());
}
}
}
sheetList.add(map);
}
}
StringBuffer xmlDetails = new StringBuffer();
xmlDetails.append("n");
xmlDetails.append("n");
for (Map map : sheetList) {
if (UtilValidate.isNotEmpty(map.get("KEY"))) {
xmlDetails.append(" n");
} else if (UtilValidate.isNotEmpty(map.get("EN"))) {
xmlDetails.append(" n");
} else {
xmlDetails.append(" n");
}
xmlDetails.append(" ").append(map.get("ZH")).append(" n");
xmlDetails.append(" ").append(map.get("EN")).append(" n");
xmlDetails.append(" ").append(map.get("JA")).append(" n");
xmlDetails.append(" n");
}
xmlDetails.append(" n");
try {
// 生成xml文件
File file = new File("E:\workspace\svn\scsk_pj\SccmPlatform\04Code\crm\trunk\plugins\crm\config\CrmUitLabels-" + sheetName + ".xml");
if (!file.exists()) {
file.createNewFile();
}
OutputFormat format = OutputFormat.createPrettyPrint();
XMLWriter writer = new XMLWriter(new FileOutputStream(file), format);
// 设置是否转义,默认使用转义字符
writer.setEscapeText(false);
writer.write(xmlDetails.toString());
writer.close();
System.out.println("CrmUitLabels-" + sheetName + ".xml成功");
} catch (Exception e) {
Debug.logError(e, "CrmUitLabels-" + sheetName + ".xml失败");
System.out.println("CrmUitLabels-" + sheetName + ".xml失败");
}
}
return list;
}
}



