0

I would like to add data from 2 worksheets in the same document and have them combined in one worksheet. Am using PHPExcel could you guys kindly help.

-worksheet 1 and worksheet 2 = worksheet 3(combined worksheet1+worksheet2)

Thanks

2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by tapuwa2002
0

@tapuwa2002

I would like to add data from 2 worksheets in the same document and have them combined in one worksheet. Am using PHPExcel could you guys kindly help.

Did you search this issue on PHPExcel first before you post this question here?

-worksheet 1 and worksheet 2 = worksheet 3(combined worksheet1+worksheet2)

When you combine 2 worksheets it becomes 1 worksheet not 3 worksheets.

PHPExcel should have this code that does that in the Documentation in MS Office format.

Here is the code:

http://phpexcel.codeplex.com/discussions/390898

I also used PHPExcel too.

Edited by LastMitch: grammer

0

Thank you for your patience, am learning these new classes, so learning curve is a bit steep. I will read and try your link. All i want to do is, on the one worksheet the last row, the second work sheet data should go on the next. I only found out about this class today so please bare with me. thanks again.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.