Use PEAR Library Spreadsheet_Excel_Writer?
I need to save some data in .xls file. I am trying to use PEAR library Spreadsheet_Excel_Writer. It is work. But now i am working with hosting without PEAR. Of cause, it is very terrible. Spreadsheet_Excel_Writer has a lot of dependencies. I need a module or code, which i can include in my scripts.
View 4 Replies (Posted: Aug 20 10 at 8:29)
Sponsored Links:
Related Forum Messages:
Pear Spreadsheet_Excel_Writer Question
I am using the Spreadsheet_Excel_Writer module from Pear to generate Excel spreadsheets from my application. Currently I am finding that when I create a new excel spreadsheet I get a message when opening the file saying: File error: Data may have been lost. Not sure what this is caused by or how to rectify it. I am trying to open the excel file with excel 2007.
Posted: August 10th, 2007 04:15 PM
View 2 Replies!
View Related
Pear Error - Spreadsheet_Excel_Writer
I am trying to use the Spreadsheet module, but keep getting an error. Warning: main(OLE/PPS/Root.php): failed to open stream: No such file or directory in /usr/local/www/vhosts/pmiwebconnect.com/htdocs/Spreadsheet/Excel/Writer/Workbook.php on line 39 Fatal error: main(): Failed opening required 'OLE/PPS/Root.php' (include_path='.:/usr/local/share/pear') in /usr/local/www/vhosts/pmiwebconnect.com/htdocs/Spreadsheet/Excel/Writer/Workbook.php on line 39 I uploaded all the files that came with it and did not see any Root.php files. Any ideas on this error message? Here is a list of the packages installed: %pear list Installed packages: =================== Package Version State Archive_Tar 1.1 stable Console_Getopt 1.2 stable HTML_Template_IT 1.1 stable Net_UserAgent_Detect 2.0.1 stable PEAR 1.3.5 stable XML_RPC 1.3.1 stable
Posted: 09-27-2005, 10:26 PM
View 2 Replies!
View Related
Writing An Excel File Using The PEAR Spreadsheet_Excel_Writer Package
I have a script that is writing an Excel file using the PEAR Spreadsheet_Excel_Writer package. Problem is the total file should have around 10,000 entries, but it only saves up to 5,990. and the script itself doesn't give me any errors. The error shows up when I try to open up the Excel file and it says its corrupt although i can visualize the results. The script runs for around 200 seconds, and I have set Apache's timeout to 500 and max_execution_time / max_input_time to 500 as well. Is there something I'm missing out on here?
Posted: 06-30-2005, 11:08 AM
View 3 Replies!
View Related
Make PDF Using Pear Library?
I wanted to make PDF using pear library of php.Check the link for File_PDF package at pear ttp:pear.php.net/package/File_PDFThe package does not have good documentation( none at all) and i cant find function implemented by it. Have anyone tried it? or know where i can find 1-2 examples based on it
Posted: Posted 09 February 2011 - 10:23 AM
View 2 Replies!
View Related
Standard PHP Library, PEAR, And Templates
Is the standard php library exclusively for PHP5 or is there one for PHP4? How do I start using it? Is there a require or include directive needed in order to make use of it? Same question for PEAR. Is there a PEAR for PHP4 or only for PHP5? How do I start using its facilities? Is there a require or include directive? Lastly, I'd like to start using templates. From what I've read, they simplify code so I don't have to play quoting games like: echo "foo="blah"" . $foo['bar'] . 'blah' . "bar$foo="blah""; which is a real drag. I can usually simplify lines like above, but they never completely simplify to my satisfaction. Googling revealed a bunch of template libraries. Is there a generally accepted standard one?
Posted: November 27th, 2005 11:45 PM
View 2 Replies!
View Related
Install XML_RPC2 Package From PEAR Library?
I'm trying to install XML_RPC2 package from PEAR library, but whenever I type a proper command (pear install XML_RPC2) I'm getting an error: pear/XML_RPC2 requires PHP extension "curl" No valid packages found install faild Strangely enough command $ pear package-dependencies xml_rpc2 returns information "this package does not have any dependencies" (works fine in any other case). I've also tried with older versions of XML_RPC2 - same thing. It's the first packege I have problem with. I'm sure curl is enabled and it's work(tested). Beside that I have installed all others components listed on dependencies list(PHP 5.3, PEAR 1.9.2, Cache_Lite 1.7.9). I'm working on standard WAMP installtion on Windows XP.
Posted: Mar 6 at 22:04
View 2 Replies!
View Related
Custom Library With Pear Local Installation?
i wish to be able to deploy a PHP web application along with a local installation of PEAR. To be more specific, i am trying to find a way to do a 'per-application' or local installation of PEAR if this is possible.For example:The application 'MyApplication' is located in: /var/www/applications/myapplicationThe php library is located in: /var/www/applications/myapplication/librarI looking for a way to do a per-application installation of PEAR since not all applications are managed by me (and i want to control which PEAR packages are installed and when).I found some tutorials for a local PEAR installation (on a shared host) but i don't know if my scenario fits the one for a local PEAR installation.
Posted: Jun 3 10 at 17:47
View 1 Replies!
View Related
Firefox4/5 Not Running JS Attached To An AJAX Response Using HTML_AJAX Pear Library?
I am using the HTML_AJAX package in PEAR (admittedly an old library, but it has worked fine for me for a couple of years and I don't want to leave my infrastructure). The problem I am having is that with the introduction of Firefox 4, and now also Firefox 5, JavaScript that is included in responses using HTML_AJAX.replace(div_target, request_page) [API is to replace div_target with the response from request_page] has stopped working. It works fine on Chrome, IE9, Android, iPhone, etc. but not FF4/5. Is this some sort of new feature, security mechanism, or just a plain old bug? If it's a bug, is it a bug with HTML_AJAX (i.e. you can do it with jQuery?) or is this something FF needs to fix? Example.This page exists: <script type="text/javascript" language="JavaScript"> function do_replace(){ HTML_AJAX.replace("something", "index.php?key=value"); // index.php will have html mixed with JS and paste it to the div "something". } </script> [Code]... I tried finding the answer to this by searching but couldn't find anything conclusive.
Posted: Jun 26 at 9:40
View 2 Replies!
View Related
Spreadsheet_Excel_Writer Question
I am using Spreadsheet_Excel_Writer and it works great for creating Excel files on the fly. However, I am having trouble trying to get some data to be saved correctly. We have UPCs, like 050000235001, and the leading zero gets removed. I know in Excel you can format the cell to a text type, but how do I do that when creating the spread sheet? There is setNumFormat() but that only formats number types, like percentages, dates, times, etc.
Posted: 11-18-2005, 11:07 PM
View 3 Replies!
View Related
Spreadsheet_Excel_Writer Fatal Error
I am switching hosts and copying the files over without change. I get the following error when trying to create a spreadsheet: Fatal error: Call to a member function on a non-object in /home/pmiweb/www/www/download_stores.php on line 68 Here is the code from the page: ....
Posted: 01-21-2007, 09:08 PM
View 3 Replies!
View Related
Spreadsheet_Excel_Writer Data Output Is Damaged?
I use Spreadsheet_Excel_Writer to generate .xls file and it works fine until I have to deal with a large amount of data. On certain stage it just writes some nonsense chars and quits filling certain columns. However some columns are field up to the end (generally numeric data) I'm not quite sure how the xls document is formed: row by row, or col by col... Also it is obviously not an error in a string, because when i cut out some data, the error appears a little bit further. I think there is no need in all of my code here are some essentials $filename = 'file.xls'; $workbook = & new Spreadsheet_Excel_Writer(); $workbook->setVersion(8); [code]....
Posted: Apr 20 10 at 11:04
View 2 Replies!
View Related
Output More Than 255 Characters In An Excel Cell Using Spreadsheet_Excel_Writer()?
I am trying to output a few paragraphs of text in an Excel spreadsheet, but right now the text is truncated to display only 255 characters. The code is pretty straightforward: $xls =& new Spreadsheet_Excel_Writer(); $sheet =& $xls->addWorksheet($name); foreach ($rec as $field) { $rec = ($rec['data'] ? $rec['data'] : $rec); $sheet->write($row, $col++, $field); } Is there anything I can do to get all of the text, not just the 255 chars?
Posted: May 11 09 at 21:30
View 1 Replies!
View Related
PEAR Sendmail - Fatal Error: 'PEAR.php' Is Not A Valid Path
Code: [Select] require '/usr/share/php/Mail.php'; $recipients = 'dennismonsewicz@gmail.com'; $headers['From'] = 'me@me.com'; $headers['To'] = 'dennismonsewicz@gmail.com'; $headers['Subject'] = 'Test message'; $body = 'Test message'; [Code]... If I do not include the file using an absolute path I get the following error message: Code: [Select]Fatal Error: 'PEAR.php' is not a valid path But if I include the file with the absolute path I then get a blank page....
Posted: December 10, 2009, 04:52:14 PM
View 3 Replies!
View Related
PEAR Newbie Trying To User PEAR DB And Falling At The First Hurdle
I've just installed PEAR on my local machine and all is well, updated the include_path to point to my PEAR dir. So, when I just try to make a simple connection like so the script just seems to stop but no error messsages. I do get error messages normally (ie. when I can a method from an object that doesnt actually exist) as I have set...
Posted: Mon, 03 Dec 2007 04:08:59 UT
View 11 Replies!
View Related
Installing Pear With Wamp - Could Not Open Input File: "PEARgo-pear.phar"
I'm having problems installing pear on my local machine that has Wamp installed. Full setup as follows Windows XP Pro Wamp Server Version 2.0 php 5.3.0 I'm reading all over the net that pear has install issues with php 5.3. if i open a dos window and type C:wampinphpphp5.3.0go-pear.bat. I get an error saying: Could not open input file: PEARgo-pear.phar I've tried the workaround that is stated as getting round this problem php -d phar.require_hash=0 go-pear.phar but this doesn't work as I get this error Could not open input file: go-pear.phar I have tried the non-pharred version from [URL] and run it in the command window using the command below and also from a browser window by pointing to go-pear.php php -q go-pear.php I get lots of "PHP Deprecated: Function ereg() is deprecated in" errors and the install doesn't go correctly.
Posted: May 26, 2010, 12:59
View 1 Replies!
View Related
Invalid Library (maybe Not A PHP Library) 'libmysql.dll' PHP5
WinXP Pro, Apache 1.3.27, trying to add PHP 5.0.4 with MySQL support to the mix. Everything works fine until I add 'extension=libmysql.dll' to php.ini, and then starting Apache gives me the same error popup two or three times, all with the same message: PHP Startup: Invalid library (maybe not a PHP library) 'libmysql.dll' I've tried all manner of variations of extension_dir, and copied libmysql.dll from the php5 distro into c:windowssystem32, all to no avail. PHP seems to work otherwise, but there's no MySQL support.
Posted: July 17th, 2005 01:30 PM
View 6 Replies!
View Related
Use Zfdatagrid Library In Application / Tack Overflow Thread Zend Framework 1.10 Custom Class Inside Library Folder Not Found?
I am seeking to learn how to implement a grid in an application I am working on and I figured I will use zfdatagrid as it seems to take care of some of the features I need. However there is not much by way of tutorial on the net. Probably because its easy to figure out, but thing is I need help to understand how use it. I will appreaciate any link that can help or if one will be kind to give me some pointers here. I now get the following error: Fatal error: Class 'Bvb_Grid' not found in D:wwwlabzfdatagridapplicationcontrollersIndexController.php and below is my indexAction public function indexAction() { //Zend_Config $config = new Zend_Config_Ini(getcwd().'..applicationgridsgrid.ini', 'production'); var_dump($config); //Grid Initialization $grid = Bvb_Grid::factory('Bvb_Grid_Deploy_Table', $config, 'id'); //Setting grid source $grid->setSource(new Bvb_Grid_Source_Zend_Table(new Bugs())); //CRUD Configuration $form = new Bvb_Grid_Form(); $form->setAdd(true)->setEdit(true)->setDelete(true); $grid->setForm($form); //Pass it to the view $this->view->pages = $grid; $this->render('index'); } The Bvb library is located in the Library folder. Well silly me I found the solution to the problem in another Stack Overflow thread Zend Framework 1.10 custom Class inside library folder not found I thought of deleting the question then I thought this may save someone following this thread a google.
Posted: Nov 5 10 at 13:19
View 1 Replies!
View Related
PEAR Channel - Easier Alternatives Than Setting Up My Own PEAR Channel?
So I guess a PEAR channel is like a server that lets you distribute your own PEAR packages? I was under the impression PEAR was sort of dead, until I started looking at Symfony (is it dead? I haven't used it in the past so maybe someone with more experience in PHP can comment on its state and whether it makes sense to invest any time in it) Anyway my question. Why do I need to set up my own PEAR channel? There's a page here maintained by the PEAR project http://pear.php.net/channels/ but it looks like it may be just a list of PEAR channels as opposed to a public PEAR channel. Are there easier alternatives than setting up my own PEAR channel?
Posted: Sep 20 10 at 0:20
View 3 Replies!
View Related
Pear Shaped PEAR
I read about PEAR in here a few days ago and thought I would give it a try but I have got myself in a mess with the installation. I have found some guides but they seem to move swiftly on from installation and get down to using it. I am using PHP 5.2.3 which came with NuSPhere PhED and is installed under...
Posted: Sat, 27 Oct 2007 23:21:28 UT
View 1 Replies!
View Related
GD Library And The FreeType Library
To use ImageTTFText() it says on php.net that you have to have the following... This function requires both the GD library and the FreeType library. can someone just confirm for me quickly, this is something that needs to be installed on the server? before i hassle my host as to why it says nowhere on their site if its installed or not.
Posted: July 6th, 2001, 02:16 PM
View 5 Replies!
View Related
To PEAR Or NOT To Pear?
This is just a discussion type post, I'm interesed to know your opinion and experiance with Pear Libraries, I have used some Pear libraries a while back, but not enough to form an opinion wheather it is worth it or not. Some of the question I have is scalability and performance specs, and if I ever have to switch hosts do I need to make sure they have the same version or are they usualy backward compatible... so to Pear or Not to Pear that is the question?
Posted: November 12th, 2003, 12:09 PM
View 1 Replies!
View Related
PEAR DB Help
I am currently running Windows XP Pro with PHP 5.2 and MySQL 5.0 installed. My remote server is a UNIX system with PHP 5.1 installed and MySQL 5.0 installed. Here is the code I'm trying to run: // Load up the PEAR DB class // $this->mysql = DB::connect(sprintf("%s://%s:%s@%s/%s", TYPE, USERNAME, PASSWORD, HOST, DATABASE)); echo "hello"; On my computer it works perfectly fine, returns a db_mysql class and no errors. On my server it does nothing. I put echo "hello" there as a test, and when I run the script I don't even see "hello" get printed to the screen, for some reason it's just screwing the entire script up. I checked the USERNAME, PASSWORD, etc. values against the ones I have in CPANEL and they match. Does anyone know what might be causing this problem?
Posted: December 17th, 2006, 11:11 PM
View 5 Replies!
View Related
OOP And Pear::DB
I am currently working on a PHP application which I am using as a personal learning environment for getting a better working understanding about how to tackle application development in an OOP/MVC pattern fashion. I am using PEAR::DB to create database connection objects, and my major question concerns where these objects should be created. For example: Let's say I have a login application that that has a controller-like script that looks something like this: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ // login.php <?php require_once('User.class.php'); $user = new $User; $user->getAdminRights(); ?> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ....and a model-like User class that looks something like this: (The important note is that I may need to load data multiple times from a database.) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ // User.class.php <?php class User { public $user_name; public $user_id; public $admin_rights = array(); protected $db_connection; function __construct() { if (!this->db_connection){ require_once(); $this->db_connection = DB::connect(DB_DSN); } $sql = "SELECT USERNAME, USER_ID FROM SOME_TABLE..."; $result = $this->dbh->getAll($sql, array($this->request_id); $this->user_name = $result['USERNAME']; $this->user_id = $result['USER_ID']; } function getAdminRights() { $sql = "SELECT * FROM SOME_TABLE WHERE ADMIN_ID = ?"; $this->admin_rights = $this->dbh->getAll($sql, array($this->user_id); } } ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Posted: July 17th, 2005 12:08 PM
View 3 Replies!
View Related
Pear
kann somebody tell me what i do wrong? i write this little script: <?php include_once "DB.php"; // Example: echo "Hi"; ?> then, i have the first page von "go-pear"
Posted: May 17th, 2006 10:15 AM
View 4 Replies!
View Related
PEAR: Is It Really Necessary?
I've been using PHP for a while now but I haven't actually used PEAR. I have just read half a chapter in a book, it sounds alright but haven't actually used it. I was just wondering, is it really necessary to use PEAR? I usually get things done using PHP/MySQL. I don't know if I'm really missing out on something by not using PEAR. How highly is it recommended? On most job ads, i don't even see them mentioning PEAR. They mostly just say PHP/MySQL.. Why is that? Don't people like PEAR much?
Posted: July 28th, 2006 12:45 PM
View 5 Replies!
View Related
To Pear DB Or Not To Pear DB?
i'm developing a small web app for a non-profit i'm affiliated with and i'm not sure if i want to use the pear DB abstraction layer or not. i've got a simple page currently developed w/o it, so all my database calls are using MySQL specific functions. i know that using the pear DB is good if, say, we end up changing databases down the road, but i highly doubt we will. i mean, MySQL isn't going anywhere, right? anyhow, i just simply don't like pear DB. maybe the fact that it took me a friggin hour to install it has something to do w/ that. also, i'm re-writing the simplest of code using DB functions and i'm having a hell of a time, probably b/c i have nothing but a cheesy pear manual to go by.
Posted: 02-02-2004, 01:23 AM
View 6 Replies!
View Related
A DB.php PEAR
I am preparing a few PHP scripts conversion to registerglobals=Off And presently testing a new login script that requires PEAR I tested it on my local RH and it works fine in both configurations (with registerglobals On or Off) But on a production server that I do not manage it does not work. And does not display anything (Blank screen)In order to narrow down the problems I used <? Error_reporting (E_ALL) ;?> Which shows that my “require” for DB.PHP class does not find it. How can I find if PEAR is made available? And if it is. Is the directory that contains the PEAR files included in my include_path in my php.ini. And if so do I have to provide a path?
Posted: 8:48 pm on Feb. 15, 2004
View 1 Replies!
View Related
|
TRACKER
