• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Appending different xls in a single xls

 
Naseem Khan
Ranch Hand
Posts: 809
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic