[clue-tech] Converting excel files to csv in Linux

[Richard Knechtel]

Just be forward if your going to be doing large Excel spreadsheets you will
need a large heap. I'm doing 40,000 row datasets into Excel and I need a
756M heap. So set some Java Args -X:Xms=128  -X:Xmx=756M or more if your
doing large datasets, you can play with your perm size and max perm sizes to
suit your needs. 256M -will- give out OutOfMemoryError's at around
28,000-29,000 rows of data with these API's. I have looked at -all- the Java
API's and all will require large heaps to use with large datasets but with a
756M-1024M heap you should be able to do up to 65,000 row Excel spreadsheets
(max row size is like 65553 I believe for a singel Excel spreadsheet)
comfortably.

HTH.

On 5/13/07, fasiuddin mohammed <fasi.abbu at gmail.com> wrote:
>
> Yep.. I think Java API's the way to go.. Thanks a lot guyz...
>
> On 5/11/07, Richard Knechtel <richard.knechtel at gmail.com> wrote:
> > If you want to do a little programming (Java) you can use JExcel API or
> > Apache POI. We use both at work for generating Excel worksheets from
> > database recordsets and POJO's. They both will go the other way as well
> and
> > convert Excel into delimited CSV's. I think POI is much better for this
> > though.
> >
> >
> > On 5/10/07, fasiuddin mohammed <fasi.abbu at gmail.com> wrote:
> > >
> > > Hi all,
> > >        Just automating a process.. Any idea how to convert Excel files
> > > to csv files in Linux..
> > >
> > > Thanks
> > > fasi
> > > _______________________________________________
> > > clue-tech mailing list
> > > clue-tech at cluedenver.org
> > > http://www.cluedenver.org/mailman/listinfo/clue-tech
> > >
> >
> _______________________________________________
> clue-tech mailing list
> clue-tech at cluedenver.org
> http://www.cluedenver.org/mailman/listinfo/clue-tech
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue-tech/attachments/20070513/fb218a4b/attachment-0002.html