News of xlsx4j

Hi.

Since some weeks I trying to load, manipulate and save a xlsx file with docx4j.

In most cases, after saving to file and open it with MS Excel the Excel App says it is broken and needs to be fixed. After fixing the sheet looks like it should.

After trying lots of thing I can't fix the following issue:

...

final File file = excelPath.toFile();

SpreadsheetMLPackage loadedFile = SpreadsheetMLPackage.load(file);

final WorksheetPart sheet = ...

Hi,

I'm trying to work with this library, and add a checkbox from the java code. I tried to write something based on an example with a picture but I have no idea how add this object. I've used a page (http://webapp.docx4java.org/OnlineDemo/PartsList.html) that's supposed to help me in this but in drawing1.xml I got only <xdr:wsDr/>.

can You help me with this?

I am sorry that I did not ...

hi,jason.
I saw SpreadsheetMLPackage class source code,the method of 'load' support xml parameter,but invoke that,occur exception,infomation as follow:
org.docx4j.openpackaging.exceptions.Docx4JException: Unrecognised package
at org.docx4j.convert.in.FlatOpcXmlImporter.get(FlatOpcXmlImporter.java:186)
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:536)
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:387)
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:270)
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:250)
at org.docx4j.openpackaging.packages.SpreadsheetMLPackage.load(SpreadsheetMLPackage.java:104)
at com.icourt.common.utils.Xlsx4jUtil.loadOPCXml(Xlsx4jUtil.java:229)
at com.icourt.common.utils.Xlsx4jUtil.main(Xlsx4jUtil.java:251)

Exception in thread "main" org.docx4j.openpackaging.exceptions.Docx4JException: Couldn't load xml from stream
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:539)
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:387)
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:270)
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:250)
at org.docx4j.openpackaging.packages.SpreadsheetMLPackage.load(SpreadsheetMLPackage.java:104)
at com.icourt.common.utils.Xlsx4jUtil.loadOPCXml(Xlsx4jUtil.java:229)
at com.icourt.common.utils.Xlsx4jUtil.main(Xlsx4jUtil.java:251)
Caused by: org.docx4j.openpackaging.exceptions.Docx4JException: Unrecognised package
at org.docx4j.convert.in.FlatOpcXmlImporter.get(FlatOpcXmlImporter.java:186)
at org.docx4j.openpackaging.packages.OpcPackage.load(OpcPackage.java:536)
... 6 more

breakpoint Debugging,i ...

Hi!I see the github sourceCode about xlsx4j.I tried load SpreadsheetMLPackage with normal xlsx file inputstream.But,when i load SpreadsheetMLPackage with inputsteam who generated from Freemarker template,get some exception.The exception infomation as follows:
javax.xml.bind.UnmarshalException: 意外的元素 (uri:"urn:schemas-microsoft-com:office:spreadsheet", local:"Workbook")。所需元素为<{http://schemas.microsoft.com/office/2006/xmlPackage}package>,<{http://schemas.microsoft.com/office/2006/xmlPackage}xmlData>
at com.sun.xml.internal.bind.v2.runtime.unmarshaller.UnmarshallingContext.handleEvent(UnmarshallingContext.java:726)
at com.sun.xml.internal.bind.v2.runtime.unmarshaller.Loader.reportError(Loader.java:247)
at com.sun.xml.internal.bind.v2.runtime.unmarshaller.Loader.reportError(Loader.java:242)
at com.sun.xml.internal.bind.v2.runtime.unmarshaller.Loader.reportUnexpectedChildElement(Loader.java:109)
at com.sun.xml.internal.bind.v2.runtime.unmarshaller.UnmarshallingContext$DefaultRootLoader.childElement(UnmarshallingContext.java:1131)
at com.sun.xml.internal.bind.v2.runtime.unmarshaller.UnmarshallingContext._startElement(UnmarshallingContext.java:556)
at com.sun.xml.internal.bind.v2.runtime.unmarshaller.UnmarshallingContext.startElement(UnmarshallingContext.java:538)
at com.sun.xml.internal.bind.v2.runtime.unmarshaller.SAXConnector.startElement(SAXConnector.java:153)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:509)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:374)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl$NSContentDriver.scanRootElementHook(XMLNSDocumentScannerImpl.java:613)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3132)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:852)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:112)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:841)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:770)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213) ...

Hello,

sometimes my generated document starts with:

Code: Select all

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns2:worksheet xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:ns2="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing" xmlns:ns4="http://schemas.microsoft.com/office/excel/2006/main" xmlns:ns5="http://schemas.microsoft.com/office/excel/2008/2/main">
    <ns2:cols>

So there is a ns2 in every Element

But most of the time it starts like this:

Code: Select all

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing" xmlns:ns4="http://schemas.microsoft.com/office/excel/2006/main" xmlns:ns5="http://schemas.microsoft.com/office/excel/2008/2/main">
    <cols>

The ns2 seems to be the cause for the increased file-size in that matter.
When opening the files in Excel the content is the same. I don't see a ...

Hello everybody,

it is the first time that I use doc4j to generate an Excel file from another Excel file (pseudo template file) in changing some values in some fields.

I have found an example in https://github.com/plutext/docx4j/commit/9dc7f5c4e303cfea4ec5b11e5700584d388034c5 and I have made some minor changes.

The program run correctly without crashing but the generated Excel file doesn't contains new values.

In the input template Excel file, some cells contains the following strings

#{ctc.BRAND-NAME}
#{ctc.TIRE-SIZE}

The goal ...

Hello,

Can i generate charts using xlsx4j ? if that possible, any documentation to do that please ?

thanks.

Hi,

May I know isn't possible to set auto- cell width / set particular width through xlsx4j?
For example :

<cols>
<col min="1" max="1" width="16.7109375" customWidth="1"/>
<col min="2" max="2" width="10.85546875" bestFit="1" customWidth="1"/>
</cols>

Appreciate your input / provide sample code.
Thanks a lot

I need to create an Excel file in which some cells will content HTML data format as follows:

<p><strong>​test1</strong></p><p><br></p><p><em>test2</em></p><p><br></p><p><u>test3</u></p><p><br></p><p><font size="2">test4</font></p><p><br></p><p><font color="#ff0000">test5</font></p><p><br></p><p><font style="background-color: rgb(255, 102, 0);">test6</font></p><p><br></p><p align="left">test7</p><p align="left"><br></p><ol><li><div align="left">test 8</div></li></ol><p><br></p><p><br></p><p><br></p>

The generated excel file still displays HTML tags and not the formatted content in HTML.

Any ideas ?

Thanks !

I need to create an Excel file with html table using doc4j. I have previously use this but for create Word Document. I can't find a good example for creating a excel out of a html table... Any ideas please?