Treatment excel

Topics: Developer Forum, Project Management Forum
Jan 20, 2010 at 12:42 PM

Hello, I'm new here and have some questions. I don't know so much about php, but I need to do a page that load an excel (one or more) and this page will make treatment in the excel file, removing columns and rows that not corresponding with the "Model excel, that have columns predefined or with a table of DB" , remove null rows and insert data in cells that is necessary, example: if I need Date and the excel file don't have this column I need to create and insert some values.

Thanks, Bárbara - Brasil

Developer
Jan 21, 2010 at 4:18 AM

If your Excel file is not too complex this should be possible to do using PHPExcel. Do you have any code so far?