Re: [PHP] How to read excel sheet and display it's contents.
Hi, There is oleread.inc file in Excel Folder. Please rename that file to oleread.php it will work.. =) Regards, Pradip Jadhav srihari naidu wrote: Hi, can any suggest me how to read and display the content in a html page. I tried phpexcelreadrer at http://sourceforge.net/projects/phpexcelreader/ but got error Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php) [function.require-once]: failed to open stream: No such file or directory in D:\phpdocs\reader2\Excel\reader.php on line 31 Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Reader/OLERead.php' (include_path='.;C:\php5\pear') in D:\phpdocs\reader2\Excel\reader.php on line 31 can any please suggest me the solution for this error please. Thanks in advance Regards, Sri Hari - Never miss a thing. Make Yahoo your homepage. -- View this message in context: http://www.nabble.com/How-to-read-excel-sheet-and-display-it%27s-contents.-tp15422690p24110951.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How to read excel sheet and display it's contents.
On Fri, Jun 19, 2009 at 09:17, jadhavpradipjadhavpradi...@gmail.com wrote: Hi, There is oleread.inc file in Excel Folder. Please rename that file to oleread.php it will work.. =) Please check the dates before posting on third-party sites to this list. That thread is over a year-and-a-half old. -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ 50% Off All Shared Hosting Plans at PilotPig: Use Coupon DOW1 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to read excel sheet and display it's contents.
to get phpexcelreader to work you must change the require_once line for this one require_once 'OLERead.inc'; tedd-2 wrote: At 3:46 PM -0800 2/11/08, Warren Vail wrote: I finally settled for CSV, but even there Microsoft plays games with the format, or so it seems. Yes, it's a bugger. M$ always has a better idea and replaces it daily. Stick with CSV and let applications sort it out. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- View this message in context: http://www.nabble.com/How-to-read-excel-sheet-and-display-it%27s-contents.-tp15422690p15510579.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to read excel sheet and display it's contents.
At 3:46 PM -0800 2/11/08, Warren Vail wrote: I finally settled for CSV, but even there Microsoft plays games with the format, or so it seems. Yes, it's a bugger. M$ always has a better idea and replaces it daily. Stick with CSV and let applications sort it out. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How to read excel sheet and display it's contents.
On Feb 11, 2008 5:51 PM, srihari naidu [EMAIL PROTECTED] wrote: Hi, can any suggest me how to read and display the content in a html page. I tried phpexcelreadrer at http://sourceforge.net/projects/phpexcelreader/ but got error Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php) [function.require-once]: failed to open stream: No such file or directory in D:\phpdocs\reader2\Excel\reader.php on line 31 Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Reader/OLERead.php' (include_path='.;C:\php5\pear') in D:\phpdocs\reader2\Excel\reader.php on line 31 STFW and RTFM. It means that the files being required do not exist where the script is looking for them. -- /Dan Daniel P. Brown Senior Unix Geek ? while(1) { $me = $mind--; sleep(86400); } ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to read excel sheet and display it's contents.
I think i am not clear with my question. I know that the files are missing at the correct location. Please suggest me any other free code that i can use instead of the code i tried. Thanks in advance. Regards, Sri Hari. Jay Blanchard [EMAIL PROTECTED] wrote: [snip] Hi, can any suggest me how to read and display the content in a html page. I tried phpexcelreadrer at http://sourceforge.net/projects/phpexcelreader/ but got error Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php) [function.require-once]: failed to open stream: No such file or directory in D:\phpdocs\reader2\Excel\reader.php on line 31 Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Reader/OLERead.php' (include_path='.;C:\php5\pear') in D:\phpdocs\reader2\Excel\reader.php on line 31 can any please suggest me the solution for this error please. [/snip] It is telling you that a file is missing or that you are pointed at the wrong location for the file. - Never miss a thing. Make Yahoo your homepage.
RE: [PHP] How to read excel sheet and display it's contents.
[snip] Hi, can any suggest me how to read and display the content in a html page. I tried phpexcelreadrer at http://sourceforge.net/projects/phpexcelreader/ but got error Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php) [function.require-once]: failed to open stream: No such file or directory in D:\phpdocs\reader2\Excel\reader.php on line 31 Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Reader/OLERead.php' (include_path='.;C:\php5\pear') in D:\phpdocs\reader2\Excel\reader.php on line 31 can any please suggest me the solution for this error please. [/snip] It is telling you that a file is missing or that you are pointed at the wrong location for the file. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to read excel sheet and display it's contents.
Yes, read the documentation and look at include and require in the php documentation. -Original Message- From: srihari naidu [EMAIL PROTECTED] Sent: Monday, February 11, 2008 5:51 PM To: PHP Mail List php-general@lists.php.net Subject: [PHP] How to read excel sheet and display it's contents. Hi, can any suggest me how to read and display the content in a html page. I tried phpexcelreadrer at http://sourceforge.net/projects/phpexcelreader/ but got error Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php) [function.require-once]: failed to open stream: No such file or directory in D:\phpdocs\reader2\Excel\reader.php on line 31 Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Reader/OLERead.php' (include_path='.;C:\php5\pear') in D:\phpdocs\reader2\Excel\reader.php on line 31 can any please suggest me the solution for this error please. Thanks in advance Regards, Sri Hari - Never miss a thing. Make Yahoo your homepage. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to read excel sheet and display it's contents.
This latest one is a new solution to me, but I have tried several others, only to have them fail in short order. Seems that excel formats have changed many times, and while some of these solutions work well with a particular release of excel (2007 for this one, I think), I found that every user out there seems to have a different version of excel (even within the same company), I finally gave up. If you can get your users to save their files in csv format, you might have better luck being able to read them, but don't hold me to it. Good Luck, Warren Vail I finally settled for CSV, but even there Microsoft plays games with the format, or so it seems. -Original Message- From: Michael McGlothlin [mailto:[EMAIL PROTECTED] Sent: Monday, February 11, 2008 3:36 PM To: srihari naidu Cc: php-general@lists.php.net Subject: Re: [PHP] How to read excel sheet and display it's contents. Tried http://www.codeplex.com/PHPExcel ? I think i am not clear with my question. I know that the files are missing at the correct location. Please suggest me any other free code that i can use instead of the code i tried. Thanks in advance. Regards, Sri Hari. Jay Blanchard [EMAIL PROTECTED] wrote: [snip] Hi, can any suggest me how to read and display the content in a html page. I tried phpexcelreadrer at http://sourceforge.net/projects/phpexcelreader/ but got error Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php) [function.require-once]: failed to open stream: No such file or directory in D:\phpdocs\reader2\Excel\reader.php on line 31 Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Reader/OLERead.php' (include_path='.;C:\php5\pear') in D:\phpdocs\reader2\Excel\reader.php on line 31 can any please suggest me the solution for this error please. [/snip] It is telling you that a file is missing or that you are pointed at the wrong location for the file. - Never miss a thing. Make Yahoo your homepage. -- Michael McGlothlin Southwest Plumbing Supply -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to read excel sheet and display it's contents.
[snip] I think i am not clear with my question. I know that the files are missing at the correct location. Please suggest me any other free code that i can use instead of the code i tried. [/snip] Convert the spreadsheet to CSV and then you can use fopen, fgets, etc. to read the file. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How to read excel sheet and display it's contents.
Tried http://www.codeplex.com/PHPExcel ? I think i am not clear with my question. I know that the files are missing at the correct location. Please suggest me any other free code that i can use instead of the code i tried. Thanks in advance. Regards, Sri Hari. Jay Blanchard [EMAIL PROTECTED] wrote: [snip] Hi, can any suggest me how to read and display the content in a html page. I tried phpexcelreadrer at http://sourceforge.net/projects/phpexcelreader/ but got error Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php) [function.require-once]: failed to open stream: No such file or directory in D:\phpdocs\reader2\Excel\reader.php on line 31 Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Reader/OLERead.php' (include_path='.;C:\php5\pear') in D:\phpdocs\reader2\Excel\reader.php on line 31 can any please suggest me the solution for this error please. [/snip] It is telling you that a file is missing or that you are pointed at the wrong location for the file. - Never miss a thing. Make Yahoo your homepage. -- Michael McGlothlin Southwest Plumbing Supply smime.p7s Description: S/MIME Cryptographic Signature
RE: [PHP] How to read excel sheet and display it's contents.
I have to agree with this, CSV is the way to go. While you have to train your users to save as CSV, you are better off using a more universal standard the microshaft standards. Sorry for the top posting, the Q doesn't like to bottom post. :/ Wolf -Original Message- From: Jay Blanchard [EMAIL PROTECTED] Sent: Monday, February 11, 2008 6:36 PM To: srihari naidu [EMAIL PROTECTED]; php-general@lists.php.net Subject: RE: [PHP] How to read excel sheet and display it's contents. [snip] I think i am not clear with my question. I know that the files are missing at the correct location. Please suggest me any other free code that i can use instead of the code i tried. [/snip] Convert the spreadsheet to CSV and then you can use fopen, fgets, etc. to read the file. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php