Hi guys,
>From the docs on the poi web site. I know we can use
>org.apache.poi.hssf.usermodel.HSSFWorkbook to create excel 2003 file, like
>HSSFWorkbook workbook = new HSSFWorkbook(); And use workbook.write("test.xls")
>to generate the excel file. If you want to have a low memory cost only to read
>excel file, you can use eventmodel.
But if i will create a large excel file, it will cost a lot memory to get the
whole workbook object ready before writing to file using workbook.write("***")
. What's the best way to use poi to create large excel files? I donot think it
is the best way to set a large heap of jvm.
Need your help. Thanks!
Your friend
Yan
_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail
you.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_3:092010