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
Curtis Stanford | 29 Sep 22:57 2011

Performance going downhill

Hi Leo. I've been using jxls for many years now and have noticed a huge decrease in performance over the
years. I have a fairly large dataset that I've tried with 0.9.3, 0.9.7 and 1.0-rc2. The times are:

0.9.3: 28 minutes
0.9.7: 1 hour
1.0-rc2: 4 hours

I've been profiling the code for a few days and was able to improve the 1.0-rc2 time by 2.5X (1 hour 45
minutes). However, I don't know what 0.9.3 was doing differently to be so fast. A lot of time is spent
updating formulas after every transformation and with over 12,000 formulas and rising, this takes a long time.

Any info and/or suggestions would be appreciated.

Curtis

PS - any work on new versions lately?

------------------------------------------------------------------------------
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-d2dcopy1
George Brennan | 7 Sep 16:44 2011

Cell processor

Hi,

 

I’ve been looking at the row processor and cell processor in the current release of  JXLS and can’t get the examples or tests to work.

The row and col objects passed do not appear to support the wider POI methods or have any access to the workbook styles.

Also the code for net.sf.jxls.parser.Cell on the Internet doesn’t appear to be the same as the SVN codebase which doesn’t have and version/revision info in it.

 

Any suggestions where I should look?


Regards

George

 

 

George Brennan
Architect

COMAC CAPITAL LLP | STRATTON HOUSE | 5 STRATTON STREET | LONDON | W1J 8LA
Tel: +44 207 864 6455 | Email: GBrennan <at> comaccapital.com

COMAC Capital LLP is a Limited Liability Partnership registered in England and Wales, Company No: OC316831.  Registered Office: Stratton House, 5 Stratton Street, London, W1J 8LA. Authorized and regulated by the Financial Services Authority of the United Kingdom ("FSA").  A list of members is available for inspection at the registered office.

 

 

COMAC Capital LLP DISCLAIMER: This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments.

COMAC Capital LLP is a Limited Liability Partnership registered in England and Wales, Company No: OC316831.  Registered Office: Stratton House, 5 Stratton Street, London, W1J 8LA. Authorized and regulated by the Financial Services Authority of the United Kingdom ("FSA").  A list of members is available for inspection at the registered office.

------------------------------------------------------------------------------
Using storage to extend the benefits of virtualization and iSCSI
Virtualization increases hardware utilization and delivers a new level of
agility. Learn what those decisions are and how to modernize your storage 
and backup environments for virtualization.
http://www.accelacomm.com/jaw/sfnl/114/51434361/
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
andrey skrypnik | 7 Sep 09:35 2011
Picon

Cell Processor

hello. I'm using the jslx 1.0 + jexl  2.0 and i need to use the CellProcessor. I look at ur example RedCellProcessor and there everything looks ok. But when i try to invoke next :

Property property = (Property)expression.getProperties().get(0);i gen the property.getBeanName = nullproperty.getBean = null

whay it so ? 




--
Читайте и отправляйте электронные письма прямо со своего телефона.
Просто зайдите с телефона на m.mail.ru
------------------------------------------------------------------------------
Using storage to extend the benefits of virtualization and iSCSI
Virtualization increases hardware utilization and delivers a new level of
agility. Learn what those decisions are and how to modernize your storage 
and backup environments for virtualization.
http://www.accelacomm.com/jaw/sfnl/114/51434361/
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user
andrey skrypnik | 6 Sep 13:36 2011
Picon

CellProcessor

Hello. I'm using JSXL for generating Excel report by my personal template. And i try yo use ur example RedCellProcessr (jxsl 1.0RC2 + jexl 2.0). 

but here 
Property property = (Property)expression.getProperties().get(0);

the property.getBeanName and property.getBean is null.

why ? can u help me please.

------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better 
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@...
https://lists.sourceforge.net/lists/listinfo/jxls-user

Gmane