wtt Posted August 6, 2007 Share Posted August 6, 2007 I have an Excel file. However, I don't think that Excel has enough report function and I am interested in using Jasperreporting to do that? Is that possible? Did anyone do that successfully? Can you give me some estimates about how long does it take to set up? Link to comment Share on other sites More sharing options...
szaharia Posted August 6, 2007 Share Posted August 6, 2007 Unfortunately, the way things are going is exactly in reversed order: you can obtain an Excel output from a compiled report template, but not the other way around. Regards,sandaPost edited by: shertage, at: 2007/08/06 11:44 Link to comment Share on other sites More sharing options...
berlim Posted August 6, 2007 Share Posted August 6, 2007 Jasper doesn't let you get information from excel, but there are many other programs that do. I am not sure if this is what you are looking for, but you can use like java XLS or apache poi to read the excel sheet and then convert that to xml with another program and then read it off w/ Jasper good luck. Link to comment Share on other sites More sharing options...
wtt Posted August 6, 2007 Author Share Posted August 6, 2007 Thanks for your quick reply. I am a little disappointed. However, are there any software packages to enhance Excel features? I looked at those two you mentioned, it seems very hard to get it to work... Link to comment Share on other sites More sharing options...
szaharia Posted August 6, 2007 Share Posted August 6, 2007 Could you be more specific? I mean, how about the Excel file you want to read? Is it a complex one, does it contain images, structured texts, complex paragraphs, or just some columns containing values? What is your final purpose - reproducing exactly the layout of Excel document, or just using its data?Take a look at this post, maybe it's useful. hth,sanda Link to comment Share on other sites More sharing options...
berlim Posted August 7, 2007 Share Posted August 7, 2007 wtt wrote:Thanks for your quick reply. I am a little disappointed. However, are there any software packages to enhance Excel features? I looked at those two you mentioned, it seems very hard to get it to work... As I'm not sure what you are trying to do, the software I mentioned is very very simple to extract information out of cells and store into objects in java, they are probably useless doing anything else, thou I don't see what else you would like to do. As shertage said, elaborate on what you want. Link to comment Share on other sites More sharing options...
wtt Posted August 14, 2007 Author Share Posted August 14, 2007 Thanks for your reply! These are mostly valued based customer data. I just want them to be outputed to nicer format other than pivotal table...Post edited by: wtt, at: 2007/08/13 22:24 Link to comment Share on other sites More sharing options...
gbegley Posted August 14, 2007 Share Posted August 14, 2007 Office 2k3 or 2k7 Should provide the option to save in XML format. If you open the document in an XML tool, it should be easy to find the xpaths you need to use this as an XML datasource to your report. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now