Appending different xls in a single xls

[Naseem Khan]

Hi,

Could anyone please tell me how to append the different excel sheets content in a single xls file.

I have different excel sheets and I want to write the records of all excel sheets in a single master.xls

I have tried writing it by apache POI, but it�s not appending the files in a single file rather it is updating the same master.xls with different input source xls file

Many Thanks,
Regards,
Naseem
[ September 12, 2008: Message edited by: Naseem Khan ]

[Ulf Dittmer]

I don't think that there's a way to copy a sheet from one file to another. You may have to create a new sheet and copy the rows, cells and cell styles one by one.