com.google.gdt.handler.impl.ExcelxHandler.java Source code

Introduction

Here is the source code for com.google.gdt.handler.impl.ExcelxHandler.java

Source

/*
 * ExcelxHandler.java
 *
 * Copyright (C) 2011,  Sanmoy Ray
 * 
 * This file is part of google-document-translator.
 *
 * Google Document Translator is not a product from Google. Neither it is endorsed nor it is supported by Google.
 * This is an open source and free software. you can redistribute it and/or modify it under the terms of the
 * GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License,
 * or(at your option) any later version.
 * 
 * Google Document Translator is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; 
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 * 
 * You should have received a copy of the GNU Lesser General Public License
 * along with Google Document Translator.  If not, see <http://www.gnu.org/licenses/>.
 */

package com.google.gdt.handler.impl;

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.util.zip.ZipEntry;
import java.util.zip.ZipInputStream;
import java.util.zip.ZipOutputStream;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Node;
import org.dom4j.io.SAXReader;
import org.jaxen.JaxenException;
import org.jaxen.SimpleNamespaceContext;
import org.jaxen.XPath;
import org.jaxen.dom4j.Dom4jXPath;

import com.google.gdt.handler.DocumentHandler;
import com.google.gdt.ui.ProgressLevel;
import com.google.gdt.util.TranslatorType;

/**
 * 
 * @author Sanmoy
 *
 */
public class ExcelxHandler extends DocumentHandler {

    private static Logger logger = Logger.getLogger("ExcelxHandler.class");

    private final int BUFFER = 2048;

    /**
     * 
     * @param inputFile
     * @throws IOException
     * @throws InvalidFormatException
     */
    @Override
    public void handle(String inputFile, ProgressLevel pLevel) throws IOException, InvalidFormatException {
        String outPutFile = getOuputFileName(inputFile);
        ZipInputStream zis = new ZipInputStream(new FileInputStream(inputFile));
        ZipOutputStream zout = new ZipOutputStream(new FileOutputStream(outPutFile));
        ZipEntry zipEntry;
        int wordCount = 0;
        int pBarUpdate = 0;
        while ((zipEntry = zis.getNextEntry()) != null) {
            if (zipEntry.getName().equals("xl/sharedStrings.xml")) {
                ByteArrayOutputStream baos = new ByteArrayOutputStream();
                byte[] buffer = new byte[BUFFER];
                int len;
                while ((len = zis.read(buffer)) > 0) {
                    baos.write(buffer, 0, len);
                }
                baos.flush();

                InputStream clone = new ByteArrayInputStream(baos.toByteArray());
                SAXReader saxReader = new SAXReader();
                Document doc = null;
                Map<String, String> nameSpaceMap = new HashMap<String, String>();
                nameSpaceMap.put("xmlns", "http://schemas.openxmlformats.org/spreadsheetml/2006/main");
                try {
                    XPath xPath = new Dom4jXPath("//xmlns:t");
                    xPath.setNamespaceContext(new SimpleNamespaceContext(nameSpaceMap));
                    doc = saxReader.read(clone);
                    List<Node> nodes = xPath.selectNodes(doc);
                    wordCount = nodes.size();
                    pLevel.setValue(0);
                    pLevel.setMaxValue(wordCount);
                    pLevel.setStringPainted(true);
                    pLevel.setTrFileName(outPutFile);
                    pBarUpdate = 0;
                    for (Node node : nodes) {
                        pBarUpdate++;
                        pLevel.setValue(pBarUpdate);
                        if (isInterrupted) {
                            zis.close();
                            zout.close();
                            new File(outPutFile).delete();
                            pLevel.setString("cancelled");
                            return;
                        }
                        String inputText = "";
                        try {
                            inputText = node.getText();
                            String translatedTxt = inputText;
                            translatedTxt = translator.translate(inputText);
                            node.setText(translatedTxt);
                        } catch (Exception e) {
                            logger.log(Level.SEVERE, "Translation fails for the inputText : " + inputText, e);
                        }
                    }
                } catch (DocumentException e) {
                    logger.log(Level.SEVERE, "cannot parse slide", e);
                } catch (JaxenException e) {
                    e.printStackTrace();
                }

                zout.putNextEntry(new ZipEntry(zipEntry.getName()));
                byte data[] = doc.asXML().getBytes("UTF8");
                zout.write(data, 0, data.length);
            } else {
                zout.putNextEntry(new ZipEntry(zipEntry.getName()));
                int len;
                byte data[] = new byte[BUFFER];
                while ((len = zis.read(data, 0, BUFFER)) != -1) {
                    zout.write(data, 0, len);
                }
            }
        }
        zis.close();
        zout.close();
        pLevel.setValue(wordCount);
        pLevel.setString("done");
    }

}