File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Beginning Java and the fly likes Splitting a large excel file into small multiple files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Splitting a large excel file into small multiple files" Watch "Splitting a large excel file into small multiple files" New topic
Author

Splitting a large excel file into small multiple files

A Kumar
Ranch Hand

Joined: Jul 04, 2004
Posts: 979
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

Joined: Jul 20, 2005
Posts: 10263
    
168

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?


[My Blog] [JavaRanch Journal]
A Kumar
Ranch Hand

Joined: Jul 04, 2004
Posts: 979
--------------------------------------------------------------------------------
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

Joined: Jul 20, 2005
Posts: 10263
    
168

Use the POI APIs and try it out. Here's a Quick Start Guide
A Kumar
Ranch Hand

Joined: Jul 04, 2004
Posts: 979
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

Joined: Jul 04, 2004
Posts: 979
Ok...I got it...thanks All!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Splitting a large excel file into small multiple files