wood burning stoves 2.0*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 9930
    
159

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: 9930
    
159

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!!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Splitting a large excel file into small multiple files
 
Similar Threads
Large Files
how To compare to excel Files using java
getting Unwanted NULL records
How to increase excel row count
email issue