News of xlsx4j

I notice in both Word2007/2010 output (when viewed as xml) and the Open Office XML Primer (Open Office XML Part 3 - Primer, section 3.3.10) that the

Code: Select all

<t>

tag in the shared strings table can have the attribute

Code: Select all

xml:space="preserve"

set on it.

Is it possible to set this attribute using docx4j?

If not, can you suggest any workaround I could use to enable me to set it, as I would find it very useful for ...

Hi to all,

i would like to know if Docx4j is able to generate pivot table from a data source (for example, another Excel Tab).

If it is possible, could you give me a link for documentation about creating XLSX with docx4j ?

Many thanks to all.

Hello,

I have been trying for a while to add comments to my xslx file generated using xslx4j.
Comments.xml is getting adde to package with the right content but somehow comments are not shown in xslx.
Im using docx4j 2.8.1

Here is my code :

final WorksheetPart worksheet =
pkg.createWorksheetPart( new PartName( "/xl/worksheets/sheet1.xml" ),
"Sheet1", 1 );
final CommentsPart commentsPart = new CommentsPart();
CTComments comments = Context.getsmlObjectFactory().createCTComments();
CTCommentList commentlist = Context.getsmlObjectFactory().createCTCommentList();
commentlist.getComment().add(createComment());
comments.setCommentList(commentlist);
commentsPart.setJaxbElement( comments ...

I have a web app that needs to:
- load an xlsm file created in Office 2010 that contains macros
- update some data on one worksheet
- stream the file back to the user

If the xlsm file contains a form button created from the developer menu in Excel, it gives the following error while opening and the buttons are stripped out:

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error059600_01.xml</logFileName><summary>Errors were detected in file 'C:\Project\Queries\4532.xlsm'</summary>-<repairedParts summary="Following ...

Hi,
I am new to this forum and the usage of this app. I have attached a sample xlsx file and I am trying to create a xlsx in similar format (row grouping, collapse/expand etc). I used POI XSSFWorkbook, but the memory footprint is high for the real doc creation and I tried to use POI SXSSFWorkbook, but that throws an runtime exception as "not implemented" when we call "sheet.setRowGroupCollapsed(..): method.

sheet.groupRow(1, 9);
sheet.setRowGroupCollapsed(1, true); ...

Hi,

I'm trying to read an existing XLSX file and get the values from a given sheet (e.g. 'Sheet2') and a given range (e.g. "C4:C8", or "C4:F4"). For the moment I'm assuming the range includes cells in either a single row or a single column.

I can read the file and get the sheet, but I'm not sure what is the best way to find the cells for the given range.

One way would be ...

Hello Jason!

On another post in this forum you answered a question with this cite:

"..Or you could go from XLSX to a docx table, and use what is in docx4j already to convert that to a PDF. "


I would very much like to convert my XLSX (everything working there with xlsx4j) into:

1. docx
2. PDF

like you said.
I just need the conversion from XLSX (e. g. a SpreadsheetMLPackage) to docx (WordprocessingMLPackage); ...

Hello Jason and all,

do I have to take sth. special in consideration when applying fonts like this:


// Font for data cell row has font index = 3
CTFont fontDataRow = new CTFont();

CTFontSize fdrSize = new CTFontSize();
fdrSize.setVal( planFormat.getFontSizeGroups() );
JAXBElement<CTFontSize> element19 = smlObjectFactory.createCTFontSz( fdrSize );
fontDataRow.getNameOrCharsetOrFamily().add( element19 );

CTColor fdrColor = new CTColor();
fdrColor.setTheme( 1L );
JAXBElement<CTColor> element20 = smlObjectFactory.createCTFontColor( fdrColor );
fontDataRow.getNameOrCharsetOrFamily().add( element20 );

CTFontName fdrFontName = new CTFontName();
fdrFontName.setVal( ...

I am a beginner of docx4j and I need to protect a generated excel file(xlsx). I have read the article about password protection for docx (i.e. http://www.docx4java.org/forums/docx-java-f6/using-ctdocprotect-to-protect-a-word-file-t947.html?hilit=password&sid=2ced230863e1d4f59153790c09a7afe7&sid=2ced230863e1d4f59153790c09a7afe7#p3128) but I still have no idea on it. So, I'd appreciate some guidance.

Hello all. I have some problem with the autoFilter function. It seems to me that the generated XML code is not complete, and makes Excel crash.

Here is how I specify the filter:

Code: Select all

CTAutoFilter filter = new CTAutoFilter();
filter.setRef("A8:L8");
worksheet.setAutoFilter(filter);

When I open the .docx file in Excel (2010), I see the filter marks. But if I try to sort ascending or descending, Excel crashes.

If I manually remove the filter, then recreate it on ...