I have to split an excel fileWhat do you call an Excel file?
I have to split an excel file containing more than 20000 RowsThis is not "huge"; this is a reasonable size for a desktop environment (probably in the magnitude of a hundred MB of data) so if your app needs to run on a desktop, you can load the whole file or the whole parsed content in memory.
I have to split an excel file containing more than 20000 Rows into 4-5 different excel workbooks each containing equal number of records.How are the records organized in the 4-5 files? If it's arbitrary, the easier would be to read lines one by one and stuff each new line in a different output file in turn. Otherwise, organizing the records would probably require to traverse all data twice (one to count them, one to write), not to mention other processing (sorting, filtering,...)
Kindly help me incase any one of you done done this in Java."it's all about the done-done, da-di-done-dah"
The division should be equal & each excel should on average contain 3000-4000 records.Is is just me or is there a contradiction in this sentence? What is the exact text of the exercice? If it's anything other than an exercice or self-practicing, there may be better ways to handle that than a Java app.