Calling a saved spreadsheet to populate with data

Topics: Developer Forum, User Forum
Jan 15, 2016 at 8:20 PM

I'm new at using this tool and not done anything like this in the past.

I am using PHPExcel on a project with a mysql database running on Ubuntu. I am just learning how to use this and have been able to populate a blank spread sheet with a mysql query, works great. Now what I would like to do is to take a spreadsheet that is formatted and saved and populate that with data from a query. I'm using $objPHPExcel = new PHPExcel() ; to create the new spreadsheet and $objPHPExcel->setActiveSheetIndex(0) and $objPHPExcel->getActiveSheet() to populate the spreadsheet on my first project. for my new project how would I call a saved spreadsheet so that I can populate it with data?

Thanks for any help. Let me know if you need more information.