Examples with Cell net.heartsome.cat.converter.msexcel2007.document.Cell used on opensource projects

Example 1 with Cell

use of net.heartsome.cat.converter.msexcel2007.document.Cell in project translationstudio8 by heartsome.

the class XliffReader method readSheet.

private void readSheet(List<SheetPart> sheetList, IProgressMonitor monitor) throws InternalFileException {
    if (monitor == null) {
        monitor = new NullProgressMonitor();
    }
    monitor.beginTask(Messages.getString("msexcel.xliff2mse.task4"), sheetList.size() * 5);
    List<String> sheetNames = new ArrayList<String>();
    for (SheetPart sp : sheetList) {
        monitor.worked(1);
        String name = sp.getName();
        name = processContent(name);
        // 处理重复名称
        int i = 1;
        while (sheetNames.contains(name)) {
            name += i;
            i++;
        }
        sheetNames.add(name);
        sp.setSheetName(name);
        // read headers
        monitor.worked(1);
        List<HeaderFooter> headers = sp.getHeader();
        for (HeaderFooter hf : headers) {
            String content = hf.getContent();
            content = processContent(content);
            hf.setContent(content);
        }
        // update the file
        sp.setHeaderFooter(headers);
        monitor.worked(1);
        DrawingsPart drawingp = sp.getDrawingsPart();
        if (drawingp != null) {
            List<CellAnchor> aList = drawingp.getCellAnchorList();
            for (CellAnchor a : aList) {
                List<ShapeTxBody> sList = a.getShapeList();
                if (sList.size() == 0) {
                    continue;
                }
                for (ShapeTxBody s : sList) {
                    List<ShapeParagraph> pList = s.getTxBodyParagraghList();
                    for (ShapeParagraph p : pList) {
                        String content = p.getXmlContent();
                        content = processContent(content);
                        p.setXmlContent(content);
                    }
                }
            }
            drawingp.updateDrawingObject();
        }
        monitor.worked(1);
        List<Cell> cellList = sp.getCells("s");
        for (Cell c : cellList) {
            String content = c.getFullContent();
            content = processContent(content);
            c.setShareStringItemFullContent(content);
        }
        monitor.worked(1);
        // read footer
        List<HeaderFooter> footers = sp.getFoolter();
        for (HeaderFooter hf : footers) {
            String content = hf.getContent();
            content = processContent(content);
            hf.setContent(content);
        }
        // update the file
        sp.setHeaderFooter(footers);
    }
    monitor.done();
}

Example 2 with Cell

use of net.heartsome.cat.converter.msexcel2007.document.Cell in project translationstudio8 by heartsome.

the class SpreadsheetReader method readSheets.

private void readSheets(List<SheetPart> sheetList, IProgressMonitor monitor) throws InternalFileException, IOException {
    if (monitor == null) {
        monitor = new NullProgressMonitor();
    }
    monitor.beginTask("", sheetList.size() * 5);
    for (SheetPart sp : sheetList) {
        // process sheet name
        String name = sp.getName();
        writeXliffFile(xliffIdex, name);
        sp.setSheetName("%%%" + xliffIdex + "%%%");
        xliffIdex++;
        monitor.worked(1);
        // read headers
        List<HeaderFooter> headers = sp.getHeader();
        readHeaderFooters(headers);
        // update the file
        sp.setHeaderFooter(headers);
        monitor.worked(1);
        // read drawing part
        DrawingsPart drawingp = sp.getDrawingsPart();
        if (drawingp != null) {
            readDrawings(drawingp);
            drawingp.updateDrawingObject();
        }
        monitor.worked(1);
        List<Cell> cellList = sp.getCells("s");
        for (Cell c : cellList) {
            if (filterStyleIndex.contains(c.getStyleIndex())) {
                // skip this cell
                continue;
            }
            String cellText = c.getValue();
            if (cellText == null || cellText.trim().length() == 0) {
                // ignore the cell
                continue;
            }
            List<Object[]> cellStyle = c.getCellCharacterStyles();
            String[] segs = segmenter.segment(cellText);
            StringBuffer bf = new StringBuffer();
            for (String seg : segs) {
                List<Object[]> s = ReaderUtil.getSegStyle(cellStyle, seg, cellText);
                if (s.size() != 0) {
                    seg = ReaderUtil.appendSegStyle(seg, s);
                }
                bf.append("%%%").append(xliffIdex++).append("%%%");
                // System.out.println(xliffIdex + ":" + seg);
                writeXliffFile(xliffIdex - 1, seg);
            }
            c.setValue(bf.toString());
        }
        monitor.worked(1);
        // read headers
        List<HeaderFooter> footers = sp.getFoolter();
        readHeaderFooters(footers);
        // update the file
        sp.setHeaderFooter(footers);
        monitor.worked(1);
    }
    monitor.done();
}