Can I be clear about what you are trying to do please? Are you saying that you have a workbook open in Excel 2007 and that without saving the file you have made you want to transport the changes you have made - and only the changes - into some other application?
If that is indeed the case, then I cannot see how you would be able to do this without resorting to an Excel macro. If you think about the major problem for a minute, until you save the Excel file away somewhere there is no way to connect any sort of stream to the data. Further, how would the stream 'know' what information to copy? An Excel macro on the other hand does have access to the internal state of the application. It could - at least I think it could - recognise the changes you have made and it could - again I think this is the case - be tasked to save them away to file. But again, the details could get messy - what should it do with non-contiguous cells? Should it preserve the locations of the cells as this could mean a very sparsely populated sheet (obviously, I do not now exactly what your sheets look like so am guessing here). If instead you are asking is there a constructor for the XSSFWorkbook class that accepts an InputStream as a parameter, then the answer is yes. The stream must however be connected to an OpenXML file somewhere. Suladna wrote: > > Hi! > > Is there any workaround that enables me to create an XSSFWorkbook using an > InputStream? > > The reason I wonder is because I have want to bring updated data from my > Excel 2007 workbook without first having to save it. When I asked > about this on a Java-forum I heard that it was possible to do using > InputStream (see reply #9 to my question in the below link) > > http://forums.sun.com/thread.jspa?threadID=5381447 > > Best regards, > Sul > > > > -- View this message in context: http://www.nabble.com/Creating-XSSFWorkbook-object-using-InputStream-tp23382602p23384995.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]
