2009/4/3 Trí Trần Thanh <tranthanhtr...@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
_______________________________________________ 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
