Filter on Import or Export

Jul 15, 2013 at 4:34 PM
Edited Jul 15, 2013 at 4:40 PM
Hi all,

I have been reading all morning and have been successfully working though the Example php files as well as reading through the Discussions here. Awesome stuff.

Hopefully this is an easy one for someone. I can pull my excel file in and display it as a table and I know I can save that table to mySQL as I have done this in the past without PHPExcel. Where I am stuck is cleaning the import.

So I guess the question is:

If you take for example I do not want to import any column that does not have a H column value. Can I filter the table on import or must I fix on export?

If I can on import that would really cut down on overhead as the sheet is rather large and I can eliminate a lot of comments cells and just grab the data I need.

Thanks in advance,

Brett C.