Hi, But if we open csv file by using excel, we get as in form of sheets, that the way i required
Kindly see this.. On Fri, Mar 28, 2014 at 2:39 PM, Sergey Maslov <[email protected]>wrote: > Hi, > CSV is a plain file, it does not support multiple sheets. > > On Fri, Mar 28, 2014 at 10:13 AM, Sai Pavan Gadde <[email protected] > >wrote: > > > Hi Everyone, > > > > I got struck with the task like, I have an excel workbook that contains > > no.of excel sheets which is in the size more than 100MB. Now i would like > > to get a java coding for it without using an array-list parameter, rather > > should use a good parameter which should not consume memory. > > > > > > Also, In CSV file, i need the same sheets that obtain in xls file after > > conversion to csv. Recently i faced the problem like all excel sheets > > merging into single csv sheet file. > > ref: > > > > > http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java > > > > I am glad and thankful in advance for getting a quick and good reply > > -- > > *THANKS & REGARDS,* > > G.SAI PAVAN, > > CCDH4 CERTIFIED, > > Ph: 8121914494, > > *www.bigdatatrendz.com <http://www.bigdatatrendz.com>* > > linkedin profile <http://in.linkedin.com/pub/gadde-sai-pavan/38/44b/453/ > > > > HYDERABAD. > > > -- *THANKS & REGARDS,* G.SAI PAVAN, CCDH4 CERTIFIED, Ph: 8121914494, *www.bigdatatrendz.com <http://www.bigdatatrendz.com>* linkedin profile <http://in.linkedin.com/pub/gadde-sai-pavan/38/44b/453/> HYDERABAD.
