Leo | 2 Nov 21:19 2011
Picon

jXLS 1.0-RC-3 released

Hi all,

I  would  like to announce the availability of jXLS 1.0-RC-3.

The    distribution   files  can   be   found   at   sourceforge  site
(https://jxls.sf.net) and should be available at central Maven repo soon.

This  release  features significant performance improvements
(up  to  5  times  comparing  to 1.0-RC-2) thanks to contribution from
Curtis Stanford.

--

-- 
Best regards,
 Leo

------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
Max Pendyschtschuk | 30 Oct 17:18 2011
Picon

jxls: iterating over array?

Hello,

is here any way to iterate an array? My bean just has int[] variable and I want to write its values. I can't use forEach tag, cause it works only with collections. Also I don't see any tag for simple iteration (say from 1 to n) which would also help (then I can use jexl to access array element by its index. Should I write my own tag for it, or something is missed by me?

thank you,
Max
------------------------------------------------------------------------------
Get your Android app more play: Bring it to the BlackBerry PlayBook 
in minutes. BlackBerry App World™ now supports Android™ Apps 
for the BlackBerry® PlayBook™. Discover just how easy and simple 
it is! http://p.sf.net/sfu/android-dev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
Deina | 28 Oct 14:50 2011
Picon

Jxls template

Hi,

Is it ok to share the same template file between multiple threads when trying to generate an excel?
I am receiving this error when trying to generate multiples excel files from different threads using the same template file :

org.xml.sax.SAXException: FWK005 parse may not be called while parsing.
    at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
    at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)

Can anyone help me to solve this issue?
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning <at> Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
Onn Tai Yong | 28 Oct 10:14 2011
Picon

[JXLS] CellParser Can't find matching tag pair for

Hi there,

Currently the template as found in attachment reports the following error.

"ERROR [CellParser] Can't find matching tag pair for <jx:forEach items="${dto.detailDTOs}" var="detailDTO">"

As a result, the outcome is as shown in output-error.xls (last record / row)

However, when i generate a single record for the same employee, it is fine. (Refer to output-ok.xls).

May i know what is the root cause for the following issue, and how i could rectify the above issue? 


Thanks

--
Regards,

Onn Tai, Yong
onntai-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

Attachment (template.xls): application/vnd.ms-excel, 12 KiB
Attachment (output-error.xls): application/vnd.ms-excel, 60 KiB
Attachment (output-ok.xls): application/vnd.ms-excel, 10 KiB
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning <at> Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
Deina | 26 Oct 12:04 2011
Picon

Vertical rows

Hi,

Is it possible to generate a xls starting from a template
in which the rows are displayed vertically and not horizontally?

Instead of:
Name        |Age           |Payment     |Bonus       
Elsa           |28              |100             |100
Ene            |30              |200             |100

 
it should look like this:

Name         |  Elsa  |   Ene
Age            |   28     |   30
Payment    |  100    |   200 
Bonus        |   100   |   100

Thanks a lot,
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning <at> Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
Onn Tai Yong | 25 Oct 08:20 2011
Picon

[JXLS] Inner Collection not evaluated

Hi there,

Currently, i face an issue of inner collection not being evaluated.  This only occur the records are too much.  Please see attachment for both my template and snapshot where it is not evaluted.  May i know the root cause of this issue and how i can remedy it ?  Thanks...



--
Regards,

Onn Tai, Yong
onntai-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning <at> Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
Yohan Yudanara | 24 Oct 13:08 2011
Picon

Conditional Formatting?

Hi,


I want to ask a question. Please give me some clue... :). 
Is it possible to use conditional formatting with jxls?

Let's say I have this 2 column template:

    A                       B
<jx:forEach items="${rowList}" var="row">
${row.someIntValue}   ${row.booleanValue}  
</jx:forEach>

I want to fill column A cells with red background, whenever column B have TRUE value.
How to accomplish this using jxls? 

I was trying to use Excel Conditional Formatting, but it looks like Conditional Formatting can't work or can't be automatically copy to all rows of "${rowList}". 

Thanks in advance..

Best regards,
Yohan Yudanara

------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning <at> Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
Onn Tai Yong | 21 Oct 11:39 2011
Picon

[JXLS] New line in a cell?

Hi there,

How can i enable text-wrap (with "\n" in string) in jxls ??

--
Regards,

Onn Tai, Yong
onntai-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning <at> Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
Onn Tai Yong | 14 Oct 09:48 2011
Picon

[JXLS] How to with multiple inner collections ?

Hi All,

I would like to achieve the result as in scheduledSlotTemplate using JXLS. My dto objects  are as followed.


public class MainDTO {
     private String id;
     private String nric;
     private String name;
     private List<DetailDTO> mondayDTOs = new ArrayList<DetailDTO>;
     private List<DetailDTO> tuesdayDTOs = new ArrayList<DetailDTO>;
     private List<DetailDTO> wednesdayDTOs = new ArrayList<DetailDTO>;
     private List<DetailDTO> thursdayDTOs = new ArrayList<DetailDTO>;
     private List<DetailDTO> fridayDTOs = new ArrayList<DetailDTO>;
     private List<DetailDTO> saturdayDTOs = new ArrayList<DetailDTO>;
     private List<DetailDTO> sundayDTOs = new ArrayList<DetailDTO>;
   
}

public class DetailDTO {
    private String startTime;
    private String endTime;
}


I wonder if i could achieve the sample sheduled slot template with jxls and how can i achieve this ? The difficulty i am facing is i cannot use <jx:forEach> in a cell or same row..


Thanks in advance..

--
Regards,

Onn Tai, Yong
onntai-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

Attachment (scheduledSlotTemplate.xls): application/vnd.ms-excel, 10 KiB
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
STEFAN DANA | 13 Oct 14:08 2011
Picon

Multiple worksheets

Hi,

I tried to generate a xls with multiple worksheets using: transformer.transformMultipleSheetsList(),
but I received a RuntimeException and I can't tell what is the problem.
I am using the example from :http://jxls.sourceforge.net/reference/dynamicsheets.html.
Am I missing something here?

This is the stack trace:
Exception in thread "main" java.lang.RuntimeException: Could not find 'internal references' EXTERNALBOOK
    at org.apache.poi.hssf.model.LinkTable.checkExternSheet(LinkTable.java:410)
    at org.apache.poi.hssf.model.InternalWorkbook.checkSheets(InternalWorkbook.java:731)
    at org.apache.poi.hssf.model.InternalWorkbook.setSheetName(InternalWorkbook.java:579)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:745)
    at main.java.util.Main2$1.transformMultipleSheetsList(Main2.java:194)

Thank you,




------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
soy soy | 7 Oct 05:43 2011
Picon

Jxls Syntax

Good Day Everyone,

I seem to be stuck here..

Can I use column names that have $ # - and spaces that I retreived from my database (MySQL) ? I am getting parse errors.

And suppose I want to add all the price in the row that have the classification of "friend" in relationship column? what would be the syntax?

thanks! and God bless!!
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2dcopy2
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user

Gmane