File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Splitting a large excel file into small multiple files

 
A Kumar
Ranch Hand
Posts: 980
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

How can i split a large excelsheet with 60000 records into small excel files of 5000 records..?

I tried but i am not getting values into the excel sheets..?

Regards
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There's a POI-HSSF project which provides APIs to interact with a xls file. However there is no direct API available to split files. You will have to write your own code using the APIs provided by POI to do the splitting.

I tried but i am not getting values into the excel sheets..?


What did you try?
 
A Kumar
Ranch Hand
Posts: 980
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
--------------------------------------------------------------------------------
I tried but i am not getting values into the excel sheets..?
--------------------------------------------------------------------------------


I tried with just the IO package but it didnt work ...
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use the POI APIs and try it out. Here's a Quick Start Guide
 
A Kumar
Ranch Hand
Posts: 980
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sure I will try it Pai!!!

Thanks

But is it not possible with standard IO streams to do the conversion!!
And why if it is not possible??
[ November 30, 2006: Message edited by: A Kumar ]
 
A Kumar
Ranch Hand
Posts: 980
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok...I got it...thanks All!!
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic