dhis2-devs team mailing list archive

[Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>]

Thank for helpful !

On Sat, Jul 18, 2009 at 8:58 AM, Murodullo Latifov
<murodlatifov@xxxxxxxxx>wrote:

>  Hi Hieu,
>
> Look at "Busy developer 's guide" here
> http://poi.apache.org/spreadsheet/quick-guide.html#NewWorkbook. Using
> inheritance or abstract classes/interface I would say is the right way
> instead of utility class. Why? Because every time you create an excel file,
> modify and save it, thus follow OO way.
>
> regards,
> murod
>
>  ------------------------------
> *From:* Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>
> *To:* Murodullo Latifov <murodlatifov@xxxxxxxxx>; Dhis2 <
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *Sent:* Friday, July 17, 2009 8:16:56 PM
> *Subject:* Fwd: JXL with POI
>
> 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@xxxxxxxxx>
> Date: Fri, Jul 17, 2009 at 3:35 PM
> Subject: Re: JXL with POI
> To: Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>
>
>
>  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@xxxxxxxxx>
> *To:* Murodullo Latifov <murodlatifov@xxxxxxxxx>
> *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 !
>
>


-- 
Hieu.HISPVietnam
Good Health !