Reading 2007 Office Excel Document into Database

Topics: User Forum
Mar 17, 2008 at 7:24 PM
So I've gotten the PHPExcelReaderExcel2007 class opening and loading a document into memory and using the php print_r() function, I can dump all that information to the screen. However, just about everything is private and I'm very confused about how I can access this information for later insertion into a MySQL database. Has anyone used this class for that purpose? If so, what did you do to make it work?

David Kees
Web and Database Specialist
Mechanical Science and Engineering Department
University of Illinois at Urbana-Champaign
Coordinator
Mar 18, 2008 at 7:18 AM
Please download the latest development version (http://www.codeplex.com/PHPExcel/SourceControl/ListDownloadableCommits.aspx), there is a toArray() method on each worksheet which could be useful for your sittuation.
Mar 18, 2008 at 1:11 PM
Excellent! That works like a charm. I truly appreciate your efforts.

David Kees
Web and Database Specialist
Mechanical Science and Engineering Department
University of Illinois at Urbana-Champaign