本文實(shí)例講述了Android開(kāi)發(fā)實(shí)現(xiàn)讀取excel數(shù)據(jù)并保存為xml的方法。分享給大家供大家參考，具體如下：
目前創(chuàng)新互聯(lián)公司已為成百上千家的企業(yè)提供了網(wǎng)站建設(shè)、域名、雅安服務(wù)器托管、成都網(wǎng)站托管、企業(yè)網(wǎng)站設(shè)計(jì)、伊春網(wǎng)站維護(hù)等服務(wù)，公司將堅(jiān)持客戶(hù)導(dǎo)向、應(yīng)用為本的策略，正道將秉承"和諧、參與、激情"的文化，與客戶(hù)和合作伙伴齊心協(xié)力一起成長(zhǎng)，共同發(fā)展。
前陣子，公司請(qǐng)外面人翻譯了一些android中values中的一些strings，然而保存的都是excel格式，如果單純的將excel中的數(shù)據(jù)粘貼到指定的xml中的話(huà)，工作量非常的大，于是，自己寫(xiě)了個(gè)簡(jiǎn)單的demo，將excel中的數(shù)據(jù)讀取并保存為xml對(duì)應(yīng)的數(shù)據(jù)，下面的demo和圖片展示：
1、數(shù)據(jù)保存在BeanValue中,包括key和value，方便后續(xù)數(shù)據(jù)讀取
重慶分公司
重慶分公司
package cn.excel.parser;
public class BeanValue {
private String key;
private String Value;
public BeanValue() {
}
public String getKey() {
return key;
}
public void setKey(String key) {
this.key = key;
}
public String getValue() {
return Value;
}
public void setValue(String value) {
Value = value;
}
}
2、數(shù)據(jù)解析，包括測(cè)試，直接在main方法中進(jìn)行
package cn.excel.parser;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.TreeMap;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerConfigurationException;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.read.biff.BiffException;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
public class ReadExcelFile {
private static final String SRC_FILE = "d://exceldoc/original/test.xls";
public static void main(String[] args) {
Map> mapList = ReadExcelFile();
System.out.println("excel size= " + mapList.size() + " ");
List namelists = readCol5Name();
System.out.println("namelists= " + namelists.size() + " ");
writeXmlFile(mapList, namelists);
}
/**
* 讀取excel表名，并保存在List列表中
* @return
*/
private static List readSheetName() {
InputStream is = null;
Workbook wb = null;
java.util.List list = null;
try {
is = new FileInputStream(SRC_FILE);
if (null != is) {
list = new ArrayList<>();
wb = Workbook.getWorkbook(is);
Sheet[] sheets = wb.getSheets();
int sheetLen = sheets.length;
for (int j = 0; j < sheetLen; j++) {
list.add(sheets[j].getName());
}// for
}// if
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (null != wb) {
wb.close();
}
if (null != is) {
try {
is.close();
} catch (IOException e) {
}
}
}
return list;
}
/**
* 讀取第五列的標(biāo)題名，并保持在List中
* @return
*/
private static List readCol5Name() {
InputStream is = null;
Workbook wb = null;
java.util.List list = null;
try {
is = new FileInputStream(SRC_FILE);
if (null != is) {
list = new ArrayList<>();
wb = Workbook.getWorkbook(is);
Sheet[] sheets = wb.getSheets();
int sheetLen = sheets.length;
for (int j = 0; j < sheetLen; j++) {
Sheet rs = wb.getSheet(j);
Cell[] cell = rs.getRow(0);
String packageName = cell[5].getContents();
list.add(packageName);
// System.out.println(packageName);
}// for
}// if
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (null != wb) {
wb.close();
}
if (null != is) {
try {
is.close();
} catch (IOException e) {
}
}
}
return list;
}
/**
* Map,保持單張表中第三行開(kāi)始，第2列和第5列的值（TreeMap可以按順序加載）
* 返回Map>，保證Integer和表的索引一一對(duì)應(yīng)
* 也可保持為L(zhǎng)ist>
* @return
*/
private static Map> ReadExcelFile() {
InputStream is = null;
Workbook wb = null;
Map> mapList = null;
Map maps = null;
java.util.List> list = null;
WorkbookSettings woSettings = null;
try {
is = new FileInputStream(SRC_FILE);
if (null != is) {
mapList = new HashMap>();
list = new ArrayList<>();
woSettings = new WorkbookSettings();
woSettings.setEncoding("ISO-8859-1");//設(shè)置編碼格式
wb = Workbook.getWorkbook(is, woSettings);
Sheet[] sheets = wb.getSheets();
int sheetLen = sheets.length;
for (int j = 0; j < sheetLen; j++) {
Sheet rs = wb.getSheet(j);
int rowNum = rs.getRows();
int colNum = rs.getColumns();
maps = new TreeMap<>();
for (int i = 2; i < rowNum; i++) {
Cell[] cell = rs.getRow(i);
if (cell[5].getContents() == null
|| cell[5].getContents().trim().equals("")) {
} else {
BeanValue beanValue = new BeanValue();
beanValue.setKey(cell[2].getContents());
beanValue.setValue(cell[5].getContents());
maps.put(i, beanValue);
}
}
if (maps.size() > 0) {
mapList.put(j, maps);
System.out.println(sheets[j].getName());
}
// list.add(maps);
}// for
}// if
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (null != wb) {
wb.close();
}
if (null != is) {
try {
is.close();
} catch (IOException e) {
}
}
}
return mapList;
}
/**
* 返回DocumentBuilder
* @return
*/
public static DocumentBuilder getDocumentBuilder() {
DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder dbBuilder = null;
try {
dbBuilder = dbFactory.newDocumentBuilder();
} catch (ParserConfigurationException e) {
e.printStackTrace();
}
return dbBuilder;
}
/**
* 將所讀excel的數(shù)據(jù)寫(xiě)入xml中，并按> mapList, List nameList) {
DocumentBuilder db = getDocumentBuilder();
Document document = null;
Iterator>> iteratorMap = mapList
.entrySet().iterator();
// int i = 0;
while (iteratorMap.hasNext()) {
Entry> entryMap = iteratorMap
.next();
int i = entryMap.getKey();
Map map = entryMap.getValue();
document = db.newDocument();
document.setXmlStandalone(true);
Element resource = document.createElement("resource");//創(chuàng)建元素節(jié)點(diǎn)
resource.setAttribute("xmlns:xliff",
"urn:oasis:names:tc:xliff:document:1.2");
document.appendChild(resource);//添加元素
Iterator> iterator = map.entrySet()
.iterator();
while (iterator.hasNext()) {
Entry entry = iterator.next();
BeanValue beanValue = entry.getValue();
String key = beanValue.getKey();
String value = beanValue.getValue();
if (value == null || value.trim().equals("")) {
} else {
Element string = document.createElement("string");
string.setAttribute("name", key);
string.appendChild(document.createTextNode(value));//添加值
resource.appendChild(string);//添加子元素
}
}// while
String nameStr = nameList.get(i);
String packStr = nameStr.substring(0, nameStr.lastIndexOf("/"));
String fileName = nameStr.substring(nameStr.lastIndexOf("/") + 1);
File file = new File("d://exceldoc/" + packStr);
if (!file.exists()) {
file.mkdirs();
}
saveXmlData(document,packStr,fileName);
}// while
}
private static void saveXmlData(Document document, String packStr,
String fileName) {
TransformerFactory tFactory = TransformerFactory.newInstance();
try {
Transformer tFTransformer = tFactory.newTransformer();
tFTransformer.setOutputProperty(OutputKeys.INDENT, "yes");
tFTransformer.transform(new DOMSource(document),
new StreamResult("d://exceldoc/" + packStr + "/"
+ fileName));
} catch (TransformerConfigurationException e) {
e.printStackTrace();
} catch (TransformerException e) {
e.printStackTrace();
}
}
}
提示：
1、需要引入的包：excel（jxl.jar）xml(dom4j-1.6.1.jar),excel解析poi-3.11-20141221.jar也可以；
2、讀取excel會(huì)出現(xiàn)亂碼問(wèn)題，可通過(guò)WorkbookSettings進(jìn)行編碼格式轉(zhuǎn)換；
3、以上demo針對(duì)本人讀取的excel表格測(cè)試是可以的，具體需要根據(jù)你excel中的內(nèi)容做相應(yīng)變更即可，
但大體解析流程是一樣的！
excel源數(shù)據(jù)表格：
保存為xml表格：
PS：這里再為大家提供幾款關(guān)于xml操作的在線(xiàn)工具供大家參考使用：
在線(xiàn)XML/JSON互相轉(zhuǎn)換工具：
http://tools.jb51.net/code/xmljson
在線(xiàn)格式化XML/在線(xiàn)壓縮XML：
http://tools.jb51.net/code/xmlformat
XML在線(xiàn)壓縮/格式化工具：
http://tools.jb51.net/code/xml_format_compress
XML代碼在線(xiàn)格式化美化工具：
http://tools.jb51.net/code/xmlcodeformat
更多關(guān)于Android相關(guān)內(nèi)容感興趣的讀者可查看本站專(zhuān)題：《Android操作XML數(shù)據(jù)技巧總結(jié)》、《Android編程之a(chǎn)ctivity操作技巧總結(jié)》、《Android資源操作技巧匯總》、《Android文件操作技巧匯總》、《Android開(kāi)發(fā)入門(mén)與進(jìn)階教程》、《Android視圖View技巧總結(jié)》及《Android控件用法總結(jié)》
希望本文所述對(duì)大家Android程序設(shè)計(jì)有所幫助。
