News of xlsx4j

Hi Jason,

I have an Excel document containing forms. I am required to populate the first worksheet with data and the other worksheets would have values taking reference from the first worksheet.

I am taking reference from the following sample code:

https://github.com/plutext/docx4j/blob/master/src/samples/xlsx4j/org/xlsx4j/samples/VariableReplace.java

and

http://www.docx4java.org/forums/xlsx-java-f15/replace-variables-in-xlsx-t2080.html

I managed to write the value to the first worksheet. However these values are not reflected in the other worksheets. It is only updated if i click the cell.

Any advice ...

I want to preserve a themespart that is derived as a result of converting content from .docx file to .xlsx.
However, there is no support in org.docx4j.openpackaging.parts.relationships.Namespaces.java to add a themepart in xlsx package.
the theme partname is /xl/themes/theme1.xml
What is the best way out here without changing the core module?

Hello everyone,

I have tried to import several .xls files with the SpreadsheetMLPackage.load(File file) methods. So far, I don't have any problems with .xlsx files and some .xls but for the majority of the .xls files, I have the same error :

private SpreadsheetMLPackage openXlsxXslx4J() throws FileNotFoundException, Docx4JException {
SpreadsheetMLPackage pkg = null;
if(pathFile!=null && !pathFile.isEmpty()){
File file = new File(pathFile);
if(file!=null){
pkg = SpreadsheetMLPackage.load(file);
}
}
return pkg;
}

org.docx4j.openpackaging.exceptions.Docx4JException: Problem reading compound file ...

I need a little example, how can I set a string value in a cell ? (numbers are OK)
I found in forum this topic: "http://www.docx4java.org/forums/xlsx-java-f15/cells-with-character-values-t874.html" but it can't to compile.
i.ex "crt.setT(value);" but what's the "value" ???
Can somebody send me a complete example please ?
L dot hunyady at gmail dot com
Thank you !
Laszlo Hunyady

I am new in docx4j xlsx; How can I add more than one rows to a Sheet ?
My code makes only one row (the last one):

Row row = Context.getsmlObjectFactory().createRow();
row.setHt(66.0);
row.setCustomHeight(Boolean.TRUE);
row.setR(1L);
Cell cell1 = Context.getsmlObjectFactory().createCell();
cell1.setV("1234");
row.getC().add(cell1);
Cell cell2 = Context.getsmlObjectFactory().createCell();
cell2.setV("56");
row.getC().add(cell2);

Row row2 = Context.getsmlObjectFactory().createRow();
row2.setHt(33.0);
row2.setCustomHeight(Boolean.TRUE);
row2.setR(1L);
cell1 = Context.getsmlObjectFactory().createCell();
cell1.setV("5678");
row2.getC().add(cell1);
cell2 = Context.getsmlObjectFactory().createCell();
cell2.setV("910");
row2.getC().add(cell2);

sheetData.getRow().add(row);
sheetData.getRow().add(row2);

thank's
Laszlo Hunyady

Hello, I need to create a XLSX file to retrieve data from a query, this is possible to do with docx4j?
Regards.
Gustavo

I'm using docx4j.NET. When I try to convert xlsx to pdf, an exception occurs. Exception message: "Docx4JException: Invalid document package in the settings, it isn't a WordprocessingMLPackage"

Does docx4j only support converting docx to pdf?
Thanks

Here is my code

....
string fileIN = projectDir + @"src\samples\resources\sample-xlsx.xlsx";
string fileOUT = projectDir + @"OUT_sample-xlsx.pdf";
....
SpreadsheetMLPackage excelMLPackage = SpreadsheetMLPackage
.load(new java.io.File(fileIN));
org.docx4j.events.StartEvent startEvent = new org.docx4j.events.StartEvent(excelMLPackage, org.docx4j.events.WellKnownProcessSteps.PDF);
startEvent.publish();

org.docx4j.convert.@out.FOSettings settings = new org.docx4j.convert.@out.FOSettings();
settings.setWmlPackage(excelMLPackage);
settings.setApacheFopMime("application/pdf"); ...

Hi,

I'm trying (in Java) to create a Excel file (.xlsm) with personnals macro in VBA.
The macros must be generated by Java code.
Is this possible ?
Apache POI (HSSF and XSSF) has limiMacros

Macros can not be created. The are currently no plans to support macros. However, reading and re-writing files containing macros will safely preserve the macros.y preserve the macros.

We can add a macro in a package for a dotx ( ...

Hello,

I would like to manipulate metadata attached to a cell with xlsx4j. From what I understand, I can use the setCm() method to link my cell to the correct metadata. Furthermore, I know I can create a metadata with this line :
CTMetadata md = Context.getsmlObjectFactory().createCTMetadata();

Unfortunately, I don't know where this should be added.

Also, is there a way to create the metadata xml file like the styles part ? ==> Styles styles ...

Hello,

I know we can convert the docx to FO file and then use the FOP to convert that FO file to a PDF file. Likewise Is there a way to convert an XLSX to PDF document ?

I already looked into the below example which will convert the xls(windows 2003 ) to pdf but i need to know is there a way to convert the xlsx to an FO converter ?
...