Using POI, I would strongly doubt that this is possible; the API is designed to allow you to create files that can be opened by someone using Excel. You will always need to create a file as an intermediate step in this sort of process.
The only option that I can think og is OLE as this would allow you to open an instance of Excel and populate the workbook for the user to see. This technique is however quite limited, it is not suitable for use in a distributed environment, error handling is poor, and you would have to be running the code on a Windows based PC and a copy of Excel would have to be installed on that PC. You could take a look at the SWT classes. If I remember correctly, one of the containers supports OLE enabled applications so that you could, for example, have Excel running within a control on a GUI form written using java code. I do not think that it is possible to mix awt/swing and swt components however so this could entail quite a bit of extra work on your part. Yours Mark B Dreamcatcher wrote: > > Hi Guyz.. > > I am using Apache POI in my project. I want to export the data from data > Table to an EXCEL FILE, thanks to apache POI library through which i got > success in that task. But now the problem is that i want such excel file > which doesnt exist i.e. which is not be saved on my hard drive, Inshort i > just want to write data in an Unsaved Excel file in such a way that > whenever user clicks the menu of Export To Excel an Excel Sheet gets > opened with no name and with no path over my hardrive but should contains > the data of that particular data Table..... > > I would be very grateful to you guyz for any sort of help... > > Regards: > Dreamcatcher.... > -- View this message in context: http://www.nabble.com/Write-data-in-unsaved-Ecxel-File...-tp24823324p24831344.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]
