Do not know for certain about the export but would have assumed all of the sheet in one file.
Yours Mark B f.dcg wrote: > >> >> Hello again. >> > Indeed .. > > >> Am back in from work now and with cup of tea in hand so feeling far more >> 'human'. When I said that I could not really comment re performance of >> the >> two solutions, I hope I did not sound too sniffy; that was not my >> intention >> and I am sorry if my reply came across that way. All I wanted to do was >> say >> that I could not offer any informed opinion either way. >> > Absolutely no worries at all .. concise and to the point .. nothing wrong > with that, at all. > > Fully understand your point about non Windows environments and it sort of >> negates the suggestion I was going to make which was automating the >> process >> using macros and Excel but that can be put aside for now. >> > Let's indeed .. ;-) > >> >> Whilst I was out and about today, I thought did occur to me. Are you >> targetting the older binary file (.xls) or the newer xml (.xlsx) based >> formats? If the latter, then it may be worth looking at Yegor's >> BigGridDemo >> >> http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java >> . >> The intention was to demonstarte how to create very large workbooks >> without >> running into memory issues and, as I understand it, the process is to >> stream >> data into a temporary file and then use this to populate a workbook. It >> may >> be that you could adapt this approach but I must emphasise that it will >> only >> work for the newer xml based files as it relies upon the XSSF stream of >> the >> API. >> > Good suggestion for the xlsx files. Since i don't know what i'll be > running > into i'll go for both xls and xlsx as well simultaneously. > Do an instanceof check and start work on the proper format .. > I think the event based solutions might actually work without too much > hassle .. doing the full in memory thing is just not an option. > > >> >> Glad you decided to open a new thread for the xls2csv as I know nothing >> about it and it would be too easy for other list members to miss if it >> were >> tacked onto this discussion. >> > Don't get me started .. been there seen that .. > > Re. the csv export code .. > Is my assumption correct that all workbook sheets are exported in 1 file > and > not 1 file per sheet? > If so i'll probably have to add a new method that creates a outputStream > for > a certain sheet and give it its own filename .. > > Once finished, would posting it to the list make sense (maybe someone > could > even improve upon it and/ or stick it in the examples repo .. ;-) ) > > Reg. > > Fermin DCG > > -- View this message in context: http://old.nabble.com/Sorting-by-column%28s%29-tp27209292p27237767.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]
