Android开发实现读取excel数据并保存为xml的方法

作者：袖梨 2022-06-25

本文实例讲述了Android开发实现读取excel数据并保存为xml的方法。分享给大家供大家参考，具体如下：

前阵子，公司请外面人翻译了一些android中values中的一些strings，然而保存的都是excel格式，如果单纯的将excel中的数据粘贴到指定的xml中的话，工作量非常的大，于是，自己写了个简单的demo，将excel中的数据读取并保存为xml对应的数据，下面的demo和图片展示：

1、数据保存在BeanValue中,包括key和value，方便后续数据读取

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、数据解析，包括测试，直接在main方法中进行

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  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 ,保持单张表中第三行开始，第2列和第5列的值（TreeMap可以按顺序加载）
   * 返回Map>，保证Integer和表的索引一一对应
   * 也可保持为List>
   * @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");//设置编码格式
        wb = Workbook.getWorkbook(is, woSettings);
        Sheet[] sheets = wb.getSheets();
        int sheetLen = sheets.length;
        for (int j = 0; j ();
          for (int i = 2; i  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的数据写入xml中，并按格式保存
   * @param mapList
   * @param nameList
   */
  private static void writeXmlFile(
      Map> 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");//创建元素节点
      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();
    }
  }
}