Jump to content

how to combine excell file into one using java.

antzrambo's Photo
Posted Feb 14 2012 05:48 PM
1397 Views

this is the problem that i've been facing for every month. there's about 60++ excell file and every one of it contain 3 sheets that is Malay, English and Chinese. what i have to do is take all the data about malay into one sheet@workbook. same goes for english and chinese. is there any solution for this by using java? rather than i have to copy and paste all the time. will save a lot of my time.

if somebody can help me with it.. thank you.

Tags:
0 Subscribe


1 Reply

0
  Michele Milesi's Photo
Posted Mar 20 2012 11:15 PM

You may try to use Apache POI (poi.apache.org) that works both with XLS and XLSX formats.

You can create a new workbook with three sheets, then open each of the original excel files and append the record, sheet by sheet and cell by cell, at the new workbook.

It looks like an array merge algorithm.