Level 3
I just can recommend to you this library. It simplifies A LOT excel's handling, plus lot of useful and cool features. Take a look and don't reinvent the wheel ;).
1 like
I have a controller that accepts an excel upload file, stores the file (creates an entry in the documents table in the db with the path to file), and then extracts data from the excel file using PHPExcel and creates db entries from each from.
This looks really messy. My question is how do you typically go about handing this sort of scripting in OOP where you have to stream in data and parse it.
For example, should I create an Object that extends PHPExcel_IOFactory?
Please or to participate in this conversation.