News of xlsx4j

Hello. I am new in docx4j and openxml. I have a necessity to create the excel file which is contain N separate tables (existing template) with pre-created charts according these tables. Actually, I need to replace some text placeholders with the values from database and show to the user completely generated Excel document.
I checked the sample with replacing values, it is working for me after obtaining the latest patch in the source code. Unfortunately, ...

Hello,

I'm trying to create an xlsx spreadsheet with various cell styles (bold, bordered, etc.) For that I'm creating a styles.xml Part:

Code: Select all

WorksheetPart sheet = xlsUtils.createWorkSheet(pkg);         
Styles styles = new Styles(new PartName("/xl/styles.xml"));
styles.setJaxbElement(sb.createStyleSheet());

where sb is a StyleSheetBuilder class that looks like this:

package xlsx;

import javax.xml.bind.JAXBElement;

import org.xlsx4j.sml.CTBooleanProperty;
import org.xlsx4j.sml.CTBorder;
import org.xlsx4j.sml.CTBorderPr;
import org.xlsx4j.sml.CTBorders;
import org.xlsx4j.sml.CTCellStyle;
import org.xlsx4j.sml.CTCellStyleXfs;
import org.xlsx4j.sml.CTCellStyles;
import org.xlsx4j.sml.CTCellXfs;
import org.xlsx4j.sml.CTColor;
import org.xlsx4j.sml.CTDxfs;
import org.xlsx4j.sml.CTExtension;
import org.xlsx4j.sml.CTExtensionList;
import org.xlsx4j.sml.CTFill;
import org.xlsx4j.sml.CTFills; ...

I need help in adding border to a cell, or styling a cell, any examples?

I retrieve a Cell at some given row and given column , I want to find the style or format this cell , please advice how to?

How to wrap text in cells,and vertical align top?.
Number cell hiding leading 0 (zero), I am creating excel with ssn as number cell , but the generated excel is removing the leading zero, please advice how to tell excel not to hide the leading zero from number cell?

Hi everyone!

First of all: Thanks for DOCX4J! It's really a cool project! :)

We're processing XLSX documents using DOCX4J and ran into one and a half problems. We got one document from our customer that can't be opened with DOCX4J but it can be opened with Excel. The reason seems to be that there are some Relationships that have a Target attribute with value NULL. I ...

Hello,
i use a excel file as a template for a dataexport. Is there a way to read tge ecisting Stylesheed an modify it bevor i write the file back?

Thanx

I am filing place holders with values in my excel, I know the row and column which have placeholders which I replace with actual values, the generated excel has green triangle in most of the cells, Please advice what more should I set on the cell so that the the green triangle will not appear.

Is ist posiple to enable al the gridlines in a cell?
And how can I enable wordwrap ore set the alignement to center?

Thanx in advance.

Hi,

Actually, I'm trying to include Docx4j in a Struts project. When I just use Docx4j in JEE with its Servlet and JSP, everything works correctly, but then when I try with Struts 1.x Framework, I get so many fails because of this:

"ERROR Digester.getParser:
javax.xml.parsers.ParserConfigurationException: AElfred parser is non-validating"

Can you suggest me anything? I've to check more Docs here, but I'm spending a long while whit it.

Thank you in advance!

Has anyone an example for me?

Regads Dieter