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]
