On 12/10/15 03:38, Karl DeSaulniers wrote: > If I could drop PHPExcel and use a better solution, I would. > Don't know of any and no time to research. Unfortunately. I work a lot with external data and CSV provides a nice way to sanitize material before importing it. Only work with Excel if you need the spreadsheet functions, but if you just need a set of data then export it to an intermediate format. One does have fun with dates and text, and comma's can often create secondary 'fun', in which case using tabs as a separator, or ensuring strings are wrapped in double quotes is an alternative, but importing the file IS just a matter of reading it 'block by block' but only processing it line at a time. Import process just does a raw dump, while update will use some unique key and update a record already stored in the database. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
