Splitting a large excel file into small multiple files

[A Kumar]

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]

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]

--------------------------------------------------------------------------------
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]

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

[A Kumar]

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]

Ok...I got it...thanks All!!