Mark, The Oracle Report Server is installed on a unix machine (Sun) and VMWare emulate the Windows OS. So at this time it have not installation option for a Office 200.. in this qual and prod machine. So i'm finding a java solution...(jdk 1.6)
2009/12/11 MSB <[email protected]> > > If you are running on a Windows PC that has a copy of Excel 2007 (or later) > installed on it then you do have another option. It is possible to use OLE > to control an instance of the Excel application and have it perform the > conversion for you; obviously, I am assuming that the file Oracle produces > can be read by Excel but I reckon that this is a safe bet. There are third > party libraries such as the SWT and JACOB that allow you to control an > OLE/COM enabled application from Java code but they will only work on > Windows plaforms and I have not yet managed to make one work over a network > even though I am convinced (certain) that it ought to be possible. > > If this seems like a viable option for you, just let me know as I have some > SWT code that manipulates Excel and I am fairly confident that it could > very > easilly be modifed to perform such a file conversion process. > > Yours > > Mark B > > PS Having another google around, I came across this - > http://phpexcel.codeplex.com/. > > > chrc wrote: > > > > Hello Mark, > > > > You understood what I wanted to tell. > > I use google for , i've already found the same > > rep2excel<http://www.lv2000.com/rx/rep2excel.htm>soft. But It's not > > open source. > > I've begun making my own piece of code... > > So, if somebody have the same problem, we can try working in the same > > way.... > > > > Best Regards > > > > Chris > > > > > > 2009/12/11 MSB <[email protected]> > > > >> > >> I am not too sure that people really understand what you are asking > here. > >> Are > >> you saying the you have used an Oracle tool to produce a report. This > >> report > >> is actually a file of html markup that is rendered into an Excel like > >> spreadsheet format when viewed with a browser and that you would like to > >> use > >> POI to convert this file into a valid Excel spreadsheet file? If so, > then > >> POI can certainly handle the 'encoding' side so to speak but you will > >> need > >> to write a parser to strip the information from the html markup I think. > >> > >> Did you try googling this requirement at all? I have just found this > tool > >> - > >> http://www.lv2000.com/rx/rep2excel.htm - that promises to do exactly > what > >> you require. > >> > >> Yours > >> > >> Mark B > >> > >> > >> chrc wrote: > >> > > >> > Hello, > >> > > >> > By using Oracle Report 10g to generate a Excel file, i can have a big > >> file > >> > > > >> > 10m, because the result format is a Microsoft XML Schema for Excel > >> (html). > >> > > >> > So, i try to use poi to parse and generate a true lightweight Excel > >> file. > >> > > >> > Somebody has already made this job ? > >> > > >> > Thanks > >> > Best Regards > >> > > >> > Chris > >> > > >> > > >> > >> -- > >> View this message in context: > >> > http://old.nabble.com/Convert-Oracle-Report-Excel-file-to-true-lightweight-format-tp26724751p26740544.html > >> Sent from the POI - User mailing list archive at Nabble.com. > >> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [email protected] > >> For additional commands, e-mail: [email protected] > >> > >> > > > > > > -- > View this message in context: > http://old.nabble.com/Convert-Oracle-Report-Excel-file-to-true-lightweight-format-tp26724751p26743286.html > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
