dhis2-devs team mailing list archive

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

Hi Murod,

After using your project to generate a random excel file from my template, "
*tx_bieu_2.xls*".
I've got a new file, for example: "*Form - tx_bieu_2.xls1245381039109.xls*".

Your code is running very stable.
By the way, I've tried to write a new java file for checking this new one's
structure.

And ,,, just only magic can change everything.

You can get more reference with my attached files as below.
Place the template file at the location "C:\"

>From the POI or JXL Excel API technique, I think the reason why we couldn't
get the real values from the formula cells is that these values which is
only calculated by itself tool (MS Office: .xls or Open Office: .odt). I
mean we must open the generated file to see the correct answers at that
time.

*p.s*: Did you know how to get the data (value) by input as an string
formula with POI ???


*Thank you very much for all your ardour !*


On Thu, Jun 18, 2009 at 5:19 PM, Murodullo Latifov
<murodlatifov@xxxxxxxxx>wrote:

> Hi Hieu,
>
> See attached as sample implementation of POI. Its Eclipse java project,
> simply unrar and import to Eclipse, place this template in c:\, run Runner,
> see new files created in c:\. It uses your template and fills in some random
> data from list of list of integers. And finally places two formula and
> styles it. Should help a lot. Also number of stylings are available, some
> are used as example. For the rest consult
> http://poi.apache.org/spreadsheet/quick-guide.html.
>
> regards,
> murod.
>

-- 
Hieu.HISPVietnam
Good Health !

Attachment: TestExcelReportPOI.java
Description: Binary data

Attachment: Form - tx_bieu_2.xls1245381039109.xls
Description: MS-Excel spreadsheet