View Excel file direct on web page

Support - Assistance technique
1

Hi all, Please help me, I want show excel file on webpage directly, how can i do that? is it possible ?

Tran Thanh Tri
HISP Viet Nam
+84903670967

2

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

···

2009/4/3 Trí Trần Thanh tranthanhtri84@gmail.com

Tran Thanh Tri
HISP Viet Nam
+84903670967

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–
Cheers,
Knut Staring

3

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@gmail.com

2009/4/3 Trí Trần Thanh tranthanhtri84@gmail.com

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

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–
Cheers,
Knut Staring

4

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

···

2009/4/3 Trí Trần Thanh tranthanhtri84@gmail.com

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.

5

  • Yes, i know birt can do that, but we have many problem when using birt for report. It useful for us but so difficult with normal use. We ready use birt for child heath report in Hồ Chí Minh, but now we must change to orther way.

  • We don’t have strong server, that why we can’t use birt. I see when generate report, server lost many memory for birt, after some time we must restart tomcat service. We have about 20 user using at same time.

Tran Thanh Tri
HISP Viet Nam
+84903670967

···

2009/4/3 Lars Helge Øverland larshelge@gmail.com

2009/4/3 Trí Trần Thanh tranthanhtri84@gmail.com

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