dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

2009/4/3 Trí Trần Thanh <tranthanhtri84@xxxxxxxxx>

> Thanks.
>
> Really , we are developing Report module in DHIS2.0 for Vietnam.
> 1. We will design excel template file.
> 2. We will define report with some property and list of report item and
> link to exceltemplate file
>    Report Item have some property : row, column (position of cell in excel
> template file), expression [1023.4]+[103.5]ect...,
> 3. After have 2 thing, we will generate report by
>      - get datavalue from database by expression
>     - put this data into excel file by row-column position
>
> 4. With this way we can get data from excel file and insert into
> database(because we have position  (row-column) of dataelement in excel file
> by ReportItem
>
>
>  Now we can get data form database and put it into excel file and user can
> get it and view by Excel 2003. But now we want to find the way for view this
> excel file on webpage directly.


This idea is actually not so bad Tri:) Just want to make you aware that you
can create BIRT reports and use the built-in export to Excel there, I would
have explored that option first.

I don't think there is a way to present excel sheets on a web page directly.
My best guess would be to use JExcelApi and export to HTML, if possible.
Still, Firefox is able to display Excel sheets inside the browser in a
separate window. If you provide links for opening the Excel sheets and
instruct users to open them inside the browser I would believe that this is
more than good enough...


Lars