# View Excel file direct on web page

**URL:** <https://community.dhis2.org/t/view-excel-file-direct-on-web-page/5618>\
**Category:** Support - Assistance technique\
**Created:** [3 April 2009 13:33 UTC](https://community.dhis2.org/t/view-excel-file-direct-on-web-page/5618 "2009-04-03T13:33:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thanh\_Tri\_Tran](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/thanh_tri_tran/32/32921_2.png) [@Thanh\_Tri\_Tran](https://community.dhis2.org/u/Thanh_Tri_Tran)\
**Post date:** [3 April 2009 13:33 UTC](https://community.dhis2.org/t/view-excel-file-direct-on-web-page/5618/1 "2009-04-03T13:33:08Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Knut\_Staring](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/knut_staring/32/32549_2.png) [@Knut\_Staring](https://community.dhis2.org/u/Knut_Staring)\
**Post date:** [3 April 2009 14:46 UTC](https://community.dhis2.org/t/view-excel-file-direct-on-web-page/5618/2 "2009-04-03T14:46:06Z")

</div>

> 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](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](mailto:tranthanhtri84@gmail.com)
> 
> > Tran Thanh Tri  
> > HISP Viet Nam  
> > +84903670967
> > 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs)
> > 
> > Post to : [dhis2-devs@lists.launchpad.net](mailto:dhis2-devs@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
> 
> –  
> Cheers,  
> Knut Staring

---

<div class="post-metadata">

**Author:** ![Thanh\_Tri\_Tran](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/thanh_tri_tran/32/32921_2.png) [@Thanh\_Tri\_Tran](https://community.dhis2.org/u/Thanh_Tri_Tran)\
**Post date:** [3 April 2009 16:17 UTC](https://community.dhis2.org/t/view-excel-file-direct-on-web-page/5618/3 "2009-04-03T16:17:33Z")

</div>

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

3. After have 2 thing, we will generate report by

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](mailto:knutst@gmail.com)
> 
> > 2009/4/3 Trí Trần Thanh [tranthanhtri84@gmail.com](mailto: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](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@lists.launchpad.net](mailto:dhis2-devs@lists.launchpad.net)
> > > 
> > > Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)
> > > 
> > > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
> > 
> > –  
> > Cheers,  
> > Knut Staring

---

<div class="post-metadata">

**Author:** ![Lars](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/lars/32/34166_2.png) [@Lars](https://community.dhis2.org/u/Lars)\
**Post date:** [3 April 2009 16:58 UTC](https://community.dhis2.org/t/view-excel-file-direct-on-web-page/5618/4 "2009-04-03T16:58:44Z")

</div>

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](mailto: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
> > 
> > 3. After have 2 thing, we will generate report by
> > 
> > 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.

---

<div class="post-metadata">

**Author:** ![Thanh\_Tri\_Tran](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/thanh_tri_tran/32/32921_2.png) [@Thanh\_Tri\_Tran](https://community.dhis2.org/u/Thanh_Tri_Tran)\
**Post date:** [4 April 2009 03:24 UTC](https://community.dhis2.org/t/view-excel-file-direct-on-web-page/5618/5 "2009-04-04T03:24:57Z")

</div>

- 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](mailto:larshelge@gmail.com)
> 
> > 2009/4/3 Trí Trần Thanh [tranthanhtri84@gmail.com](mailto: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
> > > 
> > > 3. After have 2 thing, we will generate report by
> > > 
> > > 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
