News of xlsx4j

Hello Jason,

in my team we are already using pptx4j for creating slides.

Therefore I'd like very much to use xlsx4j for our XLS-Reports.


I am having trouble adding a picture, tough. I saw the thread in 'Adding images to XLS' in this same forum, but there is code missing.
Could you provide some short cookbook ("you need a Drawing, of course a spreadsheet and a..") or code snippets to get me and maybe others ...

Hello everyone

This problem is driving me crazy. I am trying to create a small xlsx-file. Inserting data works just fine, but when I try to format a cell, I get an error when I open the created xlsx-file afterwards. There has to be something wrong with the styles.xml. Below you will find the code.

Can somebody help me out?


public class XlsxCreator {

private static Worksheet sheetfinal;
private static WorksheetPart sheet;
private static ...

Hey folks,

I'm pretty new to this. I created my first Excel document without difficulty. However, I'd like to add a chart to the spreadsheet, and that's considerably more difficult. Can someone show me a straightforward example of how to go about adding a chart? Even an overview.

I've created my package, a sheet, some rows, and some cells. I add the cells to the rows, the rows to the sheet, and the sheet to ...

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, the OpcPackage.load() call fails with the error below. If I remove the form button from the file, I can load and stream the file just ...

HI,

I was looking for exporting the Excel file to the PDF using the Docx4j but i found there is no XSLT Template created for the Excel xml to the FOP XML for PDF Creationg ,if anybody attempted in doing so please let us know share with us.We are in process of making excel to pdf conversion using the open source solutions like FOP|POI| or and DOCx4j.
I See this Functionality is not supported via ...

I am building an export process for a client using xlsx4j, and am using a template xlsx file to generate the export.

I am able to save the exported spreadsheet with all template variables replaced, and have been able to duplicate individual worksheets in the document using the XmlUtils.deepCopy() method.

I would like to duplicate the entire SpreadsheetMLPackage object in memory. I need to generate multiple spreadsheet files and would rather generate them from an ...

I'm hoping someone here can help as I'm making absolutely no progress with this. I'm simply trying to set the background fill color of a cell. I've looked at some of the relevant posts here, read the related part of the Open XML spec, and have looked at the contents of an xlsx file I created manually but it's not clear to me what steps I need to take to do this programmatically. I haven't ...

I tried to change the default row height of my spread sheet, but for some reason I can't get it to work. I must be missing something, but I don't know what.

I've tried setting the default height, and I've tried setting the height of the rows itself, as that was what I saw in the xml of the file I made by hand, but neither seems to have any effect.


SpreadsheetMLPackage pkg = ...

Hi, one question:

On description, we can read:

Specific to docx4j (as opposed to pptx4j, xlsx4j):

• Template substitution; CustomXML binding

but, my question is: Is there any form to get the xml "SharedString" on String and revert again?

thx 4 all.

Today I tried to add a background fill to my rows. In order to keep my code simple, I wanted to do this without using theme colors. So I tried the setRgb method on CTColor when creating a fill for my stylesheet. But for some reason, it ignored this color. No matter what color I used, it came out as a shade of grey.

Here's the code I tried:

CTFill blueFill = new CTFill(); ...