News of Plutext

Hi All,

I'm trying to parse XSLS file where the B15 cell is DATE and the value is 2015/03/23.

The /xl/worksheets/sheet1.xml file represents it as:

Code: Select all: <ns2:row r="15" spans="1:5"> <ns2:c r="B15" s="31"> <ns2:v>40624</ns2:v> </ns2:c> </ns2:row>

How to convert "40624" value to "2015/03/23"?

Thank you in advance
Alex

I am trying to convert html string to docx using the below code as per
https://github.com/plutext/docx4j-Impor ... dBack.java

I added the following libraries other than the ones used in Android docx to HTML by docx4j project on github:
1. docx4j-importXHTML-3.2.2.jar
2. itext-2.1.7.jar
3. xml-renderer-3.0.0.jar
4. xalan-2.7.0.jar

The following is the android version of code in XhtmlToDocxAndBack.java :
try {
String html = "<html><head><title>Import me</title></head><body><p>Hello World!</p></body></html>";

WordprocessingMLPackage wordMLPackage = ...

Hi,
I'm running a multithreaded application in which each thread is a heavy docx4j user.
Profiling the application, I'm noticing some contention around XmlUtils.getNewDocumentBuilder() which is blocking the static instance of DocumentBuilderFactory.

From what I understand from https://jaxp.java.net/docs/spec/html/#p ... ead-safety, the DocumentBuilderFactory.newDocumentBuilder() method should be threadsafe.

It is expected that the newSAXParser method of a SAXParserFactory implementation, the newDocumentBuilder method of a DocumentBuilderFactory and the newTransformer method of a ...

Hi,

I'm pretty new to Word documents and PDF. More especially I just started experimenting with docx4j. I tried converting a docx into pdf (no manipulation in between) using the ConvertOutPDF-example.
On runtime I get the error

Code: Select all: org.docx4j.openpackaging.exceptions.Docx4JException: Exception exporting package; FOP https://issues.apache.org/bugzilla/show_bug.cgi?id=54094 .. try PP_APACHEFOP_DISABLE_PAGEBREAK_LIST_ITEM

... but where to set this property?

I tried creating a HashSet "features" and called

Code: Select all: wordMLPackage = Preprocess.process(wordMLPackage, features);

but nothing changed. I have no clue where to try ...

hi all

I'm trying to add row in table.

i did add table.

but i want to add row not table.

thanks!

org.docx4j.wml.Document wmlDocumentEl = (org.docx4j.wml.Document) wordMLPackage
.getMainDocumentPart().getJaxbElement();
Body body = wmlDocumentEl.getBody();
ObjectFactory factory = Context.getWmlObjectFactory();
if (exportListItem != null) {
List<Object> tables1 = getAllElementFromObject(
wordMLPackage.getMainDocumentPart(), Tbl.class);
if (tables1 != null) {
Tbl sourceTbl = (Tbl) tables1.get(0);
Tbl newTbl = (Tbl) XmlUtils.deepCopy(sourceTbl);
//body.getContent().remove(sourceTbl.getParent());
for (int i = 0; i < exportListItem.size(); i++) {
body.getContent().add(newTbl); ...

Hi,

If a run doesn't have a font set, PowerPoint goes up the hierarchy and find the correct font based on the character, language, paragraph, theme...
How can I set the font of all runs in a PPTX presentation implicitly?
In other words, I'm trying to set the find the font that will be used to display the run and set it in the XML so tools that don't have the font selection logic will ...

Hi,
At the risk of asking a naive question:
Is it possible to get docx4j to run with Woodstox as its stax implementation?
Thanks.

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; ...

News of Plutext

Site map of Plutext » Forum : Plutext

How to retrieve Date from xslx file

Android HTML to docx error

XmlUtils.getNewDocumentBuilder() blocking on factory

Setting "PP_APACHEFOP_DISABLE_PAGEBREAK_LIST_ITEM"

how to add new row?

Normalize fonts in PPTX

woodstox stax

How to read formula string from excel?

Deleting rows using xlsx4j (which has formulas)

How to get the Cols?

Last 10 active topics

Login • Register

Statistics