PHP -> PEAR -> Excel_Spreadsheet_Writer

[bewhite]

Hello!

I am a PHP developer. I have to use Excel_Spreadsheet_Writer module in my website. I have working copy of the website on my local computer, but when I'm trying to upload it on hosting I see next error:

Fatal error: Class 'Spreadsheet_Excel_Writer' not found in /home/...

As I understand, I need to include line like "require_once "path_to_the_Writer.php"" in my PHP script. Can anyone from support tell me this path? Can any other developer tell me it?

Thanks.

[Serra]

If you are using "require_once" and it is failing, your path is wrong.

The path works the say way as it works for images. (provided that the script is below /public_html/

[bewhite]

Originally Posted by Serra

If you are using "require_once" and it is failing, your path is wrong.

Yes, the path is wrong. The question is what is the correct path?

Originally Posted by Serra

The path works the say way as it works for images. (provided that the script is below /public_html/

In my opinion, it is not related with the public_html folder. This module (Excel_Spreadsheet_Writer) is common for all hosting accounts on my server and installed somewhere in the PHP folder (c:\php\ by default).

Does anybody know this path?

[Serra]

Sorry, I misunderstood. I thought you were asking who to include PHP into PHP. If you want to include Perl modules into PHP, its fairly simple. You can't.

[bewhite]

Originally Posted by Serra

Sorry, I misunderstood. I thought you were asking who to include PHP into PHP. If you want to include Perl modules into PHP, its fairly simple. You can't.

I don't need the Perl. Excel_Spreadsheet_Writer is the PHP module. I just need to know path to it on the server. I need to use this path in the "require_once" .

[Serra]

Post exactly the require once line you used.

[bewhite]

Originally Posted by Serra

Post exactly the require once line you used.

I have found correct path to the module. Finally, working line is:
require_once "Spreadsheet/Excel/Writer.php";

Thank you for your help.

[chaloupe]

Their is a good tutorial here:
http://pear.php.net/manual/en/packag...iter.intro.php

require_once 'Spreadsheet/Excel/Writer.php';

Best Regards,

[bewhite]

Originally Posted by chaloupe

Their is a good tutorial here:
http://pear.php.net/manual/en/packag...iter.intro.php

require_once 'Spreadsheet/Excel/Writer.php';

Best Regards,

I have already found this information. I have wrote about it in my previous post. In all cases thanks for your help.

[Serra]

Wow, that is cool!

[tomowa]

I want to have an online spreadsheet, and don't really want to use Googles online spreadsheet setup.
Is that what this is all about doing? I looked at the link chaloupe posted it it doesn't explain (to me at least), what the concept of this spreadsheet writer is all about

Thanks, Tom

[Serra]

Ok, some stuff to remember when trying to use this.

1. php.ini override files change your include settings. They must be
include_path = ".:/usr/lib/php:/usr/local/lib/php"

The PEAR stuff is in the third path listed.

2. PEAR might be installed, items might be listed in CPANEL, but they may not be installed.

Use pear list to see what is installed.

In my case, OLE nor Spreadsheets were actually installed. In fact, it looks like almost nothing was installed. I installed OLE and Spreadsheets and it works fine now using the example code above.

Basically, this is a PHP module that allows programmers to write to xls files directly from PHP. If you upload the example in a php file, it will create a spreadsheet with the variables listed.

I wrote a quick program that dumps a file into a spreadsheet from a database.

[tomowa]

Yea, that is cool The code I copied from chaloupes link results in this www.tomowa.net/php_excel

 
 
<?php
require_once 'Spreadsheet/Excel/Writer.php';
 
// Creating a workbook
$workbook = new Spreadsheet_Excel_Writer();
 
// sending HTTP headers
$workbook->send('test.xls');
 
// Creating a worksheet
$worksheet =& $workbook->addWorksheet('My first worksheet');
 
// The actual data
$worksheet->write(0, 0, 'Name');
$worksheet->write(0, 1, 'Age');
$worksheet->write(1, 0, 'John Smith');
$worksheet->write(1, 1, 30);
$worksheet->write(2, 0, 'Johann Schmidt');
$worksheet->write(2, 1, 31);
$worksheet->write(3, 0, 'Juan Herrera');
$worksheet->write(3, 1, 32);
 
// Let's send the file
$workbook->close();
?>

What I want to do is take info as shown in my spreadsheet here http://spreadsheets.google.com/pub?k...TmEx_eXy3Z3xIw, (it's a log I keep data on irrigation wells for my employer), and be able to enter it from a web interface, ie enter the date, select the well, then enter the 3 pieces of data for each well. Then have it displayed in a webpage, to fit on one page for printing out simply.

What is the best way to do this? MySQL and PHP? If anybody knows of any tutorials that would get me going in the right direction, it would be appreciated

Tom

[Serra]

Originally Posted by tomowa

What is the best way to do this? MySQL and PHP? If anybody knows of any tutorials that would get me going in the right direction, it would be appreciated

Yea, this is NOT a good application of this software. What you want to do is a serious amount of work and not for the feint of heart. The way you are doing it is far better than programming a mysql interface.

The best use of this software is to take a mySQL database and export it as an excel. For that, it works wonderfully. I really had never done anything with PEAR before. Of course, it would have never worked because I didn't have any of it installed on my server, but now that I know how to install it, I may well use it more often.

[tomowa]

What you want to do is a serious amount of work and not for the feint of heart.

Thanks for the warning Serra I'm gonna shelve it then....I can't even find time to get to my exercise bike, which I actually enjoy , let alone tackle learning this

[Serra]

Originally Posted by tomowa

Thanks for the warning Serra I'm gonna shelve it then....I can't even find time to get to my exercise bike, which I actually enjoy , let alone tackle learning this

If you are having problems installing this, the correct commands would be:

pear install OLE-beta
pear install Spreadsheet_Excel_Writer-beta