Comments on: Read Excel with PHP http://www.terminally-incoherent.com/blog/2006/07/12/read-excel-with-php/ I will not fix your computer. Tue, 04 Aug 2020 22:34:33 +0000 hourly 1 https://wordpress.org/?v=4.7.26 By: Adham http://www.terminally-incoherent.com/blog/2006/07/12/read-excel-with-php/#comment-9270 Fri, 06 Jun 2008 20:29:57 +0000 http://www.terminally-incoherent.com/blog/2006/07/12/read-excel-with-php/#comment-9270

I have just recently finished setting phpExcelReadr for my intranet, and it reads the data and displays it perfectly. Nevertheless, my only concern is that it also prints and row/col numbers/letters. I am trying to have it disregard them and treat the first row as a header (for cosmetic purposes). Would you have any idea about the go around in achieving this result? Any suggestions and/or assistance will be really appreciated.

Reply  |  Quote
]]>
By: Luke http://www.terminally-incoherent.com/blog/2006/07/12/read-excel-with-php/#comment-3379 Wed, 21 Mar 2007 06:00:11 +0000 http://www.terminally-incoherent.com/blog/2006/07/12/read-excel-with-php/#comment-3379

This question would probably be best sent to the original developer. I will look at the code tomorrow, but I’m assuming that putting that string on the 0xe line didn’t work… If you haven’t tried it, go do it now.

Quick and dirty hack would be simply look at the fist digit of the year and assume that if it is greater than say 4 then assume that you are dealing with 1900’s – otherwise you are dealing with 2000’s.

Of course this means that your application will break in 2040 but you know… :P

Reply  |  Quote
]]>
By: Sarika http://www.terminally-incoherent.com/blog/2006/07/12/read-excel-with-php/#comment-3378 Wed, 21 Mar 2007 05:41:14 +0000 http://www.terminally-incoherent.com/blog/2006/07/12/read-excel-with-php/#comment-3378

Can you send us the format for

dd/mm/yyyy

Reply  |  Quote
]]>