2 Techniques
Access the raw Excel Binary File
Use the Excel API
Both techniques have their advantages and disadvantages as you will see during this presentation
Access the raw Excel Binary File – 1
There is a php library written that can access a raw Excel binary file. Benefits include that it is easy and straight forward to use, has [...]
Posts Tagged ‘php’
how to read excel file in php
Posted by Bagesh Singh on July 2nd, 2010
Posted in Home, Others, how-to, php, tips and technique, tutorial 
Tags: Excel, excel reader, file reader in php, php 
No Comments »
list all string functions in php : php String function list is very userfull in any language
Posted by Bagesh Singh on June 7th, 2010
PHP is very powerful server side programming language.
It has lots of powerful functions which speed up the php development and also the performance. While developing a flexible and good web application we always need list of string handling functions.There are lots of php functions and I am giving you a [...]
Posted in Home, Interview Question, Php interview question, php, tutorial Tags: php, php string function, string function Comments Off
Sending e-mail from localhost in PHP in Windows Environment
Posted by Bagesh Singh on June 3rd, 2010
Have you ever been frustrating, why e-mail is not going from the localhost while using XAMPP or WAMP or any other PHP servers in windows environment? well in that situation i think i can help you.In this article i am going to tell you how to send e-mail from localhost in PHP.
1) [...]
Wikilinki Ver 1.0 Released
Posted by Bagesh Singh on April 7th, 2010
For last few days I have been trying to understand wordpress ins and outs, and had an idea of developing simple plugin for [wiki]wordpress[/wiki]. I thought people would want to give the reference of most of the words they use in their post to wikipedia, and placing it manually would be [...]
Mapping The IP Address to Latitude and Longitude In Google Maps
Posted by Bagesh Singh on April 7th, 2010
At last I found hostip.info provides a service for getting the latitude and longitude of a place on the basis of the user’s ip address. Its light weight and free, rather than downloading bulky database and getting paid services, for getting latitude and longitude on the basis of IP.
Here is the [...]
Posted in php, tips and technique, website review Tags: Google Maps, ip, latitude, longitude, php Comments Off
Ajaxified File Uploader Using IFrame
Posted by Bagesh Singh on April 7th, 2010
Today, while writing a code for AJAX file uploader, I was trying to do with [wiki]SALAJAX[/wiki]. But, with SALAJAX I could not manage to send the headers for $_FILES. So I thought of an alternative. And the alternative was to load the action page of the form on [wiki]IFrame[/wiki], whose display [...]
Posted in Magento, PHP Third Party Tools, ajax, php, tips and technique Tags: ajax, fileupload, php Comments Off
Newsletter Email Tracking: Read or Not?
Posted by Bagesh Singh on April 7th, 2010
I have completed first phase of a simple, yet useful Newsletter System. When I demonstrated to the clients, they came up with a question if the newsletter being send was opened or not by the newsletter subscribers ? I then thought.. let see how its done. Then I came with this [...]
Adding Related Product and other links to Product in Magento
Posted by Bagesh Singh on April 7th, 2010
Here is a simple way of adding product link such as Related, Upsell and Crosssell Link to a product in Magento. I just got the way of doing this and thought to share! So kind of me
01
/**
02
First Create Link Array of following type
03
**/
04
05
$linkArray=array(‘product_id’=>array(‘position’=>’’));
06
07
/**
08
Then set the Link Data
09
**/
10
11
/** For Upsell Link**/
12
$product->setUpSellLinkData($linkArray);
13
14
/** For [...]
Converting Text to Image in PHP formatted by alignment
Posted by Bagesh Singh on April 7th, 2010
During one of my project works I came across a situation like changing the input of TINYMCE editor to image. Can you believe what can be the user’s requirement? Basically what the client needed was to change the text to image and text should be in American Typewriter Font with [...]
General Workflow of Magento’s Import/Export – Dataflow
Posted by Bagesh Singh on April 7th, 2010
Magento’s Dataflow (Inport/Export) is one of distinguishing feature that makes Magento the leader in eCommerce Software. But for a programmer to understand how it workes in Magento can be quite nasty. I tried to understand how it workes and came up with following understanding.
General Work Flow (Profile)
During Import/Export there are normally [...]
Posted in Magento, PHP Third Party Tools, php, tips and technique Tags: Dataflow, Export, Import, Magento, php Comments Off
