poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: Sorting by column(s)
Date Wed, 20 Jan 2010 07:32:01 GMT

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message