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.
<br><br>HTH.<br><br><div><span class="gmail_quote">On 5/13/07, <b class="gmail_sendername">fasiuddin mohammed</b> <<a href="mailto:fasi.abbu@gmail.com">fasi.abbu@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Yep.. I think Java API's the way to go.. Thanks a lot guyz...<br><br>On 5/11/07, Richard Knechtel <<a href="mailto:richard.knechtel@gmail.com">richard.knechtel@gmail.com</a>> wrote:<br>> If you want to do a little programming (Java) you can use JExcel API or
<br>> Apache POI. We use both at work for generating Excel worksheets from<br>> database recordsets and POJO's. They both will go the other way as well and<br>> convert Excel into delimited CSV's. I think POI is much better for this
<br>> though.<br>><br>><br>> On 5/10/07, fasiuddin mohammed <<a href="mailto:fasi.abbu@gmail.com">fasi.abbu@gmail.com</a>> wrote:<br>> ><br>> > Hi all,<br>> > Just automating a process.. Any idea how to convert Excel files
<br>> > to csv files in Linux..<br>> ><br>> > Thanks<br>> > fasi<br>> > _______________________________________________<br>> > clue-tech mailing list<br>> > <a href="mailto:clue-tech@cluedenver.org">
clue-tech@cluedenver.org</a><br>> > <a href="http://www.cluedenver.org/mailman/listinfo/clue-tech">http://www.cluedenver.org/mailman/listinfo/clue-tech</a><br>> ><br>><br>_______________________________________________
<br>clue-tech mailing list<br><a href="mailto:clue-tech@cluedenver.org">clue-tech@cluedenver.org</a><br><a href="http://www.cluedenver.org/mailman/listinfo/clue-tech">http://www.cluedenver.org/mailman/listinfo/clue-tech</a>
<br></blockquote></div><br>