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

Recommended Answers

All 2 Replies

Member Avatar for LastMitch

@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.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.