News of Forums

Hello

I am using the following code and its returning empty string.

Code: Select all


    spread = SpreadsheetMLPackage.load(new File(mainFile));
     WorksheetPart sheetpart = (WorksheetPart) spread.getParts().get(new PartName("/xl/worksheets/sheet1.xml"));
    List<Row> rows = sheetpart.getContents().getSheetData().getRow();
    r = rows.get(i);
     for (Cell cr : r.getC())
     {
        if (cr.getF() != null)
        {
         System.out.println(cr.getF().getValue());
        }
       }


Its is returning empty string.

When I write the whole pakage using

Code: Select all

spread.save(new File(output));


All the formulas are retained.

Is this not the correct place to look for ...

Hello

I am trying to delete rows from an excel file using this code

Code: Select all

if (centerList.contains(center))
                   {
                  calculationList.add(new Long(r.getR()));
                  rows.remove(r);
                  i--;
                  total_rows--;
                  old_R--;
                  removal = true;
                  centerList.remove(center);
               }

by rows.remove(r) line.

But this only clears the row.
So I also have to move the cells to one row above after remove, which I do by this.

for (Cell cr : r.getC())
{
String str = cr.getR();
str = str.replaceAll("[0-9]+", new Long(old_R+1).toString());
cr.setR(str);
}
r.setR(old_R+1); ...

Hi!

I'm trying to get the cols from the WorksheetPart but i just can't. It always returns a empty list. Do I need also to create the cols and then associate it to the rows (if yes, how?) or i can just add the cells to the rows and then the sheet will understand that there are news cols on the list?

I'm using the example code with the row.getC().add(createCell("hello world!")); inside a for(int i=0; ...

Hi All,
I am quite new to docx4j.

I have been in trouble :cry:

I made docx template file and setted xpath using "Word 2007 Content Control Toolkit" and generated xml file.

but I leand that I should not using toolkit. instead I leand I should use OpenDoPE.

this link give me little hint. I don't understand well. (http://www.docx4java.org/forums/data-binding-java-f16/need-help-in-repeated-binding-t827.html)



anyway,

how can i generate ...

Hello,
I started learning docx4java several days ago.
It is so interesting to me but I don't know well how to divide one docx file to several files.

My point is
total.docx has 5 pages and I'd like to divide this file into 5 files such as belows.

part1.docx(page 1), part2.docx(page 2), part3.docx(page 3), part4.docx(page 4), part5.docx(page 5).

Please let me know if you have any ideas.
Thank you in advance.

I just started to upgrade to 3.2.2 and I noticed that we had a patch that we had to bring back, so might as well bring this to your attention. With the code as is I am getting the following exception:

Caused by: org.docx4j.openpackaging.exceptions.Docx4JException: Exception executing transformer: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 40; Content is not allowed in prolog.
at org.docx4j.convert.out.fo.renderers.FORendererApacheFOP.render(FORendererApacheFOP.java:215)
at org.docx4j.convert.out.fo.renderers.FORendererApacheFOP.render(FORendererApacheFOP.java:158)
at org.docx4j.convert.out.fo.AbstractFOExporter.postprocess(AbstractFOExporter.java:140)
at org.docx4j.convert.out.fo.AbstractFOExporter.postprocess(AbstractFOExporter.java:1)
at org.docx4j.convert.out.common.AbstractExporter.export(AbstractExporter.java:82)
... 5 more
Caused by: javax.xml.transform.TransformerException: org.xml.sax.SAXParseException; ...

Hi,

Background: We are investigating wether we can use Docx4j in our reporting chain. One of the requirements would be a GUI authoring tool and nested repeats.
When experimenting with the Authoring tool, I've been running into a few issues. Notably around repeats.
Word version: 15.0.4724.1003 | Windows 7 latest SP

1. Consistently repeatable: At a certain point in the XML, we can no longer drag the nodes into the word file. Every XML leaf ...

HI
I have used Table of contents code to genrate table of contents in word document.But while opening document it was showing one popup saying "This document contains many fields that may refer to other fies.Do you want to update the fields." Our customer doesnt want this popup. could you please help me on getrid of this.

I’m using docx4j 3.2.1, so I can change table cell background color ?

Hey guys I'm a newbie using docx4j and xml so I was wondering about how to extract text from a .docx document to a java text area.
I mean I can load it with the file chooser but then I don't know how to extract the paragraphs of text.
Note>It's text only, no images, no special styles, no tables
Proof of what I'm saying is true and am not lazy just really need your help ...