Dear Murod,
It is joyful when received your reply mail.
So behind in this mail, I’ve got some wonders to worry to ask you:
How can we do if none of using a template instead-of a scratch file ?
By the way, I shall focus on your suggestion about the inheritance. It’s really helpful for me to get a next important step to working on POI.
But, I’m still misunderstanding or can say that it’s a vague thing of mine about this. Why should be have done as an Interface or Abstract class ? Is that right your meaning ? Why not as a utilizable class file which I sent to you before ?
Thank you !
p.s: Also forward to the mailing list.
···
---------- Forwarded message ----------
From: Murodullo Latifov murodlatifov@yahoo.com
Date: Fri, Jul 17, 2009 at 3:35 PM
Subject: Re: JXL with POI
To: Hieu Dang Duy hieu.hispvietnam@gmail.com
Hi Hieu,
Good to hear you managed to solve your problems. You can place or remove format stuff as you wish. The idea behind having formats is to have ability to create excel from scratch, that means not having any template, creating new excel file, adding formats, sizing you columns, etc. Main point is to unify most and frequent used methods in a separate file and inherit from it and not to type it all the time, which is general in object oriented programming. I suggest you to have a java class with all formats and common methods, like your writeValue() and create other specific implementations inheriting from it, this way you will have clear code, and overwrite when needed.
It would be good if you use mailing list, so others may sometimes use solution, and find out how did it work.
Good luck,
murod
From: Hieu Dang Duy hieu.hispvietnam@gmail.com
To: Murodullo Latifov murodlatifov@yahoo.com
Sent: Wednesday, July 15, 2009 3:05:30 PM
Subject: JXL with POI
Dear Murod,
Finally, I’ve solved the issue of recalculating value by POI’s Formula Evaluation (JXL combines with POI - so excited)
So, really thanks to your help !
Until now, a quite small problem is that I wanna replace the way of writing on Excel file from JXL to POI.
But I’m not good at POI technique. So, can I ask you some questions such as:
What should I have done if using POI to replace JXL to write on excel file, for example:
-
Any important formats (Font, Number, String, Formula, etc…) ?
-
Any main points which must be pay attention to ?
In your project POI that you sent to me. I see that you’d declared so many formats :
**HSSFFont csf = hssfworkbook.createFont();
HSSFFont csfBold = hssfworkbook.createFont();
HSSFDataFormat df = hssfworkbook.createDataFormat();
HSSFCellStyle cs = hssfworkbook.createCellStyle();
HSSFCellStyle csHeader = hssfworkbook.createCellStyle();
HSSFCellStyle csSize = hssfworkbook.createCellStyle();
HSSFCellStyle csCurrency = hssfworkbook.createCellStyle();
HSSFCellStyle csSizeBold = hssfworkbook.createCellStyle();
HSSFCellStyle csCurrencyBold = hssfworkbook.createCellStyle();
HSSFCellStyle csPercentage = hssfworkbook.createCellStyle();
HSSFCellStyle csNormal = hssfworkbook.createCellStyle();
HSSFCellStyle csNormalOdd = hssfworkbook.createCellStyle();
HSSFCellStyle csCurrencyOdd = hssfworkbook.createCellStyle();
HSSFCellStyle csPercentageOdd = hssfworkbook.createCellStyle();
HSSFCellStyle csSizeOdd = hssfworkbook.createCellStyle();
HSSFCellStyle csCountOdd = hssfworkbook.createCellStyle();
HSSFCellStyle csCount = hssfworkbook.createCellStyle();**
If I leave these formats above in my source code so what will be happened ?
I shall send to you a file “ExcelUtil.java”. Can you take a look at this one. And please give me some of suggestions.
THANK SO MUCH !
–
Hieu.HISPVietnam
Good Health !
–
Hieu.HISPVietnam
Good Health !