dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #00521
Re: View Excel file direct on web page
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.
Tran Thanh Tri
HISP Viet Nam
+84903670967
2009/4/3 Knut Staring <knutst@xxxxxxxxx>
> 2009/4/3 Trí Trần Thanh <tranthanhtri84@xxxxxxxxx>
>
>> Hi all, Please help me, I want show excel file on webpage directly, how
>> can i do that? is it possible ?
>
> Hi Tri,
> If you only want to display data from Excel online and it is less than 1
> MB, you can use Google Docs:
> http://docs.google.com/DocAction?action=updoc&hl=en
> But I guess you are talking about displaying data from Excel in a DHIS 2
> module? Without first importing it to the database?
> Import of data from Excel is quite high on my list of priorities, as it is
> a situation we face quite often with existing data. I think we should agree
> on a format for those kind of situations (I can add it as a blueprint). But
> it seems you want something different?
> Knut
>
>
>> Tran Thanh Tri
>> HISP Viet Nam
>> +84903670967
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>> More help : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Cheers,
> Knut Staring
>
Follow ups
References